c#+SQL SERVER2000(见Visual C#数据库高级编程224-226页)

先在master 数据库建立存储过程
CREATE PROCEDURE BackUp_pubs
@Device_Name Varchar(80),
@File_Name Varchar(125)
As

If Exists(Select @File_Name)
Begin
     --创建数据库备分逻辑设备
      Exec Sp_Addumpdevice 'Disk',@Device_Name,@File_Name
    --备份数据
     Backup Database pubs To @Device_Name
End
GO


C#中如下代码

        private void button1_Click(object sender, System.EventArgs e)
        {
            SqlConnection myConnection=new SqlConnection("persist security info=False;Integrated Security=SSPI;server=localhost;Trusted_Connection=true;database=master");
            SqlCommand myCommand=new SqlCommand("BackUp_pubs",myConnection);

            myCommand.CommandType=CommandType.StoredProcedure;
            try
            {
                SqlParameter parameterDevice_Name=new SqlParameter("@Device_Name",SqlDbType.VarChar,80);
                parameterDevice_Name.Value=textBox1.Text;
                myCommand.Parameters.Add(parameterDevice_Name);

                SqlParameter parameterFile_Name=new SqlParameter("@File_Name",SqlDbType.VarChar,125);
                parameterFile_Name.Value=textBox2.Text;
                myCommand.Parameters.Add(parameterFile_Name);

                myConnection.Open();
                myCommand.ExecuteNonQuery();
            }
            catch
            {
                myConnection.Close();
                MessageBox.Show("检查您的参数！","提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
                return;
            }
            myConnection.Close();
            MessageBox.Show("成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
        }
编译运行程序,在textBox1中输入MyDevice 在textBox2中输入D:\MyBackup
然后点button1,会跳出来说检查您的参数!
不知道是哪错了