为什么我用c#建立数据库后 不能立即进行与数据库的连接?
建立不了连接我就不能立即给数据库建表了
String str;
SqlConnection myConn = new SqlConnection("Server=localhost;Integrated security=SSPI;database=master");
str = "CREATE DATABASE TicketDB1 ON PRIMARY " + "(NAME = TicketDB_Data, " +
"FILENAME = 'D:\\TicketDB1_Data.mdf', " +
"SIZE = 10MB, MAXSIZE = 50MB, FILEGROWTH = 10%) " +
"LOG ON (NAME = TicketDB1_Log, " +
"FILENAME = 'D:\\TicketDB1Log.ldf', " +
"SIZE = 5MB, " +
"MAXSIZE = 25MB, " +
"FILEGROWTH = 10%)";
SqlCommand myCommand = new SqlCommand(str, myConn);
try
{
myConn.Open();
myCommand.ExecuteNonQuery();
MessageBox.Show("数据库建立成功", "TicketDB1", MessageBoxButtons.OK, MessageBoxIcon.Information);
myConn.Close();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString(), "TicketDB1", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
string ConnString2 = "Data Source=" + Datasource + ";Integrated Security=SSPI;Initial Catalog=TicketDB1;";
SqlConnection conn2 = new SqlConnection(ConnString2);
conn2.Open();
if (conn2.State == ConnectionState.Open)
{
MessageBox.Show("数据库连接成功");
}
}
catch
{
MessageBox.Show("数据库连接失败");
}
运行代码后走总显示数据库连接失败
建立不了连接我就不能立即给数据库建表了
String str;
SqlConnection myConn = new SqlConnection("Server=localhost;Integrated security=SSPI;database=master");
str = "CREATE DATABASE TicketDB1 ON PRIMARY " + "(NAME = TicketDB_Data, " +
"FILENAME = 'D:\\TicketDB1_Data.mdf', " +
"SIZE = 10MB, MAXSIZE = 50MB, FILEGROWTH = 10%) " +
"LOG ON (NAME = TicketDB1_Log, " +
"FILENAME = 'D:\\TicketDB1Log.ldf', " +
"SIZE = 5MB, " +
"MAXSIZE = 25MB, " +
"FILEGROWTH = 10%)";
SqlCommand myCommand = new SqlCommand(str, myConn);
try
{
myConn.Open();
myCommand.ExecuteNonQuery();
MessageBox.Show("数据库建立成功", "TicketDB1", MessageBoxButtons.OK, MessageBoxIcon.Information);
myConn.Close();
}
catch (System.Exception ex)
{
MessageBox.Show(ex.ToString(), "TicketDB1", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
string ConnString2 = "Data Source=" + Datasource + ";Integrated Security=SSPI;Initial Catalog=TicketDB1;";
SqlConnection conn2 = new SqlConnection(ConnString2);
conn2.Open();
if (conn2.State == ConnectionState.Open)
{
MessageBox.Show("数据库连接成功");
}
}
catch
{
MessageBox.Show("数据库连接失败");
}
运行代码后走总显示数据库连接失败
Datasource应该是服务器的名字,一般就是计算机名,我不知道你这个Datasource参数是代表什么?