学c#不长时间,在努力学习中,谢谢大家知道啊,在线等待
string dnname = txtsql.Text;
string mdffile = Environment.CurrentDirectory + "\\data\\" + dnname + "_Data.MDF";
string ldffile = Environment.CurrentDirectory + "\\data\\" + dnname + "_Log.LDF";
try
{
string sql = string.Empty;
sql = "EXEC sp_attach_db @dbname = '" + txtsql.Text +
"', @filename1 = N '" + mdffile +
"',@filename2=N'" + ldffile + "'";
SqlConnection conn = new SqlConnection(string.Format("Data Source=.;Initial Catalog=master;User ID={sa};PWD={sa}", "(loca)", "sa", "sa"));
using (conn)
{
lock (conn)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
}
}
catch
{
MessageBox.Show("出现错误");
}
string dnname = txtsql.Text;
string mdffile = Environment.CurrentDirectory + "\\data\\" + dnname + "_Data.MDF";
string ldffile = Environment.CurrentDirectory + "\\data\\" + dnname + "_Log.LDF";
try
{
string sql = string.Empty;
sql = "EXEC sp_attach_db @dbname = '" + txtsql.Text +
"', @filename1 = N '" + mdffile +
"',@filename2=N'" + ldffile + "'";
SqlConnection conn = new SqlConnection(string.Format("Data Source=.;Initial Catalog=master;User ID={sa};PWD={sa}", "(loca)", "sa", "sa"));
using (conn)
{
lock (conn)
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
}
}
catch
{
MessageBox.Show("出现错误");
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货