soonami
جمعه 26 دی 1393, 16:38 عصر
دوستان من این سایت و سایت های دیگر گشتم ولی متاسفانه هر کدام یک جوری ارور میدهند مثلا کد زیر :::::::::
نام بانک اطلاعاتی بنده :::: amozesh است
______________________________________
private void پشتیبانگیریToolStripMenuItem_Click(obje ct sender, EventArgs e)
{
string filename = string.Empty;
SaveBackUp.OverwritePrompt = true;
SaveBackUp.DefaultExt = "";
SaveBackUp.Filter = @"SQL Backup Files ALL Files (*.*) |*.*| (*.Bak)|*.Bak";
SaveBackUp.FilterIndex = 1;
string DateDay = DateTime.Now.ToString().Substring(0, 10);
SaveBackUp.FileName = DateDay.Replace("/", "") + "_" + DateTime.Now.Hour.ToString() + "-" + DateTime.Now.Minute.ToString() + "-" + DateTime.Now.Second.ToString();
SaveBackUp.Title = "Backup SQL File";
if (SaveBackUp.ShowDialog() == DialogResult.OK)
{
filename = SaveBackUp.FileName;
Backup(filename);
}
}
private void Backup(string filename)
{
try
{
string command = @"Backup DataBase amozesh To Disk='" + filename + "'";
this.Cursor = Cursors.WaitCursor;
SqlCommand ocommand = null;
SqlConnection oconnection = null;
oconnection = new SqlConnection("Data Source=.;Initial Catalog=amozesh");
if (oconnection.State != ConnectionState.Open)
oconnection.Open();
ocommand = new SqlCommand(command, oconnection);
ocommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
MessageBox.Show("تهیه نسخه پشتیبان از اطلا عات با موفقیت انجام شد");
}
catch (Exception ex)
{
MessageBox.Show("Error::::::::::::::::::::::::::::::::::::::::::::: :::::: ", ex.Message);
}
}
127606
نام بانک اطلاعاتی بنده :::: amozesh است
______________________________________
private void پشتیبانگیریToolStripMenuItem_Click(obje ct sender, EventArgs e)
{
string filename = string.Empty;
SaveBackUp.OverwritePrompt = true;
SaveBackUp.DefaultExt = "";
SaveBackUp.Filter = @"SQL Backup Files ALL Files (*.*) |*.*| (*.Bak)|*.Bak";
SaveBackUp.FilterIndex = 1;
string DateDay = DateTime.Now.ToString().Substring(0, 10);
SaveBackUp.FileName = DateDay.Replace("/", "") + "_" + DateTime.Now.Hour.ToString() + "-" + DateTime.Now.Minute.ToString() + "-" + DateTime.Now.Second.ToString();
SaveBackUp.Title = "Backup SQL File";
if (SaveBackUp.ShowDialog() == DialogResult.OK)
{
filename = SaveBackUp.FileName;
Backup(filename);
}
}
private void Backup(string filename)
{
try
{
string command = @"Backup DataBase amozesh To Disk='" + filename + "'";
this.Cursor = Cursors.WaitCursor;
SqlCommand ocommand = null;
SqlConnection oconnection = null;
oconnection = new SqlConnection("Data Source=.;Initial Catalog=amozesh");
if (oconnection.State != ConnectionState.Open)
oconnection.Open();
ocommand = new SqlCommand(command, oconnection);
ocommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
MessageBox.Show("تهیه نسخه پشتیبان از اطلا عات با موفقیت انجام شد");
}
catch (Exception ex)
{
MessageBox.Show("Error::::::::::::::::::::::::::::::::::::::::::::: :::::: ", ex.Message);
}
}
127606