游客

标题:sql数据库事务/触发器/存储过程/视图/表值函数/标量值函数/系统函数案例片段
正文:






SyntaxHighlighter.config.clipboardSwf = ’/Js/Syntax/clipboard.swf’;
SyntaxHighlighter.all();
--------数据库事务

///
/// 执行多条SQL语句，实现数据库事务。
///
/// 多条SQL语句 public static int ExecuteSqlTran(List SQLStringList)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
SqlTransaction tx = conn.BeginTransaction();
cmd.Transaction = tx;
try
{
int count = 0;
for (int n = 0; n 1)
{
cmd.CommandText = strsql;
count += cmd.ExecuteNonQuery();

[<<][[1]][2][3][>>]

查看评论(0)
发表评论



首页