public void UpdateSubTasks(DataTable dtSubTasks,string strEmpName)
{
DBOpen(),C#如何编写并调用DLL;
System.Data.SqlClient.SqlTransaction Trans,C#如何根据采样的点画函数图像？;
Trans = cn.BeginTransaction("UpdateSubTasks");
cmd.CommandType = CommandType.StoredProcedure,C#如何将Excel导入到数据库;
cmd.Transaction = Trans;
cmd.Connection = cn,C#如何实现图片分块延时显示;
try
{
cmd.CommandText = "WM_UpdateSubTasks";
foreach (DataRow dr in dtSubTasks.Rows)
{
if(dr["Buyer"].ToString().Trim()!="")
{
cmd.Parameters.Clear();
cmd.Parameters.Add("@subTaskNo",SqlDbType.VarChar,30).Value = dr["subTaskNo"].ToString().Trim();
cmd.Parameters.Add("@Buyer",SqlDbType.VarChar,20).Value
= dr["Buyer"].ToString().Trim();
cmd.Parameters.Add("@Director",C#如何实现FTP在服务器上遍历文件夹,SqlDbType.VarChar,20).Value = strEmpName.Trim();
cmd,C#如何多次连接数据库啊？.ExecuteNonQuery();
}
}
Trans.Commit();
}
catch (System.Exception ex)
{
Trans.Rollback();
throw new Exception(ex.Message);
}
finally
{
if(cn.State != ConnectionState.Closed)
{
cn.Close();
}
}
}
(责任编辑：admin)
|
QQ空间
腾讯微博
腾讯朋友
收藏