SqlCommandBuilder 的使用实例

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

using System.Collections.Generic;

 

namespace DataContrast

{

    public partial class SQLCommandBuilder_Demo : System.Web.UI.Page

    {

        protected void Page_Load( object sender, EventArgs e )

        {

            SqlConnection conn = new SqlConnection( "Data Source=zhengchenhan;Initial Catalog=zchtest;Integrated Security=True" );

 

            //这里一定要把ID也select进去因为这个是这个表的主键，SELECT的结果保存成了一个表放在服务器上而不是连到数据库

            SqlDataAdapter adpter = new SqlDataAdapter( "select Id,Name,Pwd from Users", conn );

 

            //建立SqlCommandBuilder 用于执行SQL语句

            SqlCommandBuilder cmdbuilder = new SqlCommandBuilder( adpter );

            DataSet DS = new DataSet();

 

            adpter.Fill( DS, "Users" );//这里的Users不是指数据库中的表名，是指DS中药创建的填充数据的DataTable对象名称

            Response.Write( "修改前" + DS.Tables["Users"].Rows[4]["Name"] + "ID" + DS.Tables["Users"].Rows[4]["Id"] );

 

            DS.Tables["Users"].Rows[4]["Name"] = "gfds";

            adpter.Update( DS, "Users" );           //没有select的话这里就要报错了

            Response.Write( "修改后" + DS.Tables["Users"].Rows[4]["Name"] );

            conn.Close();

        }

 

    }

}