mehdio
پنج شنبه 09 مرداد 1393, 15:42 عصر
با سلام من یک برنامه با زبان C# و پایگاه داده SQL EXPRESS نوشتم که کد زیر را برای بک آپ گیری از آن استفاده می کنم
string strFileName = "BackupFile.bak";
try
{
this.Cursor = Cursors.WaitCursor;
SqlCommand cmd = new SqlCommand();
SqlConnection.ClearAllPools();
cmd.Connection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\mehdi.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
cmd.Connection.Open();
string dbname = cmd.Connection.Database;
cmd.Connection.Close();
string query = "<SPAN class=highlight>BACKUP</SPAN> DATABASE [" + dbname + "] TO DISK ='c:\\" + strFileName + "' WITH NO_COMPRESSION ,CONTINUE_AFTER_ERROR ,FORMAT, INIT, NAME = N'accounting-Full Database <SPAN class=highlight>Backup</SPAN>', SKIP,NOREWIND, NOUNLOAD, STATS = 10";
cmd.Connection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\mehdi.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;");
cmd.Connection.Open();
cmd.CommandText = query;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
this.Cursor = Cursors.Default;
MessageBox.Show("تهیه نسخه پشتیبان از اطلاعات با موفقیت انجام شد", "پشتیبان <SPAN class=highlight>گیری</SPAN>", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Error Occurd : " + ex.Message);
}
ولی موقع اجرا خطای زیر را میده
Incorrect syntax near '<'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
string strFileName = "BackupFile.bak";
try
{
this.Cursor = Cursors.WaitCursor;
SqlCommand cmd = new SqlCommand();
SqlConnection.ClearAllPools();
cmd.Connection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\mehdi.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
cmd.Connection.Open();
string dbname = cmd.Connection.Database;
cmd.Connection.Close();
string query = "<SPAN class=highlight>BACKUP</SPAN> DATABASE [" + dbname + "] TO DISK ='c:\\" + strFileName + "' WITH NO_COMPRESSION ,CONTINUE_AFTER_ERROR ,FORMAT, INIT, NAME = N'accounting-Full Database <SPAN class=highlight>Backup</SPAN>', SKIP,NOREWIND, NOUNLOAD, STATS = 10";
cmd.Connection = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\mehdi.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;");
cmd.Connection.Open();
cmd.CommandText = query;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
this.Cursor = Cursors.Default;
MessageBox.Show("تهیه نسخه پشتیبان از اطلاعات با موفقیت انجام شد", "پشتیبان <SPAN class=highlight>گیری</SPAN>", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Error Occurd : " + ex.Message);
}
ولی موقع اجرا خطای زیر را میده
Incorrect syntax near '<'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.