谁能给个数据库备份还远的源代码？

Question

SQL server 2005  VS2005

Answer 1

public void beifenInfo()
        {
            try
            {
                sd.InitialDirectory = Application.StartupPath + "\\";//默认路径为D：//
                sd.FilterIndex = 1;                                //默认值为第一个
                sd.RestoreDirectory = true;                        //重新定位保存路径
                sd.Filter = "备份文件 (*.bak)|*.bak|所有文件 (*.*)|*.*";//筛选器，定义文件类型
                if (sd.ShowDialog() == DialogResult.OK)
                {
                    if (!File.Exists(sd.FileName.ToString()))
                    {
                        SqlConnection con = new SqlConnection();        //利用代码实现连接数据库
                        con.ConnectionString = "server=.;uid=sa;pwd=;database='"+this.comboBox1.Text+"'";
                        con.Open();
                        SqlCommand com = new SqlCommand();
                        this.textBox1.Text = sd.FileName.ToString();
                        com.CommandText = "BACKUP DATABASE " + this.comboBox1.Text + " TO DISK = '" + sd.FileName.ToString() + "'";
                        com.Connection = con;                            //连接
                        com.ExecuteNonQuery();                            //执行
                        con.Close();
                        con.Dispose();
                        MessageBox.Show("数据备份成功！");
                    }
                    else
                    {
                        MessageBox.Show("请重新命名！");
                    }
                }
            }
            catch (Exception k)
            {
                MessageBox.Show(k.Message);
                return;
            }
        }