SqlCommandBuilder对像来自动构建sql命令

string  sConnectonString;
            sConnectonString  =   " Password=sa;user id = sa;Initial Catalog = master;Data Source=(local) " ;
            SqlConnection objConn  =   new  SqlConnection(sConnectonString);
            objConn.Open();
                       
            SqlDataAdapter daAuthors  =   new  SqlDataAdapter( " select * from city_users " , objConn);
            DataSet dsMaster  =   new  DataSet( " master " );
            daAuthors.FillSchema(dsMaster, SchemaType.Source,  " city_users " ); // 加载表的构架，这样在操作加载到dataset里的表时就不用重新设置主键了
            daAuthors.Fill(dsMaster,  " city_users " );
            dsMaster.Tables[ " city_users " ].Rows[ 1 ][ " user_name " ]  =   " sql " ; // 注意这里的Rows[1]，这个1指得是在DataSet里的表里的行号，其与数据库里的行号不一致如图1
            
            SqlCommandBuilder objCommandBuilder  =   new  SqlCommandBuilder(daAuthors); // 构建sql命令
            daAuthors.Update(dsMaster,  " city_users " ); // 更新
             // daAuthors.UpdateCommand = updatecomm;
             // daAuthors.UpdateCommand.ExecuteNonQuery();
            objConn.Close();

转载于:https://www.cnblogs.com/RobotTech/archive/2007/01/09/616141.html