using (SqlConnection conn4 = new SqlConnection(DbConfigClass.connectDb())) { string database = conn4.Database.ToString(); try { if (PathtextBox.Text == string.Empty) { } else { string cmd = "BACKUP DATABASE ["+database+"] TO DISK '"+PathtextBox.Text+"\\"+"Database"+"-"+DateTime.Now.Ticks.ToString("yyyy-MM-dd--HH-mm-ss")+ ".back'"; using (SqlCommand comand = new SqlCommand(cmd, conn4)) { if (conn4.State != ConnectionState.Open) { conn4.Open(); } comand.ExecuteNonQuery(); conn4.Close(); MessageBoxClass.ShowSucessMessage("Successful to backup data","Successful"); } } } catch (Exception es) { MessageBoxClass.ShowErrorMessage("" + es, ""); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)