110,533
社区成员
发帖
与我相关
我的任务
分享
private void AttachDatabase()
{
SqlConnection conn = null;
try
{
//如果已经有数据库则删除
string sql = "SELECT count(NAME) FROM SYSDATABASES WHERE NAME='" + databaseName + "'";
conn = new SqlConnection("Data Source=" + cboTrial.SelectedItem.ToString() +
";Integrated Security=True;Initial Catalog=master");
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
int count = int.Parse(cmd.ExecuteScalar().ToString());
if (count > 0)
{
cmd.CommandText = "drop database " + databaseName;
cmd.ExecuteNonQuery();
}
//附加新的数据库
string path = JYG.Common.PublicMethods.GetCurrentPath() + "data\\";
cmd = new SqlCommand();
cmd.CommandText = "sp_attach_db '" + databaseName + "','" + path + databaseName + ".mdf','" + path + databaseName + ".ldf'";
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误窗体",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conn.Close();
}
}