//end
//----------------------------------------------------------------
public void BackUpDb(string fileName, string filePath)
{
string sqlBackup = "BACKUP DATABASE [" + fileName + "] TO DISK='" + filePath + "'";
ClsConnectLocal cnn = new ClsConnectLocal();
cnn.ClsConnect();
cnn.UpdateDataText(sqlBackup);
cnn.DongKetNoi();
}
public void RestoreDb(string fileName, string filePath)
{
string sqlRestore = "Use master Restore Database [" + fileName + "] from DISK='" + filePath + "'";
string drop = "drop database " + fileName;
ClsConnectLocal cnn = new ClsConnectLocal();
cnn.ClsConnect();
cnn.UpdateDataText(drop);
cnn.UpdateDataText(sqlRestore);
cnn.DongKetNoi();
}
