using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.SqlClient;/// 
/// DataConnection 的摘要说明/// 
public class DataConnection{    private static string connstr = "server=.; database=mydb; user=sa; pwd=ray; ";    public static SqlConnection Conn    {        get { return new SqlConnection (connstr);}    }}

//UsersDatausing System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.SqlClient;/// 
/// UsersData 的摘要说明/// 
public class UsersData{    private SqlConnection _conn;    private SqlCommand _cmd;    private SqlDataReader _dr;    public UsersData()    {        _conn = DataConnection.Conn;        _cmd = _conn.CreateCommand();    }    /// 
    /// 查询Users表全部数据    /// 
    /// 
          public List
      
        SelectAll()    {        List
       
         list = new List
        
         ();        _cmd.CommandText = "select *from Users";        _conn.Open();        _dr = _cmd.ExecuteReader();        if (_dr.HasRows)        {            while (_dr.Read())            {                                           Users data = new Users();                data.Username = _dr["username"].ToString();                data.Password = _dr["password"].ToString();                data.Gender = Convert.ToBoolean(_dr["gender"]);                data.Nickname = _dr["nickname"].ToString();                data.Nation = _dr["nation"].ToString();                data.Area = _dr["area"].ToString();                data.Birthday = Convert.ToDateTime(_dr["birthday"]);                list.Add(data);            }        }        _conn.Close();        return list;    }}//NationDatausing System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.SqlClient;/// 
         
/// NationData 的摘要说明/// 
public class NationData{    private SqlConnection _conn;    private SqlCommand _cmd;    private SqlDataReader _dr;    public NationData()    {        _conn = DataConnection.Conn;        _cmd = _conn.CreateCommand();    }    /// 
         
    /// 根据编号查询名族名称    /// 
    /// 
             /// 
             public string SelectName(string ncode)    {        string name = "";        _cmd.CommandText = "select Name from Nation where Code=@code";        _cmd.Parameters.Clear();        _cmd.Parameters.Add("@code",ncode);        _conn.Open();        _dr = _cmd.ExecuteReader();        if (_dr.HasRows)        {            _dr.Read();            name = _dr[0].ToString();        }        _conn.Close();        return name;    }}
        
       
      

//Usersusing System;using System.Collections.Generic;using System.Linq;using System.Web;/// 
/// Users 的摘要说明/// 
public class Users{    public Users()    {        //        // TODO: 在此处添加构造函数逻辑        //    }    private string _username;    public string Username    {        get { return _username; }        set { _username = value; }    }    private string _password;    public string Password    {        get { return _password; }        set { _password = value; }    }    private string _nickname;    public string Nickname    {        get { return _nickname; }        set { _nickname = value; }    }    private bool _gender;    public bool Gender    {        get { return _gender; }        set { _gender = value; }    }    private DateTime _birthday;    public DateTime Birthday    {        get { return _birthday; }        set { _birthday = value; }    }    private string _nation;    public string Nation    {        get { return _nation; }        set { _nation = value; }    }    private string _area;    public string Area    {        get { return _area; }        set { _area = value; }    }    //属性扩展    public string GenderName    {        get { return Gender ? "男" : "女"; }    }    public string BirthdayStr    {        get { return Birthday.ToString("yyyy年MM月dd日"); }    }    public string NationName    {        get { return new NationData().SelectName(Nation); }    }    public int Age    {        get { return Convert.ToInt32(DateTime.Now.Year) - Convert.ToInt32(Birthday.ToString("yyyy")); }    }    //红色警告    public string Red    {        get        {            string end = "";            if (GenderName == "女")            {                end = "color:Red; font-weight:bold; font-style:initial; font-family:华文行楷;";            }            return end;        }    }}//Nationusing System;using System.Collections.Generic;using System.Linq;using System.Web;/// 
/// Nation 的摘要说明/// 
public class Nation{    public Nation()    {        //        // TODO: 在此处添加构造函数逻辑        //    }    private string _nationcode;    public string Nationcode    {        get { return _nationcode; }        set { _nationcode = value; }    }    private string _nationname;    public string Nationname    {        get { return _nationname; }        set { _nationname = value; }    }}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
                  
      
        
                   
                        
                         
         
                         
         
                         
         
         
            "> 
                        <%--
            "> 
            --%>            
                              
           
             
用户名
             
密码
             
昵称
             
性别
             
生日
             
年龄
             
地区
             
民族
            
                                   
            
<%#Eval("Username") %>
             
<%#Eval("Password") %>
             
<%#Eval("Nickname") %>
             
<%#Eval("GenderName") %>
             
<%#Eval("BirthdayStr") %>
             
<%#Eval("Age")+"岁" %>
             
<%#Eval("Area") %>
             
<%#Eval("NationName") %>
            
           
            
<%#Eval("Username") %>
             
<%#Eval("Password") %>
             
<%#Eval("Nickname") %>
             
<%#Eval("GenderName") %>
             
<%#Eval("BirthdayStr") %>
             
<%#Eval("Age") %>
             
<%#Eval("Area") %>
             
<%#Eval("NationName") %>
            
          
         
                    
        
           
      

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;public partial class _Default : System.Web.UI.Page{    protected void Page_Load(object sender, EventArgs e)    {        if (!IsPostBack)        {            List
      
        list = new UsersData().SelectAll();            Repeater1.DataSource = list;            Repeater1.DataBind();        }    }}
      

 

运行页面：