本文介紹了在C#程序中創(chuàng)建SQL SERVER數(shù)據(jù)庫(kù)的方法，在此基礎(chǔ)上介紹了向數(shù)據(jù)庫(kù)中添加數(shù)據(jù)的方法。

首先，我們?cè)诔绦蛑袆?dòng)態(tài)地創(chuàng)建SQL Server數(shù)據(jù)庫(kù)。

我們將數(shù)據(jù)庫(kù)創(chuàng)建在C:\mysql目錄下，所以讀者要練習(xí)該實(shí)例的話得先在C:下創(chuàng)建一個(gè)名為mysql的文件夾，否則會(huì)出錯(cuò)！創(chuàng)建數(shù)據(jù)庫(kù)的關(guān)鍵是函數(shù)中的sql對(duì)象，通過(guò)該對(duì)象我們指定了數(shù)據(jù)庫(kù)文件的一些基本屬性。之后，我們新創(chuàng)建了一個(gè)SqlCommand對(duì)象，通過(guò)該對(duì)象我們 就實(shí)際完成了對(duì)數(shù)據(jù)庫(kù)的操作。函數(shù)的實(shí)現(xiàn)如下：

private void button1_Click(object sender, System.EventArgs e)
{
   // 打開(kāi)數(shù)據(jù)庫(kù)連接
   if( conn.State != ConnectionState.Open)
      conn.Open();
   string sql = "CREATE DATABASE mydb ON PRIMARY" 
                      +"(name=test_data, filename = 'C:\\mysql\\mydb_data.mdf', size=3,"
                      +"maxsize=5, filegrowth=10%) log on"
                      +"(name=mydbb_log, filename='C:\\mysql\\mydb_log.ldf',size=3,"
                      +"maxsize=20,filegrowth=1)";
   cmd = new SqlCommand(sql, conn);
   try { cmd.ExecuteNonQuery(); }
   catch(SqlException ae)
   {
        MessageBox.Show(ae.Message.ToString());
   }
}

其次，我們通過(guò)CREATE TABLE語(yǔ)句創(chuàng)建基本表，并向該表中添加4條數(shù)據(jù)。函數(shù)的實(shí)現(xiàn)如下：

private void button2_Click(object sender, System.EventArgs e)
       {
               // 打開(kāi)數(shù)據(jù)庫(kù)連接
               if( conn.State == ConnectionState.Open) 
                     conn.Close(); 
               ConnectionString ="Integrated Security=SSPI;" + "Initial Catalog=mydb;" + "Data Source=localhost;"; 
                conn.ConnectionString = ConnectionString; 
                conn.Open();
                 sql = "CREATE TABLE myTable"+ "(myId INTEGER CONSTRAINT PKeyMyId PRIMARY KEY,"
                        + "myName CHAR(50), myAddress CHAR(255), myBalance FLOAT)"; 
                cmd = new SqlCommand(sql, conn); 
                  try {
                               cmd.ExecuteNonQuery(); // 向表中添加記錄
                               sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+ "VALUES (1001, 'Puneet Nehra', 'A 449 Sect 19, DELHI', 23.98 ) " ; 
                              cmd = new SqlCommand(sql, conn);
                              cmd.ExecuteNonQuery(); 
                              sql = "INSERT INTO myTable(myId, myName,myAddress, myBalance) "+ "VALUES (1002, 'Anoop Singh', 'Lodi Road, DELHI', 353.64) " ;
                              cmd = new SqlCommand(sql, conn); 
                              cmd.ExecuteNonQuery(); 
                              sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+ "VALUES (1003, 'Rakesh M', 'Nag Chowk, Jabalpur M.P.', 43.43) " ; 
                              cmd = new SqlCommand(sql, conn); 
                              cmd.ExecuteNonQuery();
                               sql = "INSERT INTO myTable(myId, myName, myAddress, myBalance) "+ "VALUES (1004, 'Madan Kesh', '4th Street, Lane 3, DELHI', 23.00) " ; 
                              cmd = new SqlCommand(sql, conn);
                               cmd.ExecuteNonQuery(); } 
                  catch(SqlException ae) { MessageBox.Show(ae.Message.ToString()); }
       }

完成此操作后，我們可以打開(kāi)SQL SERVER的企業(yè)管理器，查看是否有我們創(chuàng)建的數(shù)據(jù)庫(kù)和基本表。