请问连接(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> 前台程序和后台background_worker问题 关于email接受的问题 关于移除控件的问题,求助 请教二个数组比较的问题 为什么在ACCESS表中删除记录无效呢? C#中有没有类似 JavaDoc 的工具 c#中资料类型是什么类型 困惑多年的问题:关于实体关系映射 我们的了分可以拿去干什么? (mm系列问题)一个百思不得其解的问题 一般做生成注册码程序中都用到什么算法。。 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>