之前已经判断出来所要写数据库不存在,下面进行新建数据库:
string con_database = "server=" + server_name + ";user id=" + user_id + ";password=" + password;//这个连接字符串该怎么写呢?
con2 = new SqlConnection(con_database);
con2.Open();
//新建数据库
string creat_database = "create database " + database_name;
SqlCommand cmd_creat_database = new SqlCommand(creat_database, con2);
cmd_creat_database.Prepare();
cmd_creat_database.ExecuteNonQuery();
con2.Close();
string con_database = "server=" + server_name + ";user id=" + user_id + ";password=" + password;//这个连接字符串该怎么写呢?
con2 = new SqlConnection(con_database);
con2.Open();
//新建数据库
string creat_database = "create database " + database_name;
SqlCommand cmd_creat_database = new SqlCommand(creat_database, con2);
cmd_creat_database.Prepare();
cmd_creat_database.ExecuteNonQuery();
con2.Close();
create database t
????string con_database = "server=" + server_name + ";database=master;user id=" + user_id + ";password=" + password;//这样不行吗