C#創立數據庫及附加數據庫的操作辦法。本站提示廣大學習愛好者:(C#創立數據庫及附加數據庫的操作辦法)文章只能為提供參考,不一定能成為您想要的結果。以下是C#創立數據庫及附加數據庫的操作辦法正文
本文實例講述了C#創立數據庫及附加數據庫的操作辦法。分享給年夜家供年夜家參考,詳細以下:
/// <summary> /// 附加數據庫辦法 /// </summary> /// <param name="strSql">銜接數據庫字符串,銜接master體系數據庫</param> /// <param name="DataName">數據庫名字</param> /// <param name="strMdf">數據庫文件MDF的途徑</param> /// <param name="strLdf">數據庫文件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("數據庫裝置勝利!點擊肯定持續");//需Using System.Windows.Forms } catch(Exception e) { MessageBox.Show("數據庫裝置掉敗!" + e.Message+"\n\n"+"您可以手動附加數據"); System.Diagnostics.Process.Start(path);//翻開裝置目次 } finally { myConn.Close(); } } public override void Install(System.Collections.IDictionary stateSaver) { string server = this.Context.Parameters["server"];//辦事器稱號 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";//銜接數據庫字符串 string DataName = "JXC";//數據庫名 string strMdf = path + @"JXC.mdf";//MDF文件途徑,這裡需留意文件名要與剛添加的數據庫文件名一樣! string strLdf = path + @"jxc_log.ldf";//LDF文件途徑 base.Install(stateSaver); this.CreateDataBase(strSql, DataName, strMdf, strLdf, path);//開端創立數據庫 } /// <summary> /// 測試銜接 /// </summary> /// <param name="serverName"></param> /// <param name="dbName"></param> /// <param name="userName"></param> /// <param name="password"></param> private SqlConnection TestConnection(string serverName, string dbName, string userName, string password) { string connectionString = GetConnectionString(serverName, dbName, userName, password); SqlConnection connection = new SqlConnection(connectionString); try { if (connection.State != ConnectionState.Open) { connection.Open(); } return connection; } catch { CloseConnection(connection); throw new InstallException("裝置掉敗!\n數據庫設置裝備擺設有誤,請准確設置裝備擺設信息!"); } } /// <summary> /// 獲得銜接字符串 /// </summary> /// <param name="serverName"></param> /// <param name="dbName"></param> /// <param name="userName"></param> /// <param name="password"></param> /// <returns></returns> private string GetConnectionString(string serverName, string dbName, string userName, string password) { string connectionString = "Data Source={0};Initial Catalog={1};User ID={2};Password={3}"; connectionString = string.Format(connectionString, serverName, dbName, userName, password); return connectionString; } /// <summary> /// 創立數據庫 /// </summary> /// <param name="serverName"></param> /// <param name="dbName"></param> /// <param name="userName"></param> /// <param name="password"></param> /// <param name="connection"></param> /// <param name="stateSaver"></param> public int CreateDataBase(SqlConnection connection) { int result = -1; connection.ChangeDatabase("master"); string createDBSql = @" if Exists(select 1 from sysdatabases where [name]=N'{0}') begin drop database {0} end GO CREATE DATABASE {0} "; createDBSql = string.Format(createDBSql, _dbName); //由於有Go在SQLCommand中不熟悉,所以以Go為分隔符取sql語句 char[] split = new char[] { 'G', 'O' }; string[] sqlList = createDBSql.Split(split); SqlCommand command = null; try { command = connection.CreateCommand(); command.CommandType = System.Data.CommandType.Text; foreach (string sqlItem in sqlList) { if (sqlItem.Length > 2) { command.CommandText = sqlItem; result = command.ExecuteNonQuery(); } } return result; } catch { CloseConnection(connection); command.Dispose(); throw new InstallException("裝置掉敗!\n數據庫設置裝備擺設不准確!"); } } /// <summary> /// 分隔SQL語句 /// </summary> /// <param name="sql"></param> /// <returns></returns> private string[] splitSql(string sql) { Regex regex = new Regex("^GO", RegexOptions.IgnoreCase | RegexOptions.Multiline); string[] sqlList = regex.Split(sql.ToUpper()); return sqlList; }
願望本文所述對年夜家C#法式設計有所贊助。