程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> .NET網頁編程 >> C# >> C#入門知識 >> C#創立數據庫及附加數據庫的操作辦法

C#創立數據庫及附加數據庫的操作辦法

編輯:C#入門知識

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#法式設計有所贊助。

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved