public string filename;
private void btnBackup_Click(object sender, EventArgs e)
{
DialogResult ss = MessageBox.Show("آيا از بانك پشتيبان مي گيريد", "َAFTA", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (ss == DialogResult.Yes)
{
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
try
{
conn.Open();
conn.Close();
/////
SqlCommand backup = new SqlCommand();
backup.Connection = sqlConnection2;
backup.CommandText = "backup database AFTA to disk ='" + savePatch + "' WITH FORMAT";
sqlConnection2.Open();
if (backup.ExecuteNonQuery() == -1)
{
MessageBox.Show("OK");
}
sqlConnection2.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
sqlConnection2.Close();
}
}
}
}