在VS2005用SQL语句连接数据库并创建表

using System.Data; using System.Data.SqlClient; //连接字符串 string strConnection = "Server=EFBBE83A4B60400\\SQLEXPRESS;" + //本地连接 "Trusted_Connection=true;" + "Database=NorthWind;";//Database = 数据库名称 SqlConnection objConnection = new SqlConnection(strConnection); SqlCommand objCommand = new SqlCommand("", objConnection); objCommand.CommandText = "CREATE TABLE 雨量表(" + "站点编号 TEXT, " + "接收序号 TEXT, " + "观测值 FLOAT); "; objCommand.CommandText += "CREATE TABLE 雨量站点索引表(" + "站点编号 TEXT, " + "县名 TEXT, " + "乡镇名 TEXT, " + "县编号 INTEGER, " + "乡镇编号 INTEGER, " + "站点名称 INTEGER);"; objCommand.CommandText += "CREATE TABLE 雨量数据索引表(" + "数据编号 TEXT, " + "发送时间 DATETIME, " + "接收时间 DATETIME, " + "解析完成时间 DATETIME, " + "详细的数据记录 TEXT);"; try { //打开数据库连接 if (objConnection.State == ConnectionState.Closed) { objConnection.Open(); objCommand.ExecuteNonQuery(); MessageBox.Show("successful"); } } catch (SqlException ex) { MessageBox.Show(ex.Message); } finally { //关闭数据库连接 if (objConnection.State == ConnectionState.Open) { objConnection.Close(); MessageBox.Show("Closed ! !"); } }