如何做asp.net网页信息与数据库绑定

Question

想在网页上显示数据库中的信息
repeater,DataList
举个例子
小弟谢过了！！

Answer 1

    <asp:Repeater ID="rep" runat="server">
    <HeaderTemplate>
    <table>
    <tr>
        <td>ID</td>
        <td>球员名称</td>
        <td>俱乐部ID</td>
    </tr>
    </HeaderTemplate>
    
    <ItemTemplate>
    <tr>
        <td><%#Eval("PlayerID")%></td>
        <td><%#Eval("PlayerName") %></td>
        <td><%#Eval("ClubID") %></td>
    </tr>
    </ItemTemplate>
    
    <FooterTemplate>
    </table>
    </FooterTemplate>
    </asp:Repeater>

Answer 2

 System.Data.SqlClient.SqlConnection objSqlConnection = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["FootballManager"].ToString());
            string strSelect = "SELECT * FROM Player";
            objSqlConnection.Open();
            System.Data.SqlClient.SqlCommand objSqlCommand = new System.Data.SqlClient.SqlCommand(strSelect, objSqlConnection);
            System.Data.SqlClient.SqlDataAdapter objSqlDataAdapter = new System.Data.SqlClient.SqlDataAdapter();
            DataSet objDataSet = new DataSet();
            objSqlDataAdapter.SelectCommand = objSqlCommand;
            objSqlDataAdapter.Fill(objDataSet);
            this.rep.DataSource = objDataSet;
            this.rep.DataBind();
            objSqlConnection.Close();

Answer 3

<ASP:DataGrid id="MyDataGrid" runat="server"
BorderColor="Black"
BorderWidth="1px"
CellPadding="3"
Font-Size="12px"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee" DataSourceID="SqlDataSource1" Font-Names="Verdana" Width="406px" AutoGenerateColumns="False" AllowCustomPaging="True"> 
        <Columns>
        <asp:TemplateColumn HeaderText="序号">
        <ItemTemplate>
        <%#Eval("id") %>
        </ItemTemplate>
        </asp:TemplateColumn>
        <asp:TemplateColumn HeaderText="姓名">
        <ItemTemplate>
        <%#Eval("name") %>
        </ItemTemplate>
        </asp:TemplateColumn>
         <asp:TemplateColumn HeaderText="性别">
        <ItemTemplate>
        <%#Eval("sec") %>
        </ItemTemplate>
        </asp:TemplateColumn>
         <asp:TemplateColumn HeaderText="修改">
        <ItemTemplate>
        <!--<%#Eval("sec") %>-->
        <a href="update.aspx?id=<%#Eval("id") %>" target="_blank">修改</a>
        </ItemTemplate>
        </asp:TemplateColumn>
         <asp:TemplateColumn HeaderText="删除">
        <ItemTemplate>
        <!--<%#Eval("sec") %>-->
        <a href="del.aspx?id=<%#Eval("id") %>" target="_blank">删除</a>
        </ItemTemplate>
        </asp:TemplateColumn>
        </Columns>
            <AlternatingItemStyle BackColor="#EEEEEE" />
            <HeaderStyle BackColor="#AAAADD" />
</asp:DataGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:netConnectionString %>"
            SelectCommand="SELECT * FROM [study_xuesheng] ORDER BY [id] DESC">
        </asp:SqlDataSource>