private void work1()
{
string str = "server=.;database=hotel;user=tmp;password=tmp";
SqlConnection conn = new SqlConnection(str);
SqlCommand cmd1 = new SqlCommand("insert into sheet3(iddd) values('12')", conn);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close(); string str1 = "server=.;database=hotel;user=tmp;password=tmp";
SqlConnection conn1 = new SqlConnection(str1);
SqlCommand cmd2 = new SqlCommand("insert into sheet3(iddd) values('1111111111111111111111')", conn1);
conn1.Open();
cmd2.ExecuteNonQuery();
conn1.Close();
} private void work2()
{
string str = "server=.;database=hotel;user=tmp;password=tmp";
SqlConnection conn = new SqlConnection(str);
SqlCommand cmd2 = new SqlCommand("insert into sheet3(iddd) values('1111111111111111111111')", conn);
conn.Open();
cmd2.ExecuteNonQuery();
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
work1();
work2();//此方法会有异常
}
catch
{
ContextUtil.SetAbort();
}
}
work2方法处理有异常的时候 work1照样执行,
有什么办法解决吗?
{
string str = "server=.;database=hotel;user=tmp;password=tmp";
SqlConnection conn = new SqlConnection(str);
SqlCommand cmd1 = new SqlCommand("insert into sheet3(iddd) values('12')", conn);
conn.Open();
cmd1.ExecuteNonQuery();
conn.Close(); string str1 = "server=.;database=hotel;user=tmp;password=tmp";
SqlConnection conn1 = new SqlConnection(str1);
SqlCommand cmd2 = new SqlCommand("insert into sheet3(iddd) values('1111111111111111111111')", conn1);
conn1.Open();
cmd2.ExecuteNonQuery();
conn1.Close();
} private void work2()
{
string str = "server=.;database=hotel;user=tmp;password=tmp";
SqlConnection conn = new SqlConnection(str);
SqlCommand cmd2 = new SqlCommand("insert into sheet3(iddd) values('1111111111111111111111')", conn);
conn.Open();
cmd2.ExecuteNonQuery();
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
work1();
work2();//此方法会有异常
}
catch
{
ContextUtil.SetAbort();
}
}
work2方法处理有异常的时候 work1照样执行,
有什么办法解决吗?
解决方案 »
- 求extern "C" 用法解释
- 存储过程和在程序中调用
- CrystalReport里表的问题
- 关于Enterprise Library中logging 的几人问题,很困惑,请大家帮帮忙!
- C#怎样实现跳出窗体外的控件,类似QQ聊天窗口的表情选择框?
- 在vs2003中,应该如何去掉DATAGRIDE自动成生的COLUMN?
- 关于DrawImage(如何生成和源图同bit color的新图)
- 如何使用C#获得Active Directory的模式信息?
- 如何判断一个文件是文件夹还是一个文件啊?*(谢谢,在线等)
- 主窗体里绑到用户自定义控件中的控件???~~~
- label控件文字读取失败怎么解决?
- List<T> 比较的问题,
看看用数据库回滚应该可以满足你的要求,代码太长了,自己去看看吧