有那位高人会,在WINFORMS程序内进行对数据库的分离,附加啊?现在那个急啊

最好回复的高人在回复时在代码上多做些注释,本人菜鸟一名,谢谢" border="0" />

菜鸟版主?

private void button1_Click(object sender, System.EventArgs e)
        {
            SqlConnection con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local);pooling=false");
            SqlCommand cmd=new SqlCommand();
            cmd.Connection=con;
             sp_attach_db @dbname,@filename1,@filename2";
            SqlParameter para=cmd.Parameters.Add("@dbname",SqlDbType.VarChar,20);
            para.Value="abc";
            para=cmd.Parameters.Add("@filename1",SqlDbType.NVarChar,260);
            para.Value=Application.StartupPath+"\\abc_Data.MDF";
            para=cmd.Parameters.Add("@filename2",SqlDbType.NVarChar,260);
            para.Value=Application.StartupPath+"\\abc_Log.LDF";
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("已成功附加数据库");
        }

private void button2_Click(object sender, System.EventArgs e)
        {
            SqlConnection con=new SqlConnection("database=master;user id=sa;password=sa;data source=(local);pooling=false");
            SqlCommand cmd=new SqlCommand();
            cmd.Connection=con;
             sp_detach_db @dbname,@skipchecks";
            SqlParameter para=cmd.Parameters.Add("@dbname",SqlDbType.VarChar,20);
            para.Value="abc";
            para=cmd.Parameters.Add("@skipchecks",SqlDbType.NVarChar,10);
            para.Value="true";
            con.Open();
            try
            {
                cmd.ExecuteNonQuery();
            }
            catch(SqlException er)
            {
                MessageBox.Show(er.Message);
                return;
            }
            con.Close();
            MessageBox.Show("已成功分离数据库");
        }

关注关注

网上书上教程蛮多的
顶一个~~~

谢了,我对.NET是个菜鸟,七窍里通了六窍
" border="0" />

那老兄是怎么当上版主的？咱们论坛应该好好反醒一下了

Oracle 的版主一定要懂得 C# ..?

.................