小弟在formview是用的自动绑定,实现对数据库的插入、修改很简单,几乎不用写什么代码自动绑定的时候对于数据库的操作完全是由asp.net控件自行完成的同时对另一个数据库表进行操作这两个操作怎么设置到一起成为一个原子操作呢?而且这两个操作是在不同的函数中,是在很头疼啊
解决方案 »
- 如何在datagrid中取数据项?
- 现在有2个textbox,要求鼠标移动到textbox范围内,弹出一个层,层里面的内容为textbox的值!
- 求助!客户端调用Javascript文件中的错误
- 关于类库项目生成dll问题
- 请问如何取得gridview某一单元格的值。
- 新手请教,怎么实现不了textbox值的重填
- Asp.net MVC网上资源汇总1
- 请教activeReports的问题, 它反复询问"你想安装此软件吗?" ,
- 滚动条的两个问题:1-如何改变滚动条的风格(颜色等);2-如何控制一个滚动条滚动,另一个滚动条也同时滚动
- 帮我想下思路,DataGrid(启用了编辑列的)新加一行(使用DataTable新加一行),填入数据,放入(DataSet)Session中,再通过模板列修改,还是放在(D
- 如何实现csdn论坛这种效果,我单击一行中的一个字段值,弹出一个新页.父窗口不刷新
- 请问如何取得一个URL图片并把它下载后生成缩略图?
myConnection.Open()
Dim myCommand As New SqlCommand()
Dim myTrans As SqlTransaction
' Start a local transaction
myTrans = myConnection.BeginTransaction()
' Must assign both transaction object and connection
' to Command object for a pending local transaction
myCommand.Connection = myConnection
myCommand.Transaction = myTrans
Try
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"
myCommand.ExecuteNonQuery()
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"
myCommand.ExecuteNonQuery()
myTrans.Commit()
Console.WriteLine("Both records are written to database.")
Catch e As Exception
myTrans.Rollback()
Console.WriteLine("Error: {1}", e.Message)
Console.WriteLine("Error reported by {1}.", e.Source)
Console.WriteLine("Neither record was written to database.")
Finally
myConnection.Close()
End Try
myConnection.Open(); SqlCommand myCommand = new SqlCommand();
SqlTransaction myTrans; // Start a local transaction
myTrans = myConnection.BeginTransaction();
// Must assign both transaction object and connection
// to Command object for a pending local transaction
myCommand.Connection = myConnection;
myCommand.Transaction = myTrans; try
{
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
myCommand.ExecuteNonQuery();
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
myCommand.ExecuteNonQuery();
myTrans.Commit();
Console.WriteLine("Both records are written to database.");
}
catch(Exception e)
{
myTrans.Rollback();
Console.WriteLine("Error: {1}", e.Message);
Console.WriteLine("Error reported by {1}.", e.Source);
Console.WriteLine("Neither record was written to database.");
}
finally
{
myConnection.Close();
}