2023年6月21日发(作者：)
C#附加数据库近段时间学习了如何⽤安装包将数据库⼀起附加进去，代替了以往需要⽤户⼿⼯附加的⽅式。 ///
/// 数据库操作控制类
///
public class DataBaseControl
{
///
/// 数据库连接字符串
///
public string ConnectionString; ///
/// SQL操作语句/存储过程
///
public string StrSQL; ///
/// 实例化⼀个数据库连接对象
///
private SqlConnection Conn; ///
/// 实例化⼀个新的数据库操作对象Comm
///
private SqlCommand Comm; ///
/// 要操作的数据库名称
///
public string DataBaseName; ///
/// 数据库⽂件完整地址
///
public string DataBase_MDF; ///
/// 数据库⽇志⽂件完整地址
///
public string DataBase_LDF; ///
/// 备份⽂件名
///
public string DataBaseOfBackupName; ///
/// 备份⽂件路径
///
public string DataBaseOfBackupPath; ///
/// 执⾏创建/修改数据库和表的操作
///
public void DataBaseAndTableControl()
{
try
{
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn;
dText = StrSQL;
dType = ;
eNonQuery(); ("数据库操作成功！", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
} ///
/// 附加数据库
///
public void AddDataBase()
{
try
{
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn;
dText = @"sp_attach_db"; (new SqlParameter(@"dbname", ar));
ters[@"dbname"].Value = DataBaseName;
(new SqlParameter(@"filename1", ar));
ters[@"filename1"].Value = DataBase_MDF;
(new SqlParameter(@"filename2", ar));
ters[@"filename2"].Value = DataBase_LDF; dType = Procedure; //此处⼀定要⽤存储过程，还有我也认识到存储过程的参数的写法不同与SQL语句。在查询分析器中写附加数据库的语法为exec sp_attach_db @dbname=N'数据库名',@filename1=N'MDF⽂件路径',@filename2=N'LDF⽂件路径',按照我的推测，存储过程⽅式添加参数后它的值直接跟在后⾯了。 eNonQuery(); ("附加数据库成功", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
} ///
/// 分离数据库
///
public void DeleteDataBase()
{
try
{
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn; dText = "sp_detach_db"; (new SqlParameter(@"dbname", ar));
ters[@"dbname"].Value = DataBaseName; dType = Procedure;
eNonQuery(); ("分离数据库成功", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
} ///
/// 备份数据库
///
public void BackupDataBase()
{
try
{
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn;
dText = "use master;backup database @dbname to disk = @backupname;"; (new SqlParameter(@"dbname", ar));
ters[@"dbname"].Value = DataBaseName;
(new SqlParameter(@"backupname", ar));
ters[@"backupname"].Value = @DataBaseOfBackupPath + @DataBaseOfBackupName;//这⾥添加参数的⽅式就跟我以前的做法⼀样，只不过他加了@,我认识加@是个好习惯，防⽌特殊字符被转义，我以后也采⽤这种⽅式。 dType = ;
eNonQuery(); ("备份数据库成功", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
} ///
/// 还原数据库
///
public void ReplaceDataBase()
{
try
{
string BackupFile = @DataBaseOfBackupPath + @DataBaseOfBackupName;
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn;
dText = "use master;restore database @DataBaseName From disk = @BackupFile with replace;"; (new SqlParameter(@"DataBaseName", ar));
ters[@"DataBaseName"].Value = DataBaseName;
(new SqlParameter(@"BackupFile", ar));
ters[@"BackupFile"].Value = BackupFile; dType = ;
eNonQuery(); ("还原数据库成功", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
}
}有了这些⽅法，我就可以在我的安装类中附加数据库了。接下来我要学习⼀下如何让⽤户安装时有下拉框选择。测试代码如下：
private void btnAttach_Click(object sender, EventArgs e) { DataBaseControl DBC = new DataBaseControl(); tionString = "Data Source=(local);User id=⽤户名;Password=密码; Initial Catalog=master"; seName = "LabelLive"; se_MDF = @"C:Program FilesMicrosoft SQL "; se_LDF = @"C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLabelLive_"; aBase(); } private void btnDetach_Click(object sender, EventArgs e) { DataBaseControl DBC = new DataBaseControl(); tionString = "Data Source=(local);User id=⽤户名;Password=密码; Initial Catalog=master"; seName = "LabelLive"; DataBase();
} private void btnBackup_Click(object sender, EventArgs e) { DataBaseControl DBC = new DataBaseControl(); tionString = "Data Source=(local);User id=⽤户名;Password=密码; Initial Catalog=master"; seName = "LabelLive"; seOfBackupName = @""; seOfBackupPath = @"D:"; DataBase();
} private void btnRestore_Click(object sender, EventArgs e) { DataBaseControl DBC = new DataBaseControl(); tionString = "Data Source=(local);User id=⽤户名;Password=密码; Initial Catalog=master"; seName = "LabelLive"; seOfBackupName = @""; seOfBackupPath = @"D:"; eDataBase();
}
2023年6月21日发(作者：)
C#附加数据库近段时间学习了如何⽤安装包将数据库⼀起附加进去，代替了以往需要⽤户⼿⼯附加的⽅式。 ///
/// 数据库操作控制类
///
public class DataBaseControl
{
///
/// 数据库连接字符串
///
public string ConnectionString; ///
/// SQL操作语句/存储过程
///
public string StrSQL; ///
/// 实例化⼀个数据库连接对象
///
private SqlConnection Conn; ///
/// 实例化⼀个新的数据库操作对象Comm
///
private SqlCommand Comm; ///
/// 要操作的数据库名称
///
public string DataBaseName; ///
/// 数据库⽂件完整地址
///
public string DataBase_MDF; ///
/// 数据库⽇志⽂件完整地址
///
public string DataBase_LDF; ///
/// 备份⽂件名
///
public string DataBaseOfBackupName; ///
/// 备份⽂件路径
///
public string DataBaseOfBackupPath; ///
/// 执⾏创建/修改数据库和表的操作
///
public void DataBaseAndTableControl()
{
try
{
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn;
dText = StrSQL;
dType = ;
eNonQuery(); ("数据库操作成功！", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
} ///
/// 附加数据库
///
public void AddDataBase()
{
try
{
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn;
dText = @"sp_attach_db"; (new SqlParameter(@"dbname", ar));
ters[@"dbname"].Value = DataBaseName;
(new SqlParameter(@"filename1", ar));
ters[@"filename1"].Value = DataBase_MDF;
(new SqlParameter(@"filename2", ar));
ters[@"filename2"].Value = DataBase_LDF; dType = Procedure; //此处⼀定要⽤存储过程，还有我也认识到存储过程的参数的写法不同与SQL语句。在查询分析器中写附加数据库的语法为exec sp_attach_db @dbname=N'数据库名',@filename1=N'MDF⽂件路径',@filename2=N'LDF⽂件路径',按照我的推测，存储过程⽅式添加参数后它的值直接跟在后⾯了。 eNonQuery(); ("附加数据库成功", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
} ///
/// 分离数据库
///
public void DeleteDataBase()
{
try
{
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn; dText = "sp_detach_db"; (new SqlParameter(@"dbname", ar));
ters[@"dbname"].Value = DataBaseName; dType = Procedure;
eNonQuery(); ("分离数据库成功", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
} ///
/// 备份数据库
///
public void BackupDataBase()
{
try
{
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn;
dText = "use master;backup database @dbname to disk = @backupname;"; (new SqlParameter(@"dbname", ar));
ters[@"dbname"].Value = DataBaseName;
(new SqlParameter(@"backupname", ar));
ters[@"backupname"].Value = @DataBaseOfBackupPath + @DataBaseOfBackupName;//这⾥添加参数的⽅式就跟我以前的做法⼀样，只不过他加了@,我认识加@是个好习惯，防⽌特殊字符被转义，我以后也采⽤这种⽅式。 dType = ;
eNonQuery(); ("备份数据库成功", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
} ///
/// 还原数据库
///
public void ReplaceDataBase()
{
try
{
string BackupFile = @DataBaseOfBackupPath + @DataBaseOfBackupName;
Conn = new SqlConnection(ConnectionString);
(); Comm = new SqlCommand();
tion = Conn;
dText = "use master;restore database @DataBaseName From disk = @BackupFile with replace;"; (new SqlParameter(@"DataBaseName", ar));
ters[@"DataBaseName"].Value = DataBaseName;
(new SqlParameter(@"BackupFile", ar));
ters[@"BackupFile"].Value = BackupFile; dType = ;
eNonQuery(); ("还原数据库成功", "信息提⽰", , ation);
}
catch (Exception ex)
{
(e, "信息提⽰", , ation);
}
finally
{
();
}
}
}有了这些⽅法，我就可以在我的安装类中附加数据库了。接下来我要学习⼀下如何让⽤户安装时有下拉框选择。测试代码如下：
private void btnAttach_Click(object sender, EventArgs e) { DataBaseControl DBC = new DataBaseControl(); tionString = "Data Source=(local);User id=⽤户名;Password=密码; Initial Catalog=master"; seName = "LabelLive"; se_MDF = @"C:Program FilesMicrosoft SQL "; se_LDF = @"C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataLabelLive_"; aBase(); } private void btnDetach_Click(object sender, EventArgs e) { DataBaseControl DBC = new DataBaseControl(); tionString = "Data Source=(local);User id=⽤户名;Password=密码; Initial Catalog=master"; seName = "LabelLive"; DataBase();
} private void btnBackup_Click(object sender, EventArgs e) { DataBaseControl DBC = new DataBaseControl(); tionString = "Data Source=(local);User id=⽤户名;Password=密码; Initial Catalog=master"; seName = "LabelLive"; seOfBackupName = @""; seOfBackupPath = @"D:"; DataBase();
} private void btnRestore_Click(object sender, EventArgs e) { DataBaseControl DBC = new DataBaseControl(); tionString = "Data Source=(local);User id=⽤户名;Password=密码; Initial Catalog=master"; seName = "LabelLive"; seOfBackupName = @""; seOfBackupPath = @"D:"; eDataBase();
}
发布评论