public string SaveMuteData1(string strDB, DataSet[] ds, string[] strSQL, Hashtable htParm)
{
string str;
SqlParameter[] sqlParm = new SqlParameter[htParm.Count];
int j = 0;
foreach (DictionaryEntry de in htParm)
{
sqlParm[j] = new SqlParameter(de.Key.ToString(), de.Value);
j++;
}
SqlConnection con = new SqlConnection(this.GetConStr(strDB));
int intCnt = ds.Length;
con.Open();
SqlTransaction tran = con.BeginTransaction();
try
{
for (int i = 0; i < intCnt; i++)
{
SqlCommand myComm = new SqlCommand {
Connection = con,
Transaction = tran,
CommandText = strSQL[i]
};
myComm.Parameters.AddWithValue(sqlParm[0].ParameterName, sqlParm[0].Value);
myComm.CommandTimeout = 0;
SqlDataAdapter myAdt = new SqlDataAdapter {
SelectCommand = myComm
};
SqlCommandBuilder bd = new SqlCommandBuilder(myAdt);
myAdt.Update(ds[i]);
myComm.Dispose();
}
tran.Commit();
str = "";
}
catch (Exception ex)
{
tran.Rollback();
str = ex.Message;
}
finally
{
tran.Dispose();
}
return str;
}
uj5u.com熱心網友回復：
你不是trycatch了嘛，是不是程式出錯回滾了，然后你又把捕獲的錯誤放到str里，然后你沒看str？uj5u.com熱心網友回復：
沒有報錯，代碼執行成功的，然后查看了下后臺資料庫，主表資料沒有，子表資料有了轉載請註明出處，本文鏈接：https://www.uj5u.com/net/29667.html
標籤：C#