WebForm数据绑定

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;

/// 

/// Users 的摘要说明
/// 
public class Users
{
    public Users()
    {

    }
    public int Ids { get; set; }
    public string Ucode { get; set; }
    public string UserName { get; set; }
    public string password { get; set; }
    public string NickName { get; set; }
    public bool Sex { get; set; }
    public string Sexstr
    {
        get
        {
            return Sex ? "男" : "女";
        }
    }
    public DateTime Birthday { get; set; }
    public string Nation { get; set; }
    public string NationName
    {
        get
        {
            string s = "无";
            SqlConnection conn = new SqlConnection("server=.;database=Date0504;user=sa;pwd=y920106k");
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select * from UserNation where NationCode=@a";
            cmd.Parameters.Add("@a",Nation);
            conn.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                s = dr["NationName"].ToString();
            }
            conn.Close();
            return s;
        }

    }

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;

/// 

/// UsersData 的摘要说明
/// 
public class UsersData
{
    SqlConnection conn;
    SqlCommand cmd;
    public UsersData()
    {
        conn = new SqlConnection("server=.;database=Date0504;user=sa;pwd=y920106k");
        cmd = conn.CreateCommand();
    }
    public ListSelectAll()
    {
        List ulist = new List();
        cmd.CommandText = "select * from Users";
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            Users u = new Users();
            u.Ids = Convert.ToInt32(dr["Ids"]);
            u.Ucode = dr["Ucode"].ToString();
            u.UserName = dr["UserName"].ToString();
            u.password = dr["PassWord"].ToString();
            u.NickName = dr["NickName"].ToString();
            u.Sex = Convert.ToBoolean(dr["Sex"]);
            u.Birthday = Convert.ToDateTime(dr["Birthday"]);
            u.Nation = dr["Nation"].ToString();
            ulist.Add(u);
        }
        conn.Close();
        return ulist;
    }
}

"C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>



"http://www.w3.org/1999/xhtml">"server">
    "Content-Type" content="text/html; charset=utf-8" />
    

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)
    {
        Repeater1.DataSource = new UsersData().SelectAll();//指定数据源
        Repeater1.DataBind();//绑定数据源
    }
}