SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PIV2400;Initial Catalog=OfficeInformation;Integrated Security=True";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "create table userinfo(id int,username char(8) )";
cmd.ExecuteNonQuery();
conn.ConnectionString = "Data Source=PIV2400;Initial Catalog=OfficeInformation;Integrated Security=True";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "create table userinfo(id int,username char(8) )";
cmd.ExecuteNonQuery();
其中
连接字符串格式为:
Data Source=[服务器名];Initial Catalog=[数据库名];Integrated Security=True
创建数据表执行命令格式:
Create table [表名] ( [字段名1 数据类型1] [,字段名2 数据类型2] [....] )