前台:select.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="select.aspx.cs" Inherits="select" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvStudent" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:TemplateField HeaderText="编号">
<ItemTemplate>
<%# Eval("sid") %>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="sname" HeaderText="姓名" />
<asp:BoundField DataField="gender" HeaderText="性别" />
<asp:BoundField DataField="age" HeaderText="年龄" />
<asp:TemplateField HeaderText="年龄">
<ItemTemplate>
<%# Transfer(int.Parse(Eval("age").ToString()))%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="姓名">
<ItemTemplate>
<%# Transfer(Eval("sname").ToString())%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
后台:select.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BLL;
public partial class select : System.Web.UI.Page
{
private Student stu = new Student();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BinGrid();
}
}
private void BinGrid()
{
gvStudent.DataSource = stu.Student_Select();
gvStudent.DataBind();
}
public string Transfer(int age)
{
string ages = "";
if (age<10)
{
ages = "True";
}
else if (age>=10)
{
ages = "False";
}
return ages;
}
public int Transfer(string sname)
{
int ages = 0;
switch (sname)
{
case "tt":
ages = 1;
break;
case "bb":
ages = 2;
break;
case "d":
ages = 3;
break;
case "丁露丹":
ages = 4;
break;
}
return ages;
}
}
注意:当数据库中的数据是数字时,在前台显示为字符串应怎么写;当数据库中的数据是汉字时,在前台显示为字符串应怎么写;