asp.net 通过后台Javascript 上传表数据
欢迎进入.NET社区论坛,与300万技术人员互动交流 >>进入
Upload.aspx:
<%@ LANGUAGE='JAVASCRIPT' %>
<!-- #include file = "/adojvs.inc"-->
<!-- #include file = "/conn.inc"-->
<%
// 执行SQL语句
//2012-12-6 Gu Laicheng
function RunSQL(MySQL)
{
var ret="";
var rs1 = Server.CreateObject("ADODB.Recordset");
rs1.CursorType = adOpenKeyset;
rs1.LockType = adLockBatchOptimistic;
// Response.Write("<br/>" + MySQL + "");
try {
rs1.Open(MySQL,conn);
}
catch (ex) {
var ErrStr,ErrStr0,ErrStr1="==>"+new Date()+"<br/>";
ErrStr0 = "Error:"+ex+"<br/>"+MySQL;
var o = conn.Errors;
for (var i=0;i<o.Count;i++)
{
ErrStr1 += o.Item(i)。Number + ":" + o.Item(i)。Description+", "+o.Item(i)。SQLState+";"+o.Item(i)。Source ;
}
ErrStr =ErrStr0+"<br/>"+ErrStr1;
o.Clear();
Response.Write("<br/>" + ErrStr + "");
}
if(rs1.State==1)
{
if (!(rs1.BOF && rs1.EOF))
{
ret = rs1(0)。value;
}
rs1.Close();
}
return ret;
}
var Class = {
create: function() {
return function(n) {
this.initialize.apply(this, arguments);
}
}
}
[1]
【责编:peter】