读书人

保存超时为什么数据却保存成功?解决

发布时间: 2012-05-04 12:36:09 作者: rapoo

保存超时,为什么数据却保存成功?
WEBSERVICE 一个插入数据函数

[WebMethod]
public string InsertData(DataTable dt)
{
SqlConnection conn2 = GetConn();
SqlTransaction t = conn2.BeginTransaction();
SqlCommand Cmd = conn2.CreateCommand();
Cmd.Transaction = t;

try
{
foreach (DataRow dr in dt.Rows)
{

Cmd.Parameters.Clear();
Cmd.CommandText = "insert into productdata(orderdate,ordernumber,address,customer,phone,specification,receivable,remark,station,depot,arristationdate) Values(@orderdate,@ordernumber,@address,@customer,@phone,@specification,@receivable,@remark,@station,@depot,@arristationdate)";

Cmd.Parameters.Add(new SqlParameter("@orderdate", dr["orderdate"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@ordernumber", dr["ordernumber"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@address", dr["address"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@customer", dr["customer"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@phone", dr["phone"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@specification", dr["specification"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@receivable", dr["receivable"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@remark", dr["remark"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@station", dr["station"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@depot", dr["depot"].ToString()));
Cmd.Parameters.Add(new SqlParameter("@arristationdate", dr["arristationdate"].ToString()));

int intResult=Cmd.ExecuteNonQuery();
}

t.Commit();

}
catch (Exception ext)
{
t.Rollback();
return (ext.Message);

}
finally
{
Cmd.Clone();
conn2.Close();
}
return ("true");
}



客户端调用插入数据:

private void buttonSave_Click(object sender, EventArgs e)
{

dataGridView1.EndEdit();
bscustomers.EndEdit();

DataTable result = (DataTable)bscustomers.DataSource;
DataTable tableAdded = result.GetChanges(DataRowState.Added);
if (tableAdded != null && tableAdded.Rows.Count > 0)
{
string strvalue = s.InsertData(tableAdded);

if (strvalue == "true")
{
MessageBox.Show("保存成功");
((DataTable)(bscustomers.DataSource)).AcceptChanges();
}
else
{
MessageBox.Show(strvalue);
}

}
}

上面是使用C#调用WEBSERVICE插入数据,如果数据提交出错,程序是会自动回滚的,事务处理我测试过了,可以执行

但是当保存数据超时时,程序出错,提示超时。数据没提示成功,但我查了数据库,数据居然已被插入成功了。我估计程序连
if (strvalue == "true")这句也还没开始执行就超时了,请帮忙解答,有什么解决办法,谢谢帮忙






[解决办法]
你把后面的try.....catch....final 去掉 试试

读书人网 >C#

热点推荐