请问c#里如何附加sql2005数据库 rt,在c#里如何用代码附加sql2005数据库? 请给我一个实例。 网上的我找了(什么方法1,2,3的),但是没研究出来。希望高手能给个实例谢谢了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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(); } } Server=.\SQLExpress;AttachDbFilename=c:\mydbfile.mdf;Database=dbname; Trusted_Connection=Yes; 在连接字符串中增加AttachDbFilename上面的Server=.\SQLExpress要修改成你的sqlserver服务器名称! 遍历TreeView C#使用Hessian调用JAVA的函数的问题 输出流写入文本的问题 如何将一个对象转换成字节数组 mysql数据库中读写图片 怎么控制渐变填充为不循环填充? 问一个大家不常见的问题 calendar 关于模版函数或模版类,高分在线等! C# 通过webbrouser 打开ppt,如何在C#程序中对该ppt添加新的页? Application对象的问题 C# 关于viewdata 存储数据
{
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();
}
}