Asp.NET中DataList 用法

<asp:DataListID="DataList1" runat="server">

    <ItemTemplate>

        <%#Eval("pname")%>

    </ItemTemplate>

 </asp:DataList>

 

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

 

namespace WebApplication1

{

    publicpartial class WebForm4 : System.Web.UI.Page

    {

        privatestring connstr = "data source=.;database=master;uid=sa;pwd=sadamu";

        protectedvoid Page_Load(object sender,EventArgs e)

        {

            BindData();

        }

        privatevoid BindData()

        {

            string sqlstr = "select * from province";

            DataTable dt = GetDataTable(sqlstr);

            DataList1.DataSource = dt;

            DataList1.DataBind();

           

        }

        privateDataTable GetDataTable(string sqlstr)

        {

            SqlConnection conn = new SqlConnection(connstr);

            conn.Open();

            SqlCommand cmd = new SqlCommand(sqlstr, conn);

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            DataTable dt = new DataTable();

            da.Fill(dt);

            return dt;

        }

    }

}