用非类型化的DataSet和类型化的数据集完成用户信息的增删改查（两种方法）

一：用数据集制作：

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using DataSet1TableAdapters;

using System.Data;

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

{

    protected void Page_Load(object sender, EventArgs e)

    {

        UsersTableAdapter adapter = new UsersTableAdapter();

        DataSet1.UsersDataTable table = new DataSet1.UsersDataTable();

        adapter.Fill(table);

        //table[0].name = "张小平";                            //修改

        //table[3].Delete();                                    //删除

        //DataSet1.UsersRow row = table.NewUsersRow();         //增加

        //row.uid = "004";

        //row.name = "保定";

        //row.password = "123";

        //row.power = 2;

        //row._lock = false;

        //table.Rows.Add(row);

         DataRow[] rows = table.Select("name='张三'");            //查找

         Response.Write(rows[0]["uid"] + "  |  " + rows[0]["name"].ToString() + "  |  " + rows[0]["password"] + "  |  " + rows[0]["power"] + "  |  " + rows[0]["lock"]);

        adapter.Update(table);                     //这句话必须有否则只能更新视图不能更新数据库

        this.GridView1.DataSource = table;

        this.GridView1.DataBind();

    }

}

二：用DataSet做：

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

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

{

    protected void Page_Load(object sender, EventArgs e)

    {

        DataSet ds = new DataSet();

        string str = ConfigurationManager.ConnectionStrings["sqlstring"].ConnectionString;

        using (SqlConnection sqlcnn = new SqlConnection(str))

        {

            SqlCommand sqlcmm = sqlcnn.CreateCommand();

            sqlcmm.CommandText = "select * from Users";

            SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);

            adapter.Fill(ds, "Users");

            //ds.Tables["Users"].Rows[0].Delete();          //删除

            //ds.Tables["Users"].Rows[1]["name"] = "李?四?";    //修改

            //DataRow dr = ds.Tables[0].NewRow();               //增加

            //dr["uid"] = 0007;

            //dr["name"] = "赵?六ⅷ?;

            //dr["password"] = 123;

            //dr["power"]=0;

            //dr["lock"] = false;

            //ds.Tables[0].Rows.Add(dr);

            //DataRow[] rows = ds.Tables[0].Select("name='张三'");

//查找

 //Response.Write(rows[0]["name"].ToString()+rows[0]["password"]);

            //DataRow []rows=t.Select("Dname='"+TextBox3 .Text .Trim ()+"'","id DESC");

            SqlCommandBuilder builder = new SqlCommandBuilder(adapter);

            adapter.Update(ds, "Users");//这句话必须有否则只能更新视图不能更新数据库

        }

        this.GridView1.DataSource = ds.Tables[0];

        this.GridView1.DataBind();

    }

}