0.把对象的属性绑定到datalist中,首先建一个实体类,利用泛型,产生实体对象数组,把实体对象数组赋给datalist.DataSource,再把属性绑定到相应的控件
<%
# Eval("User_name")
%>
1.default.aspx代码
2.default.aspx.cs代码
3.类库--放到App_Code中的test.cs中
4.
1.default.aspx代码
<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default"
%>
<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd" >
< html xmlns ="http://www.w3.org/1999/xhtml" >
< head runat ="server" >
< title > Untitled Page </ title >
</ head >
< body >
< form id ="form1" runat ="server" >
< asp:ScriptManager ID ="ScriptManager1" runat ="server" />
< div >
< asp:DataList ID ="DataList1" runat ="server" >
< ItemTemplate >< asp:Label runat ="server" > <% # Eval("User_name") %> </ asp:Label ></ ItemTemplate >
</ asp:DataList ></ div >
</ form >
</ body >
</ html >
<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd" >
< html xmlns ="http://www.w3.org/1999/xhtml" >
< head runat ="server" >
< title > Untitled Page </ title >
</ head >
< body >
< form id ="form1" runat ="server" >
< asp:ScriptManager ID ="ScriptManager1" runat ="server" />
< div >
< asp:DataList ID ="DataList1" runat ="server" >
< ItemTemplate >< asp:Label runat ="server" > <% # Eval("User_name") %> </ asp:Label ></ ItemTemplate >
</ asp:DataList ></ div >
</ form >
</ body >
</ html >
2.default.aspx.cs代码
using
System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using test;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
testuser testu1 = new testuser();
testu1.ReturnUserName(DataList1);
}
}
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using test;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
testuser testu1 = new testuser();
testu1.ReturnUserName(DataList1);
}
}
3.类库--放到App_Code中的test.cs中
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Data.SqlClient;
/// <summary>
/// test 的摘要描述
/// </summary>
///
namespace test
{
public class user
{ public user(string username)
{
User_name = username;
}
private string user_id;
public string User_id
{
get { return user_id; }
set { user_id = value; }
}
private string user_name;
public string User_name
{
get { return user_name; }
set { user_name = value; }
}
}
public class testuser
{
public void ReturnUserName(DataList datalist)
{
IList<user> users = new List<user>();
SqlConnection con = new SqlConnection("server=.;database=bbs;uid=sa;pwd=omanlaolao");
//根据具体数据库修改
con.Open();
SqlCommand cmd = new SqlCommand("select User_name from Users",con);
//根据具体的表修改
SqlDataReader sdr=cmd.ExecuteReader();
while(sdr.Read())
{
users.Add(new user(sdr[0].ToString()));
}
datalist.DataSource=users;
datalist.DataBind();
}
}
}
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Collections.Generic;
using System.Data.SqlClient;
/// <summary>
/// test 的摘要描述
/// </summary>
///
namespace test
{
public class user
{ public user(string username)
{
User_name = username;
}
private string user_id;
public string User_id
{
get { return user_id; }
set { user_id = value; }
}
private string user_name;
public string User_name
{
get { return user_name; }
set { user_name = value; }
}
}
public class testuser
{
public void ReturnUserName(DataList datalist)
{
IList<user> users = new List<user>();
SqlConnection con = new SqlConnection("server=.;database=bbs;uid=sa;pwd=omanlaolao");
//根据具体数据库修改
con.Open();
SqlCommand cmd = new SqlCommand("select User_name from Users",con);
//根据具体的表修改
SqlDataReader sdr=cmd.ExecuteReader();
while(sdr.Read())
{
users.Add(new user(sdr[0].ToString()));
}
datalist.DataSource=users;
datalist.DataBind();
}
}
}
4.