using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Main : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["uid"] != null)//如果数据库有数据跳转到主界面
        {
            if (!IsPostBack)//判断是否刷新
            {
InfoDataContext context = new InfoDataContext();
                //指定数据源
                Repeater1.DataSource = context.Info;
                Repeater1.DataBind();
            }
        }
        else//如果没有数据 发回到等录界面
        {
            Response.Redirect("denglu.aspx");
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //按照代号和姓名查询
        //取所有数据
        InfoDataContext context = new InfoDataContext();
       List<Info> list= context.Info.ToList();
        //取第一个查询条件
    string code=txtCode.Text;
        if( code!="")
        {
            list=list.Where(p=>p.Code==code).ToList();
            }
            //取第二个查询条件
            string name=txtName.Text;
        if( name!="")
        {
            list = list.Where(p => p.Name.Contains(name)).ToList();
        }
        //给repeater做数据源
        Repeater1.DataSource = list;
        Repeater1.DataBind();
    }
    //造显示性别函数
    public string ShowSex()
    {
        return Convert.ToBoolean(Eval("Sex"))?"男":"女";
    }
    //造显示民族的函数
    public string ShowNation()
{
   
    InfoDataContext context = new InfoDataContext();
string code= Eval("Nation").ToString();
  
          return  context.Nation.Where(p=>p.Code==code).First().Name;
}
    //造显示生日的函数
    public string ShowBirthday()
    {
        return Convert.ToDateTime(Eval("Birthday")).ToString("yyyy年MM月dd日");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("Insert.aspx");
    }
    protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
    }
}
 
 <h1 > 主界面</h1>
      
            <asp:Label ID="Label1" runat="server" Text="代号:"></asp:Label>
 <asp:TextBox ID="txtCode" runat="server"></asp:TextBox>
            <asp:Label ID="Label2" runat="server" Text="姓名:"></asp:Label>
 
            <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
     
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="查询" />
  
            <asp:Button ID="Button2" runat="server" Text="添加 " OnClick="Button2_Click" />
           
      
            <asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
                <HeaderTemplate>
                    <table width="800" border="0" cellspacing="1" cellpadding="1" bgcolor="#6600FF">
                  <tr>
                    <td width="120" height="30" align="center" valign="middle" bgcolor="#FFFFFF">代号</td>
                    <td width="120" align="center" valign="middle" bgcolor="#FFFFFF"> 姓名</td>
                    <td width="120" align="center" valign="middle" bgcolor="#FFFFFF">性别</td>
                    <td width="120" align="center" valign="middle" bgcolor="#FFFFFF"> 名族</td>
                    <td width="100" align="center" valign="middle" bgcolor="#FFFFFF">生日</td>
                    <td width="100" align="center" valign="middle" bgcolor="#FFFFFF">操作</td>
                  </tr>
                </HeaderTemplate>
                <ItemTemplate>
 <tr bgcolor="#FFFFFF">
                    <td width="120" height="30" align="center" valign="middle"><%#Eval("Code") %></td>
                    <td width="120" align="center" valign="middle" ><%#Eval("Name") %></td>
                    <td width="120" align="center" valign="middle" ><%#  ShowSex()%></td>
                    <td width="120" align="center" valign="middle" ><%#ShowNation() %></td>
                    <td class="kc" width="100" align="center" valign="middle" ><%#ShowBirthday() %></td>
                    <td width="100" align="center" valign="middle" ><a href="Delete.aspx?code=<%#Eval("Code") %>">删除</a> <a href="Update.aspx?code=<%#Eval("Code") %>">修改</a></td>
                </tr>
                </ItemTemplate>
                <FooterTemplate></table></FooterTemplate>
            </asp:Repeater>
 </p>
原文:http://www.cnblogs.com/cf924823/p/5065712.html