C#读取*.sql文件,并执行里面的SQL语句
来源:互联网 发布:python 输出多个变量 编辑:程序博客网 时间:2024/05/25 18:10
public static ArrayList GetSqlFile(string varFileName, string dbname)
{
ArrayList alSql = new ArrayList();
if (!File.Exists(varFileName))
{
return alSql;
}
StreamReader rs = new StreamReader(varFileName, System.Text.Encoding.Default);//注意编码
string commandText = "";
string varLine = "";
while (rs.Peek() > -1)
{
varLine = rs.ReadLine();
if (varLine == "")
{
continue;
}
if (varLine != "GO" && varLine != "go")
{
commandText += varLine;
commandText = commandText.Replace("@database_name=N'dbhr'", string.Format("@database_name=N'{0}'", dbname));
commandText += "\r\n";
}
else
{
alSql.Add(commandText);
commandText = "";
}
}
rs.Close();
return alSql;
}
public static void ExecuteCommand(ArrayList varSqlList, string connString)
{
SqlConnection MyConnection = new SqlConnection(connString);
MyConnection.Open();
SqlTransaction varTrans = MyConnection.BeginTransaction();
SqlCommand command = new SqlCommand();
command.Connection = MyConnection;
command.Transaction = varTrans;
try
{
foreach (string varcommandText in varSqlList)
{
command.CommandText = varcommandText;
command.ExecuteNonQuery();
}
varTrans.Commit();
}
catch (Exception ex)
{
varTrans.Rollback();
throw ex;
}
finally
{
MyConnection.Close();
}
}
{
ArrayList alSql = new ArrayList();
if (!File.Exists(varFileName))
{
return alSql;
}
StreamReader rs = new StreamReader(varFileName, System.Text.Encoding.Default);//注意编码
string commandText = "";
string varLine = "";
while (rs.Peek() > -1)
{
varLine = rs.ReadLine();
if (varLine == "")
{
continue;
}
if (varLine != "GO" && varLine != "go")
{
commandText += varLine;
commandText = commandText.Replace("@database_name=N'dbhr'", string.Format("@database_name=N'{0}'", dbname));
commandText += "\r\n";
}
else
{
alSql.Add(commandText);
commandText = "";
}
}
rs.Close();
return alSql;
}
public static void ExecuteCommand(ArrayList varSqlList, string connString)
{
SqlConnection MyConnection = new SqlConnection(connString);
MyConnection.Open();
SqlTransaction varTrans = MyConnection.BeginTransaction();
SqlCommand command = new SqlCommand();
command.Connection = MyConnection;
command.Transaction = varTrans;
try
{
foreach (string varcommandText in varSqlList)
{
command.CommandText = varcommandText;
command.ExecuteNonQuery();
}
varTrans.Commit();
}
catch (Exception ex)
{
varTrans.Rollback();
throw ex;
}
finally
{
MyConnection.Close();
}
}
- C#读取*.sql文件,并执行里面的SQL语句
- C#读取.sql文件并执行文件中的sql
- android 读取assets下的*.sql并执行sql语句
- thinkphp里面执行原生的sql语句
- thinkphp 里面执行SQL语句
- 执行所读取的sql文件中的sql语句报语法错误之文件编码问题
- C# 调用并执行SQL脚本文件
- C# 调用并执行SQL脚本文件
- C# 读取指定目录中的所有文件,并按规则生成SQL语句!
- 读取 SQL 脚本并执行
- C#连接数据库sqlserver2005,并执行sql语句实例
- C#连接数据库sqlserver2005,并执行sql语句实例:
- C#中如何连接数据库并执行SQL语句
- 在thinkphp里面执行原生的sql语句
- C# .sql文件读取
- 存储过程里面执行SQL语句
- shell逐行读取文件拼接Sql语句并访问数据库
- 如何在MyEclipse中建立sql文件,并执行语句?
- 为Eclipse添加Java Decompiler插件
- TI C6000系列DSP的片内总线架构、存储系统和外设
- ASP.NET - 使用Web.config配置数据
- eclipse快捷键大全,搜集整理版
- Android学习笔记之AndroidManifest.xml文件解析
- C#读取*.sql文件,并执行里面的SQL语句
- mysql服务器的HA集群之corosync+drbd+pacemaker实现
- Linux内存管理--基本概念
- 网站系统安全开发手册
- hibernate注解方式实现复合主键
- me865测试代码
- 如何混排Swing和AWT组件
- 让你拥有超常记忆力的小习惯
- Python特殊语法:filter、map、reduce、lambda [转]