

两个查找已经编好
private void button3_Click(object sender, EventArgs e)
{
this.folderBrowserDialog1.ShowNewFolderButton = true;
this.folderBrowserDialog1.ShowDialog();
this.textBox2.Text = this.folderBrowserDialog1.SelectedPath;
}
private void button4_Click(object sender, EventArgs e)
{
this.folderBrowserDialog1.ShowNewFolderButton = true;
this.folderBrowserDialog1.ShowDialog();
this.textBox2.Text = this.folderBrowserDialog1.SelectedPath;
}
但是备份还是有问题
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=.;database=小区物业;uid=sky;pwd=");
string Str_dar = "";
if (radioButton1.Checked == true)
{
Str_dar = System.Environment.CurrentDirectory + "C:\Users\sty\Documents\Visual Studio 2008\Projects\WindowsFormsApplication1\bar";
}
if (radioButton2.Checked == true)
{
Str_dar = textBox2.Text + "\\";
}
if (textBox2.Text == "" & radioButton2.Checked == true)
{
MessageBox.Show("请选择备份数据库文件的路径");
return;
}
try
{
string path = this.folderBrowserDialog1.SelectedPath;
string sql = string.Format("Backup database 小区物业 to disk = textBox2.Text");
SqlConnection coon = new SqlConnection("server=.;database=小区物业;uid=sky;pwd=");
coon.Open();
SqlCommand command = new SqlCommand(sql, coon);
command.ExecuteNonQuery();
MessageBox.Show("数据备份成功", "提示",MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
大神们求教
------解决思路----------------------
string sql = string.Format("Backup database 小区物业 to disk = textBox2.Text");
string sql = string.Format("Backup database 小区物业 to disk = " + textBox2.Text);

------解决思路----------------------
string sql = string.Format("Backup database 小区物业 to disk = '" + textBox2.Text +"'");