asp.net 事务例子
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn;
SqlCommand cmd1, cmd2;
SqlTransaction tra;
conn = new SqlConnection("server=.;database=test;uid=sa;pwd=123");
conn.Open();
tra = conn.BeginTransaction();//开始事务
cmd1 = new SqlCommand("update Test set StuName='佳儿' where StuScore=111", conn);
cmd2 = new SqlCommand("update Test set StuName='fdsafdsafdsfdsafsfsdadsadsadfsafsfsfdf' where StuScore=222", conn);
try
{
cmd1.ExecuteNonQuery();//此句可以成功执行
cmd2.ExecuteNonQuery();//此句故意让其执行失败
tra.Commit();//无异常,提交事务(两句执行都有效)
Response.Write("<mce:script type="text/javascript"><!--
alert('执行成功')
// --></mce:script>");
}
catch
{
tra.Rollback();//出现异常,回滚事务(两句执行都无效)
Response.Write("<mce:script type="text/javascript"><!--
alert('执行失败')
// --></mce:script>");
}
finally
{
conn.Close();
}
} 0 0 0
(请您对文章做出评价)
相关文档:
ASP.NET软件工程师面试题
一、选择题
1. int[][] myArray3=new int[3][]{new int[3]{5,6,2},new int[5]{6,9,7,8,3},new int[2]{3,2}}; myArray3[2][2]的值是()。
A. 9
B. 2
C. &n ......
服务器控件 html标记
label----------<span/>
button---------<input type="submit"/>
textbox--------<input type="text"/>
linkbutton-----<a href="javascript:" />
imagebutton----<input type="image"/>
hyperlink------<a />
......
public static bool AddTbmember(Tbmember member, string regip)
{
bool check = false;
try
{
SqlCommand sqlcommnad = new SqlCommand("Pro_AddUsers", sqlconn.GetConn());
sqlcommnad.CommandType = CommandType.StoredProcedure; ......
#region 域名绑定方法
public static void AddHostHeader(int siteid, string ip, int port, string domain)//增加主机头(站点编号.ip.端口.域名)
{
DirectoryEntry site = new DirectoryEntry("IIS://localhost/W3SVC/" + siteid) ......