62,040
社区成员
发帖
与我相关
我的任务
分享
for (int n = 1; n < sysl + 1; n++)
{
sqlCom[n - 1] = "INSERT into TM_materielsCN(jz,sy,la,gw,code,wlmc,sl,cn) SELECT jz,sy" + n + ",la,gw,code,wlmc,sl,cn FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source =" + Server.MapPath("TM/master.xls") + ";Extended properties=Excel 5.0')...[Sheet1$]";
}
public bool ExceTran(string[] sqlcom)
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlcon;
sqlCmd.Transaction = sqlcon.BeginTransaction(); //完成事务处理的前期准备工作
try
{
//将数据写入数据库
string[] SQLstringList = sqlcom;
for (int i = 0; i < SQLstringList.Length; i++)
{
string SQLstr = SQLstringList[i].ToString();
if (SQLstr.Trim().Length > 1)
{
sqlCmd.CommandText = SQLstr;
sqlCmd.ExecuteNonQuery();
}
}
sqlCmd.Transaction.Commit();
//Response.Write("<script language=javascript>alert('Operate Succeed!')</script>");
return true;
}
catch (Exception exe)
{
// sqlCmd.Transaction.Rollback();
sqlCmd.Transaction.Rollback();
//Response.Write("<script language=javascript>alert('Error! PLS check your data!')</script>");
return false;
}