请问连接(connect)和事务对象(Transaction)是什么关系? 请问 tl0(saturn) 指的同一种连接是指连接字符串相同的连接还是指连接同一个数据库的连接? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 清华版wrox的C#数据库入门经典有专门的介绍。 <%@ Import namespace="System.Data" %><%@ Import namespace="System.Data.SqlClient" %><script language="c#" runat="server">private void Page_Load(object sender, System.EventArgs e){ String strConnection = ConfigurationSettings.AppSettings["NWind"]; SqlConnection conn = new SqlConnection(strConnection); SqlTransaction Tran; SqlCommand cmd1, cmd2; String sql; conn.Open(); Tran = conn.BeginTransaction(); try { sql = "INSERT INTO tblAuditLog (Action, Msg) VALUES ('Insert the man', 'Brian Berry')"; cmd1 = new SqlCommand(sql, conn); cmd1.Transaction = Tran; cmd1.ExecuteNonQuery(); Response.Write("Audit Log entry added<br/>"); sql = "INSERT INTO Employees (FirstName, LastName) VALUES (@FirstName, @LastName)"; cmd2 = new SqlCommand(sql, conn); cmd2.Transaction = Tran; cmd2.Parameters.Add("@FirstName", "Brian"); cmd2.Parameters.Add("@LastName", "Berry"); cmd2.ExecuteNonQuery(); Response.Write("Employee added<br/>"); Tran.Commit(); } catch { Tran.Rollback(); Response.Write("There was an error!<br/>"); } finally { conn.Close(); }}</script> C# api 区别 一旦调用DLL,就关闭我的程序,求助啊··大哥们啊· ControlStyles.FixedHeight怎样使用 怎样使窗体的大小被拉大缩小? C#中如何创建链表? 如何判断一个Http的URL路径文件是否存在? 小问题 自定义属性问题 写个算法 使用第三方控件继承和添加控件(buttonx)出现问题 一般做生成注册码程序中都用到什么算法。。 web(c#)中的html中出现脚本错误”服务器无法创建对象“,详细请进,急,在线!!
<%@ Import namespace="System.Data.SqlClient" %><script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
String strConnection = ConfigurationSettings.AppSettings["NWind"];
SqlConnection conn = new SqlConnection(strConnection); SqlTransaction Tran;
SqlCommand cmd1, cmd2;
String sql; conn.Open();
Tran = conn.BeginTransaction(); try
{
sql = "INSERT INTO tblAuditLog (Action, Msg) VALUES ('Insert the man', 'Brian Berry')";
cmd1 = new SqlCommand(sql, conn);
cmd1.Transaction = Tran;
cmd1.ExecuteNonQuery();
Response.Write("Audit Log entry added<br/>"); sql = "INSERT INTO Employees (FirstName, LastName) VALUES (@FirstName, @LastName)";
cmd2 = new SqlCommand(sql, conn);
cmd2.Transaction = Tran;
cmd2.Parameters.Add("@FirstName", "Brian");
cmd2.Parameters.Add("@LastName", "Berry");
cmd2.ExecuteNonQuery(); Response.Write("Employee added<br/>");
Tran.Commit();
}
catch
{
Tran.Rollback();
Response.Write("There was an error!<br/>");
}
finally
{
conn.Close();
}
}
</script>