22,210
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 自动调用外部的SQL文件
/// </summary>
/// <param name="dbServer">连接服务器</param>
/// <param name="uid">用户名</param>
/// <param name="pwd">密码</param>
/// <param name="usedDatabase">被使用的数据库</param>
/// <param name="FilePath">.SQL文件路径</param>
/// <returns>Boolen?True:false</returns>
public bool CreateByFile(string dbServer,string uid,string pwd,string usedDatabase,string FilePath)
{
string createStr = " -U " + uid + " -P " + pwd + " -d " + usedDatabase + " -s " + dbServer + " -i " + FilePath;
try
{
//下面代码可以调用任意的.SQL文件并实现
System.Diagnostics.Process pr = new System.Diagnostics.Process();
pr.StartInfo.FileName = "osql.exe";//调用osql工具
pr.StartInfo.Arguments = createStr;//加入创建字符串
pr.StartInfo.UseShellExecute = false;
pr.StartInfo.RedirectStandardOutput = true; //重定向输出
pr.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;//隐藏输出窗口
pr.Start();
System.IO.StreamReader sr = pr.StandardOutput;
sr.ReadToEnd();
pr.WaitForExit();
pr.Close();
return true;
}
catch (Exception err)
{
err.Message.ToString();
return false;
}
}
if (!IsPostBack)
{
//调用表生成
CreateByFileAsSql cb = new CreateByFileAsSql();
string dbServer = "192.168.0.221";
string path = "F:\\c.sql";
if (cb.CreateByFile(dbServer, "sa", "sa", "wjhtest", path))
{
Response.Write("aaa");
}
}