asp.net数据绑定与显示等笔记

protected void Page_Load(object sender, EventArgs e)
    {
        string constr = System.Configuration.ConfigurationManager.AppSettings["jiangbinConnectionString"].ToString();
        string comstr = "select * from news";
        SqlConnection sqlcon = new SqlConnection(constr);
        sqlcon.Open();
        SqlCommand sqlcom = new SqlCommand(comstr,sqlcon);
        SqlDataReader dreader = sqlcom.ExecuteReader();
        GridView1.DataSource = dreader;
        GridView1.DataKeyNames = new string[] { "xuhao" };
       GridView1.DataBind();
        dreader.Close();
     
    }将SqlDataReader上的数据绑定到gridview上面代码

 

 

 

    protected void Page_Load(object sender, EventArgs e)
    {
        string constr = System.Configuration.ConfigurationManager.AppSettings["jiangbinConnectionString"].ToString();
        string comstr = "select * from news";
        SqlConnection sqlcon = new SqlConnection(constr);
        sqlcon.Open();
        SqlCommand sqlcom = new SqlCommand(comstr,sqlcon);
        SqlDataReader dreader = sqlcom.ExecuteReader();
        Repeater1.DataSource = dreader;
        //Repeater1.DataKeyNames = new string[] { "xuhao" };
        Repeater1.DataBind();
        dreader.Close();
     
    }将sqldatareader上的数据绑定到repeater上

 

 

     string connetionstring = System.Configuration.ConfigurationManager.AppSettings["jiangbinConnectionString"].ToString();
        SqlConnection conn = new SqlConnection(connetionstring);
        conn.Open();
        string sqlstr = "select * from news";
        SqlDataAdapter cmd = new SqlDataAdapter(sqlstr,conn);
        DataSet ds=new DataSet();
        cmd.Fill(ds);
       
        DataList1.DataSource = ds;
 
        DataList1.DataBind();
        conn.Close(); 将dataset里的数据绑定到datalist上面

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

<asp:DataList ID="DataList1" runat="server">
        <ItemTemplate>
        <li>
            <%# DataBinder.Eval(Container.DataItem,"xuhao")%>
        </li>
        </ItemTemplate>
        </asp:DataList>&nbsp;

 

调用datalist里的数据

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

 

 

  <asp:Repeater ID="Repeater1" runat="server" >
             
                    <ItemTemplate>
                  <%#Eval("xuhao") %>
                    </ItemTemplate>
                </asp:Repeater>

 

调用reperter里的数据

 

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

 

repeater显示成行的形式

datalist 显示成列的形式