我下面的备份代码该怎么改进才能实现保存路径的选择呢???
- C# code
protected void btnBackUp_Click(object sender, EventArgs e) { string ConnctionString = "Data Source=.;User ID=sa;Password=123;Database='" + this.dbName.SelectedValue + "'"; string dbbackupfilepath = Server.MapPath("~/DBBackUpFile/DataBase"); string strSQL = "backup database " + this.dbName.SelectedValue + " to disk='" + dbbackupfilepath + "\\" + this.tbPosition.Text.Trim() + ".bak'"; try { //判断该路径下是否已经有该文件了 if (File.Exists(dbbackupfilepath + "\\" + this.tbPosition.Text.Trim() + ".bak")) { //存在此文件,提示错误 ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert('文件名已存在,请重新命名!');</script>"); return; } else { using (SqlConnection con = new SqlConnection(ConnctionString)) { con.Open(); using (SqlCommand cmd = new SqlCommand(strSQL, con)) { cmd.ExecuteNonQuery(); ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert('数据库备份成功!');</script>"); } } } } catch (Exception ex) { ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert('备份数据库失败!原因是:" + ex.Message + "');</script>"); } }
------解决方案--------------------------------------------------------
手动选择保存路径好像要自己绘制选择对话框,b/s中很少见到这种做法,一般采用将存储路径放在配置文件中,达到不需要修改程序,修改存储路径的效果。
------解决方案--------------------------------------------------------
添加个下拉列表框,选择路劲。把路劲传到后台代码。
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
有个控件FILEUPLOAD也许对你有帮助,代码你再优化吧。。。
------解决方案--------------------------------------------------------
可能你要关监狱了 呵呵
------解决方案--------------------------------------------------------
看了这段代码你就知道了
protected override void dataProduct_MouseDoubleClick(object sender, MouseEventArgs e)
{
base.dataProduct_MouseDoubleClick(sender, e);
if (dataProduct.CurrentCell.ColumnIndex != -1)
{
int indexNum = dataProduct.CurrentCell.ColumnIndex;
string ColumnText = dataProduct.Columns[indexNum].HeaderText.ToString();
string strsNO = dataProduct.Rows[dataProduct.CurrentRow.Index].Cells["序号"].EditedFormattedValue.ToString().Trim();
string strhtNO = dataProduct.Rows[dataProduct.CurrentRow.Index].Cells["h_code"].EditedFormattedValue.ToString().Trim();
if (ColumnText == "附件")
{
OpenFileDialog OpenFileDialog1 = new OpenFileDialog();
OpenFileDialog1.Filter = "All files (*.*)|*.*|(*.pdf)|*.pdf|(*.xls)|*.xls|(*.doc)|*.doc|(*.jpg)|*.jpg";
OpenFileDialog1.FilterIndex = 0;
OpenFileDialog1.Title = "";
OpenFileDialog1.Multiselect = false;
if (OpenFileDialog1.ShowDialog() == DialogResult.OK)