DataBase_Create and Delete Table

 1 // 在数据库中新建数据表
 2              string  MySQL  = " IF OBJECT_ID(N'MyTest..TableName', N'U') IS NOT NULL  " +
 3                   " DROP TABLE TableName; "   +
 4                  " CREATE TABLE TableName ( " +
 5                  " [ID] [char] (14) NOT NULL Primary Key, " +
 6                  " [Name] [char] (14) NULL , " +
 7                  " [Sex] [char] (40) NULL, " +
 8                  " [Age] [varchar] (80) NULL , " +
 9                  " [Tel] [varchar] (40) NULL , " +
10                  " [Address] [char] (6) NOT NULL , " +
11                  " [Money1] [decimal] (28,6) NULL default(0), " +
12                  " [Money2] [decimal] (28,6) NULL default(0), " +
13                  " [Money3] [decimal] (28,6) NULL default(0)) " ;      
14             SqlConnection MyConnection  =   new  SqlConnection( " Data Source = .;Database = MyTestDb;Integrated Security=SSPI " );
15             SqlCommand MyCommand  =   new  SqlCommand(MySQL, MyConnection);
16              try
17              {
18                MyCommand.Connection.Open();
19                MyCommand.ExecuteNonQuery();
20                MessageBox.Show("成功在MyTestDb数据库中创建数据表", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
21            }
22              catch  (Exception ex)
23              {
24                MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
25            }
26              finally
27              {
28                MyConnection.Close();
29            }

 1 // 在数据库中删除数据表
 2              string  MySQL  =   " IF OBJECT_ID(N'MyTestDb..TableName', N'U') IS NOT NULL  "   +
 3                   " DROP TABLE TableName; " ;             
 4             SqlConnection MyConnection  =   new  SqlConnection( " Data Source = .;Database = MyTestDb;Integrated Security=SSPI " );
 5             SqlCommand MyCommand  =   new  SqlCommand(MySQL, MyConnection);
 6              try
 7              {
 8                MyCommand.Connection.Open();
 9                MyCommand.ExecuteNonQuery();
10                MessageBox.Show("成功在MyTestDb数据库中删除数据表", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
11            }
12              catch  (Exception ex)
13              {
14                MessageBox.Show(ex.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
15            }
16              finally
17              {
18                MyConnection.Close();
19            }

转载于:https://www.cnblogs.com/yongwnet/archive/2007/03/23/685869.html