private void btnGo_Click(object sender, EventArgs e)
{
this.txtFile.Text = this.folderBrowserDialog1.SelectedPath.ToString().Trim();
string saveAway = this.txtFile.Text;
string cmdText = @"backup database ERP_DB to disk='" + saveAway + "'";
BakReductSql(cmdText, true); } private void BakReductSql(string cmdText, bool isBak)
{
SqlCommand cmdBakRst = new SqlCommand();
SqlConnection conn = new SqlConnection("Data Source=WANGKAI;Initial Catalog=ERP_DB;uid=sa;pwd=sasa;");
try
{
conn.Open();
cmdBakRst.Connection = conn;
cmdBakRst.CommandType = CommandType.Text; cmdBakRst.CommandText = cmdText;
cmdBakRst.ExecuteNonQuery();
MessageBox.Show("恭喜,你已经成功备份当前数据!", "系统消息"); }
catch (Exception ex)
{ MessageBox.Show("对不起,操作失败", "系统消息");
}
finally
{
cmdBakRst.Dispose();
conn.Close();
conn.Dispose();
}
}昨天一下午解决这个问题..始终找不到原因,还是请各位兄弟帮个忙,麻烦指点下吧
{
this.txtFile.Text = this.folderBrowserDialog1.SelectedPath.ToString().Trim();
string saveAway = this.txtFile.Text;
string cmdText = @"backup database ERP_DB to disk='" + saveAway + "'";
BakReductSql(cmdText, true); } private void BakReductSql(string cmdText, bool isBak)
{
SqlCommand cmdBakRst = new SqlCommand();
SqlConnection conn = new SqlConnection("Data Source=WANGKAI;Initial Catalog=ERP_DB;uid=sa;pwd=sasa;");
try
{
conn.Open();
cmdBakRst.Connection = conn;
cmdBakRst.CommandType = CommandType.Text; cmdBakRst.CommandText = cmdText;
cmdBakRst.ExecuteNonQuery();
MessageBox.Show("恭喜,你已经成功备份当前数据!", "系统消息"); }
catch (Exception ex)
{ MessageBox.Show("对不起,操作失败", "系统消息");
}
finally
{
cmdBakRst.Dispose();
conn.Close();
conn.Dispose();
}
}昨天一下午解决这个问题..始终找不到原因,还是请各位兄弟帮个忙,麻烦指点下吧
我在本地备份,文件夹也是刚才新建的一个,怎么会没有权限呢
什么系统