ADO.NET中DataSet的使用

1.读取：

 

在web.config添加：

 

 <connectionStrings>
  <add name="carConnectionString" connectionString="Data Source=JY-LANBJ;Initial Catalog=car;Persist Security Info=True;User ID=root;Password=root" providerName="System.Data.SqlClient"/>
 </connectionStrings>

 

 

在**.aspx.cs页面的Page_Load方法中添加：

 

SqlConnection con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["carConnectionString"].ToString());
        {
            string cmd1 = "select * from carworkers";
            SqlDataAdapter da = new SqlDataAdapter(cmd1, con);
            DataSet ds = new DataSet();//创建数据集
            da.Fill(ds);//填充数据集
            DataTable dt = ds.Tables[0];    

            for (int i = 0; i < dt.Rows.Count;i++ )
            {
                Response.Write(dt.Rows[i]["power"].ToString() + "<BR>");
               
            }

        }

 

 注意先添加以下命名空间：

using System.Data.SqlClient; 
using System.Data;
using System.Configuration;

 

---------------------------------------------------------------------------------------------------------------------------------

 

 

2.插入：

 

在**.aspx.cs页面的Page_Load方法中添加：

 

 SqlConnection con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["carConnectionString"].ToString());
        {
            string cmd1 = "select * from carworkers";
            SqlDataAdapter da = new SqlDataAdapter(cmd1, con);
            SqlCommandBuilder cb = new SqlCommandBuilder(da);    //为Adapter创建builder实例，才可以进行插入、修改、更新
            DataSet ds = new DataSet();//创建数据集
            da.Fill(ds);//填充数据集
            DataTable dt = ds.Tables[0];
            DataRow newRow = dt.NewRow();
            newRow["username"] = "Jolin";
            newRow["power"] = 0;
            newRow["id"] = 99;
            dt.Rows.Add(newRow);
            da.Update(ds);
            for (int i = 0; i < dt.Rows.Count;i++ )
            {
                Response.Write(dt.Rows[i]["power"].ToString() + "<BR>");
               
            }

        }

 

 

 

 ---------------------------------------------------------------------------------------------------------------------------------

3.删除

在**.aspx.cs页面的Page_Load方法中添加：

        SqlConnection con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["carConnectionString"].ToString());
        {
            string cmd1 = "select * from works where wid='" + did+"'";
            SqlDataAdapter da = new SqlDataAdapter(cmd1, con);
            SqlCommandBuilder cb = new SqlCommandBuilder(da);    //为Adapter创建builder实例，才可以进行插入、修改、更新
            con.Open();
            DataSet dss = new DataSet();//创建数据集
            da.Fill(dss);//填充数据集
            DataTable dt = dss.Tables[0];
            dt.Rows[0].Delete();
            da.Update(dss);
            con.Close();
            Response.Write("<script LANGUAGE='javascript'>location.href ='default.aspx?username="+username+"';</script>");

        }