winform在事务中同时调用两存贮过程。其中出错后发现未回滚！

@信心 2012-02-10 05:50:13

winform在事务中同时调用两存贮过程。其中出错后发现未回滚！只是从出错地方停止了，请大家指导一下，谢谢了！

string connetstrl = boperate.DatabaseConnetString;
SqlConnection con = new SqlConnection(connetstrl);
con.Open();
SqlTransaction st = con.BeginTransaction();
SqlCommand com = con.CreateCommand();
try
{
com.Transaction = st;
Co_Info_Save();
Co_List_Save();
st.Commit();
}
catch (Exception ex)
{
MessageBox.Show("存档出错,原因" + ex.StackTrace);
st.Rollback(); }
finally
{ con.Close();
st.Dispose();

private void Co_Info_Save()
{
try
{
int rowsAffected = 0;
SqlParameter[] parameters = {
new SqlParameter("@colno", SqlDbType.VarChar,30),
new SqlParameter("@fdate", SqlDbType.DateTime)
................... };

parameters[0].Value = txtcolNo.Text.ToString ();
parameters[1].Value = Convert.ToDateTime(txtfDate1.Text

...........................);
RunProcedure("CoInfo_Add", parameters, out rowsAffected);

catch (Exception ex)
{ MessageBox.Show("报错,原因" + ex.StackTrace); }
}
private void Co_list_Save()
{
try
{
/;
for (int i = 0; i <= CoDetail.Rows.Count - 1; i++)
{
s
decimal sum =Convert.ToDecimal(CoDetail.Rows[i].Cells[5].Value.ToString());
decimal count = Convert.ToDecimal(CoDetail.Rows[i].Cells[6].Value.ToString()
..........
);

SqlParameter[] parameters = {
new SqlParameter("@Colno", SqlDbType.VarChar,30),
new SqlParameter("@desc", SqlDbType.NChar,10)}
......
parameters[0].Value = txtPolNo.Text.ToString();
parameters[1].Value = i.ToString().Trim ()
......
RunProcedure("CoList_Add", parameters, out rowsAffected);

}
}
catch (Exception ex)

{ MessageBox.Show("报错,原因:" + ex.StackTrace); }

}

}

...全文