System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(SqlHelper.connectionString);
conn.Open();
System.Data.SqlClient.SqlTransaction trans = conn.BeginTransaction();
try
{
// 删除操作
...
// 更新操作
...
trans.Commit();
}
catch
{
trans.Rollback();
page.ClientScript.RegisterStartupScript(typeof(Page),"<script>alert('操作失败!')</script>");
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
conn.Close();
}
page.ClientScript.RegisterStartupScript(typeof(Page),"<script>alert('操作成功!')</script>");
当发生异常时,page.ClientScript.RegisterStartupScript(typeof(Page),"<script>alert('操作成功!')</script>");
这条语句也会被执行了!!?要怎么写?
conn.Open();
System.Data.SqlClient.SqlTransaction trans = conn.BeginTransaction();
try
{
// 删除操作
...
// 更新操作
...
trans.Commit();
}
catch
{
trans.Rollback();
page.ClientScript.RegisterStartupScript(typeof(Page),"<script>alert('操作失败!')</script>");
}
finally
{
if (conn.State == System.Data.ConnectionState.Open)
conn.Close();
}
page.ClientScript.RegisterStartupScript(typeof(Page),"<script>alert('操作成功!')</script>");
当发生异常时,page.ClientScript.RegisterStartupScript(typeof(Page),"<script>alert('操作成功!')</script>");
这条语句也会被执行了!!?要怎么写?
放到try里
这句写到这里try
{
// 删除操作
...
// 更新操作
...
trans.Commit();
page.ClientScript.RegisterStartupScript(typeof(Page)," <script>alert('操作成功!') </script>"); }
page.ClientScript.RegisterStartupScript(typeof(Page)," <script>alert('操作成功!') </script>");