/dbname=[DBNAME] /server=[SERVER] /user=[USER] /pwd=[PWD] /targetdir="[TARGETDIR]\"
/// <summary>
/// 附加數(shù)據(jù)庫(kù)方法
/// </summary>
/// <param name="strSql">連接數(shù)據(jù)庫(kù)字符串,連接master系統(tǒng)數(shù)據(jù)庫(kù)</param>
/// <param name="DataName">數(shù)據(jù)庫(kù)名字</param>
/// <param name="strMdf">數(shù)據(jù)庫(kù)文件MDF的路徑</param>
/// <param name="strLdf">數(shù)據(jù)庫(kù)文件LDF的路徑</param>
/// <param name="path">安裝目錄</param>
private void CreateDataBase( string strSql, string DataName, string strMdf, string strLdf, string path)
{
SqlConnection myConn = new SqlConnection(strSql);
String str = null ;
try
{
str = " EXEC sp_attach_db @dbname='"+DataName+"',@filename1='"+strMdf+"',@filename2='"+strLdf+"'";
SqlCommand myCommand = new SqlCommand(str, myConn);
myConn.Open();
myCommand.ExecuteNonQuery();
MessageBox.Show("數(shù)據(jù)庫(kù)安裝成功!點(diǎn)擊確定繼續(xù)");//需Using System.Windows.Forms
}
catch(Exception e)
{
MessageBox.Show("數(shù)據(jù)庫(kù)安裝失??!" + e.Message+"\n\n"+"您可以手動(dòng)附加數(shù)據(jù)");
System.Diagnostics.Process.Start(path);//打開(kāi)安裝目錄
}
finally
{
myConn.Close();
}
}
public override void Install(System.Collections.IDictionary stateSaver)
{
string server = this.Context.Parameters["server"];//服務(wù)器名稱(chēng)
string uid = this.Context.Parameters["user"];//SQlServer用戶名
string pwd = this.Context.Parameters["pwd"];//密碼
string path = this.Context.Parameters["targetdir"];//安裝目錄
string strSql = "server=" + server + ";uid=" + uid + ";pwd=" + pwd + ";database=master";//連接數(shù)據(jù)庫(kù)字符串
string DataName = "JXC";//數(shù)據(jù)庫(kù)名
string strMdf = path + @"JXC.mdf";//MDF文件路徑,這里需注意文件名要與剛添加的數(shù)據(jù)庫(kù)文件名一樣!
string strLdf = path + @"jxc_log.ldf";//LDF文件路徑
base.Install(stateSaver);
this.CreateDataBase(strSql, DataName, strMdf, strLdf, path);//開(kāi)始創(chuàng)建數(shù)據(jù)庫(kù)
}
聯(lián)系客服