格式化DataGrid的例子【将数据原中的0,1值转换成实际的文字】

来源：互联网发布：南京航空航天大学知乎编辑：程序博客网时间：2024/06/06 02:07

下面的代码实现格式化DataGrid的列，也即是将数据原中的0,1值转换成实际的文字的功能，主要是在数据绑定的帮定事件。

查看例子

首先准备数据源，数据源采用数据库、XML、数组等都可以。下面以XML做例子。Contacts.xml文件如下：

<?xml version="1.0" encoding="gb2312" standalone="yes"?>

<Email>myaddress@mycompany.com</Email>

</Contact>

<Email>youraddress@yourcompany.com</Email>

</Contact>

<FirstName>Lover</FirstName>

</Contact>

<FirstName>NET开发者园地</FirstName>

</Contact>

<FirstName>XML开发者园地</FirstName>

</Contact>

</Contacts>

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="FormatDataGridVB.aspx.vb"

Inherits="aspxWeb.FormatDataGridVB" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

</HEAD>

<asp:Label ID="MyTitle" runat="server" Font-Bold="True"></asp:Label>

<br>

<asp:DataGrid id="FormatDataGrid" runat="server" AutoGenerateColumns="False" Width="100%">

<asp:TemplateColumn>

<asp:Label

Text='<%# FormatFullName(DataBinder.Eval(Container, "DataItem.FirstName"),_

DataBinder.Eval(Container, "DataItem.LastName")) %>'

runat="server" ID="Label1">

</asp:Label>

</ItemTemplate>

</asp:TemplateColumn>

<asp:BoundColumn DataField="Email" ReadOnly="True"></asp:BoundColumn>

<asp:BoundColumn DataField="Manager" ReadOnly="True">

</asp:BoundColumn>

</Columns>

</asp:DataGrid>

</form>

</HTML>

Imports System

Imports System.Data

Imports System.Web.UI

Imports System.Web.UI.WebControls

Imports System.Xml

Public Class FormatDataGridVB

Inherits System.Web.UI.Page

Protected WithEvents FormatDataGrid As System.Web.UI.WebControls.DataGrid

Protected WithEvents MyTitle As System.Web.UI.WebControls.Label

Web 窗体设计器生成的代码

Private _dsContacts As DataSet

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

MyTitle.Text = "格式化DataGrid的例子【将数据原中的0,1值转换成实际的文字】"

FormatDataGrid.Columns(0).HeaderText = "姓名"

FormatDataGrid.Columns(1).HeaderText = "电子邮件"

FormatDataGrid.Columns(2).HeaderText = "职位"

' 装载XML数据原，注意：这里与数据原类型没有关系，换成数据库也是适用的

_dsContacts = New DataSet()

_dsContacts.ReadXml(Server.MapPath("Contacts.xml"))

Dim dcPk As DataColumn() = {_dsContacts.Tables("Contact").Columns("Email")}

_dsContacts.Tables("Contact").PrimaryKey = dcPk

If Not Page.IsPostBack Then

' 只在页面首次请求时才进行数据绑定

BindContacts()

End If

End Sub

Private Sub BindContacts()

Dim dv As DataView = New DataView(_dsContacts.Tables("Contact"))

dv.Sort = "LastName, FirstName"

FormatDataGrid.DataSource = dv

FormatDataGrid.DataBind()

End Sub

Protected Function FormatFullName(ByVal FirstName As Object, ByVal LastName As Object) As String

' 格式划名称列

Return CType(LastName, String) & "." & CType(FirstName, String)

End Function

Private Sub FormatDataGrid_ItemDataBound(ByVal sender As Object,_

ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles FormatDataGrid.ItemDataBound

' 确保处理的是数据行，而不是Header或者Footer

If e.Item.ItemType = ListItemType.Item OrElse e.Item.ItemType = ListItemType.AlternatingItem Then

' 得到Manager字段的值

Dim isManager As String = CType(DataBinder.Eval(e.Item.DataItem, "Manager"), String)

If isManager = "1" Then

' 设定文字和背景颜色

e.Item.Cells(2).Text = "经理"

e.Item.Cells(2).Style.Add("font-weight", "bold")

e.Item.Cells(2).ForeColor = System.Drawing.Color.Red

e.Item.BackColor = System.Drawing.Color.AliceBlue

Else

e.Item.Cells(2).Text = "普通员工"

End If

End Sub

End Class

C#版本

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

/// <summary>

/// Summary description for idbSample.

/// </summary>

public class idbSample : System.Web.UI.Page

{

Web Form Designer generated code