<asp:DataList ID="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 { public partial class WebForm4 : System.Web.UI.Page { private string connstr = "data source=.;database=master;uid=sa;pwd=sadamu"; protected void Page_Load(object sender, EventArgs e) { BindData(); } private void BindData() { string sqlstr = "select * from province"; DataTable dt = GetDataTable(sqlstr); DataList1.DataSource = dt; DataList1.DataBind();
} private DataTable 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; } } } |