【1】动态创建数据库方法(实例),你可以在WinForm中添加一个文本框,输入数据库名称,这个就不用我啰嗦了吧。将下面的第一句改为
string myExecuteQuery = "create database "+textBox1.Text.Trim(); //创建test数据库
private void button1_Click(object sender, EventArgs e)
{
string myExecuteQuery = "create database test123"; //创建test数据库
SqlConnection mySqlConnection = new SqlConnection("server=VQJREZV7DVSK2QA;user id=sa;password=admin@123456;Trusted_Connection=yes;");
SqlCommand myCommand = new SqlCommand(myExecuteQuery, mySqlConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
mySqlConnection.Close();
}
【2】动态创建数据表信息
{ 敬请期待 }