SqlCommandBuilder在数据库操作中的应用示例

SqlCommandBuilder2008-12-13 09:48public static void ADOUpdate()
        {
            using (SqlConnection conn = new SqlConnection())
            {
                conn.ConnectionString = "server=.;uid=huashanlin;pwd=123;database=DB;";
                conn.Open();
                DataSet ds = new DataSet();
                SqlDataAdapter sda = new SqlDataAdapter("select * from [msg]", conn);
                //使用关联的 System.Data.SqlClient.SqlDataAdapter 对象初始化 System.Data.SqlClient.SqlCommandBuilder类的新实例。
                SqlCommandBuilder Builder = new SqlCommandBuilder(sda); 
                SqlCommand cmd = Builder.GetUpdateCommand();
                Console.WriteLine(cmd.CommandText.ToString());

                cmd = Builder.GetDeleteCommand();
                Console.WriteLine(cmd.CommandText.ToString());

                cmd = Builder.GetInsertCommand();
                Console.WriteLine(cmd.CommandText.ToString());
                //使用DataAdapter讲查询到的数据表填充到DataSet中，命名为"A"
                sda.Fill(ds, "A");

                //以下更改DataTabe中的数据
                DataTable dt = ds.Tables["A"];
                //编辑DataTable的某一行
                DataRow dr = ds.Tables[0].Rows[1];
                dr.BeginEdit();
                dr[1] = "test";
                dr["Email"] = "tet@mm.com";
                dr.EndEdit();
                //为DataTable增加一行