فهمیدم مشکل از چی بود
آقای danialafshari این کد رو امتحان کنید همونطور که گفتم تغییر یافته کد دوستمون firoozi90 هست.
امیدوارم شما هم مثل من جواب بگیرید
bool bBackUpStatus = true;
Cursor.Current = Cursors.WaitCursor;
if (Directory.Exists(@"d:\SQLBackup"))
{
if (File.Exists(@"d:\SQLBackup\MelkAra_Db.bak"))
{
if (MessageBox.Show(@"??? ???????? ??????? ?????? ???????", "??????? ????? ??? ???", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
File.Delete(@"d:\SQLBackup\MelkAra_Db.bak");
}
else
bBackUpStatus = false;
}
}
else
Directory.CreateDirectory(@"d:\SQLBackup");
if (bBackUpStatus)
{
//Connect to DB
SqlConnection connect;
string con = "Data Source=.\\SQLEXPRESS; AttachDbFilename=" + Application.StartupPath + "\\MelkAra_Db.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True";
//string con = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\MelkAra_Db.mdf;Integrated Security=True;User Instance=True";
connect = new SqlConnection(con);
connect.Open();
//-------------------------------ww.papro.blogfa.com--------------------------------
//Execute SQL------ww.papro.blogfa.com---------
SqlCommand command;
command = new SqlCommand(@"backup database [" + System.Windows.Forms.Application.StartupPath + "\\MelkAra_Db.mdf] to disk ='d:\\SQLBackup\\MelkAra_Db.bak' with init,stats=10", connect);
//command = new SqlCommand(@"backup database MelkAra_Db to disk ='d:\SQLBackup\MelkAra_Db.bak' with init,stats=10", connect);
command.ExecuteNonQuery();
//---------------------------------ww.papro.blogfa.com-------------------------------------
connect.Close();
MessageBox.Show("??????? ???? ?? ?????? ????? ??", "??????? ???", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
پاسخ با نقل قول
