asp.net 通过后台Javascript 上传表数据

30次阅读

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);
}
}
}

正文完