我用sqlcommand对数据表进行修改,当时运行的时候是执行成功了,但是修改的操作无法更新到数据表,每次关闭vs之后数据就自动回滚操作了,设置数据库复制到输出目录为从不复制也不得行,怎么办啊?求高手!!
解决方案 »
- 获取数据表中的动态表单标签。
- 字符串截取 在线等
- C#如何实现Excel颜色与.net颜色类型的转换
- 新年散分!
- 如何获取服务器上一段时间间隔
- 发送邮件的问题?局域网成功,广域网失败 奇怪
- web.config里面 <authentication mode="None" /> 项目复制的时候要什么密码??在线等,马上结贴
- ASP和JSP的区别是什么啊?
- visual studio 2008,可以编写asp.net web程序,但是无法运行出结果,IE浏览器中无法显示该页面,但是使用内部web浏览器可以查看
- C#中反射怎么用
- ASP.NET 修改数据问题
- 解决后第一时间结贴!如何让table或者td的形状方形让其角为园型啊?
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open(); SqlCommand command = connection.CreateCommand();
SqlTransaction transaction; // Start a local transaction.
transaction = connection.BeginTransaction("SampleTransaction"); // Must assign both transaction object and connection
// to Command object for a pending local transaction
command.Connection = connection;
command.Transaction = transaction; try
{
command.CommandText =
"Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
command.ExecuteNonQuery();
command.CommandText =
"Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
command.ExecuteNonQuery(); // Attempt to commit the transaction.
transaction.Commit();
Console.WriteLine("Both records are written to database.");
}
catch (Exception ex)
{
Console.WriteLine("Commit Exception Type: {0}", ex.GetType());
Console.WriteLine(" Message: {0}", ex.Message); // Attempt to roll back the transaction.
try
{
transaction.Rollback();
}
catch (Exception ex2)
{
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail, such as
// a closed connection.
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
}
}
}