从ADO中建立临时表、

public partial class data1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
         //1创建一个临时的数据库
            DataSet ds = new DataSet("School");
         //2创建一个临时数据表
            DataTable dt = new DataTable("Student");
            //2.1为dt增加列
            DataColumn dcAutoId = new DataColumn("FId");
            dcAutoId.AutoIncrement = true;//是否是主键AutoIncrement
            dcAutoId.AutoIncrementSeed = 1;
            dcAutoId.AutoIncrementStep = 1;
            dt.Columns.Add(dcAutoId);//把这个列加到dt这个表中
            //2.2再来增加2列
            dt.Columns.Add("studentName", typeof(string));
            dt.Columns.Add("studentPwd", typeof(string));
            //2.3为表dt增加行
            DataRow dr = dt.NewRow();
            dr[1] = "YQQ";
            dr[1] = "555";
            dt.Rows.Add(dr);//把行添加到表中
         //3.把数据表dt放到ds数据库中
            ds.Tables.Add(dt);
            //循环输出
            //foreach(DataTable dtItem in ds.Tables)
            //{
            //    Response.Write("===" + dtItem.TableName + "===");//输出表名
            //    Response.Write("<p>");
            //    //之后还要输出表中的每一行
            //    foreach (DataRow drItem in dtItem.Rows)
            //    {
            //    //循环取出每行中的每一列
            //        for (int i = 0; i < dtItem.Columns.Count; i++)
            //        {
            //            Response.Write(drItem[1].ToString()+"&nbsp&nbsp&nbsp&nbsp");
            //        }
            //        Response.Write("<br>");
            //    }

            //}

            GridView1.DataSource = ds.Tables[0];
            GridView1.DataBind();

        }
    }

 

从数据库中读出表：

<div>
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>
        <br />
        <asp:Button ID="Button1" runat="server" οnclick="Button1_Click" Text="Button" />
    </div>

 

 protected void Button1_Click(object sender, EventArgs e)
        {
            string constr = "";
            string sql = "select * from MyStudents";
            SqlDataAdapter adpter= new SqlDataAdapter(sql,constr);//内部自动生成connection对象和command对象
        
            DataSet ds = new DataSet();
            adpter.Fill(ds);
            
            GridView1.DataSource = ds.Tables[0];
            GridView1.DataBind();

        }