先连接到master数据库, 然后执行建立数据库的sql语句, 就可以了.
示例代码如下:
void button_Click(object sender, RoutedEventArgs e)
{
string connectionString = "Data Source=192.168.0.8;Initial Catalog=master;"
+"Persist Security Info=True;User ID=sa;Password=sa";
SqlConnection m_sqlConn = new SqlConnection(connectionString);
string strCommand = "USE master; IF DB_ID (N'mytest') IS NOT NULL DROP DATABASE mytest; CREATE DATABASE mytest; SELECT name, size, size*1.0/128 AS [Size in MBs] FROM sys.master_files WHERE name = N'mytest';";
SqlCommand command = new SqlCommand(strCommand,m_sqlConn);
m_sqlConn.Open();
command.ExecuteNonQuery();
m_sqlConn.Close();
}