saeedhushmand
جمعه 27 آبان 1390, 17:24 عصر
کد زیر رو برای attach بود می خوام برای detach استفاده کنم اما کار نمی کنه لطفا بگید چه کار کنم تا درست بشه
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=(local)\\sqlexpress;Initial Catalog=master;Integrated Security=True";
con.Open();
string str = "use master;" + "EXECUTE sp_detach_db @dbname = N'laberator' , " + " @filename1 = N'" + System.Environment.CurrentDirectory + "\\Database\\laberator.mdf'," + "@filename2 = N'" + System.Environment.CurrentDirectory + "\\Database\\laberator_log.ldf'" ;
SqlCommand cmd = new SqlCommand(str,con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("وصل شد");
}
catch (Exception x)
{
if(x.Message.IndexOf("already exists")>=0)
MessageBox.Show("وصله");
else
MessageBox.Show(x.Message);
}
try
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=(local)\\sqlexpress;Initial Catalog=master;Integrated Security=True";
con.Open();
string str = "use master;" + "EXECUTE sp_detach_db @dbname = N'laberator' , " + " @filename1 = N'" + System.Environment.CurrentDirectory + "\\Database\\laberator.mdf'," + "@filename2 = N'" + System.Environment.CurrentDirectory + "\\Database\\laberator_log.ldf'" ;
SqlCommand cmd = new SqlCommand(str,con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("وصل شد");
}
catch (Exception x)
{
if(x.Message.IndexOf("already exists")>=0)
MessageBox.Show("وصله");
else
MessageBox.Show(x.Message);
}