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 ! !");
}
}
- 1
- 2
- 3
前往页