数据库创建时的一个问题
我想动态创建一个数据库
想把textBox1里面的内容做为数据库的名子,我的方法是把textBox1内容赋给字符串DataName,但建立时显示的数据库文件名是DataName,而非DataName里面的内容.
代码如下
string ConnectionString = "server=.\\sqlexpress;uid=;pwd=;database=;Integrated security=SSPI";
SqlConnection conn = new SqlConnection(ConnectionString);
string DataName = textBox1.Text;
// 打开数据库连接
if(conn.State != ConnectionState.Open)
conn.Open();
string sql = "CREATE DATABASE MyDatabase ON PRIMARY " +
"(NAME = DataName, " +
"FILENAME = 'D:\\Visual Studio 2005\\Projects\\Deformation Measurement\\Deformation Measurement\\data\\DataName.mdf', " +
"SIZE = 3MB, MAXSIZE = 10MB, FILEGROWTH = 10%) " +
"LOG ON (NAME = DataName_log, " +
"FILENAME = 'D:\\Visual Studio 2005\\Projects\\Deformation Measurement\\Deformation Measurement\\data\\DataName_Log', " +
"SIZE = 1MB, " +
"MAXSIZE = 5MB, " +
"FILEGROWTH = 10%)";
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
cmd.ExecuteNonQuery();
}
catch(SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}