格式化DataGrid的例子【将数据源中的0,1值转换成实际的文字】 (转)[@more@]
<Contacts>
<Contact>
<E href="tag-285-1.html">Mail</a>>myaddress@mycompany.comemail</a>>
<FirstName>E章</FirstName>
<LastName>孟子</LastName>
<Manager>0</Manager>
</Contact>
<Contact>
<Email>youraddress@yourcompany.com</Email>
<FirstName>宪会</FirstName>
<LastName>孟</LastName>
<Manager>1</Manager>
</Contact>
<Contact>
<Email>mm@mmm.mm</Email>
<FirstName>Lover</FirstName>
<LastName>Net</LastName>
<Manager>0</Manager>
</Contact>
<Contact>
<Email>xxx@xxxx.xx</Email>
<FirstName>NET开发者园地</FirstName>
<LastName>
<Manager>0</Manager>
</Contact>
<Contact>
<Email>hhh@hhh.hh</Email>
<FirstName>XML开发者园地</FirstName>
<LastName>
<Manager>1</Manager>
</Contact>
</Contacts>
<a href="leibie-11-1.html">web</a></a>.FormatDataGridVB" %>
w3c</a>//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<meta name="GENERATOR" content="a href="tag-126-1.html""">microsoft</a> <a href="tag-39-1.html">Visual Studio</a> 7.0">
<meta name="CODE_LANGUAGE" content="a href="tag-29-1.html"""><a href="leibie-3-1.html">C#</a></a>">
<meta name="vs_defaultClientScript" content="a href="tag-133-1.html"""><a href="tag-10-1.html"><a href="leibie-1-1.html">Java</a></a>script</a>">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/a href="tag-340-1.html""">intel</a>lisense/<a href="tag-393-1.html">IE5</a>">
</HEAD>
<body>
<fo href="tag-415-1.html">RM </a>id="i<a href="tag-57-1.html">db</a>Sample" method="post" runat="server" class="SubHeading">
<asp id="MyTitle" runat="server" font-bold="True"></asp>
<br />
<br />
<asp id="FormatDataGrid" runat="server" autogeneratecolumns="False" width="100%">
<HeaderStyle font-bold="True"></HeaderStyle>
<Columns>
<asp>
<ItemTemplate>
<asp>'
runat="server" ID="Label1">
</asp>
</ItemTemplate>
</asp>
<asp datafield="Email" readonly="True"></asp>
<asp datafield="Manager" readonly="True">
<HeaderStyle horizontalalign="Center"></HeaderStyle>
<ItemStyle horizontalalign="Center"></ItemStyle>
</asp>
</Columns>
</asp>
</form>
</body>
</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
#Region " Web 窗体设计器生成的代码 "
'该<a href="tag-152-1.html">调用</a>是 Web 窗体设计器所必需的。
<System href="tag-268-1.html">bug</a>gerStepThrough()> Private Sub InitializeComponent()
End Sub
Private Sub Page_Init(ByVal sender As System.<a href="tag-252-1.html">object</a>, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub
#End Region
Private _d<a href="tag-302-1.html">SCO</a>ntacts 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 = "电子<a href="tag-377-1.html">邮件</a>"
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.Data<a href="tag-162-1.html">source</a> = 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 If
End Sub
End Class
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
{
#region Web Form Designer generated code
overr<a href="tag-351-1.html">ide</a> protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the <a href="tag-46-1.html">ASP.net</a> Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dgContacts.ItemDataBound +=
new System.Web.UI.WebControls.DataGridItemEventHandler(this.dgContacts_ItemDataBound);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
protected System.Web.UI.WebControls.DataGrid FormatDataGrid;
private DataSet _dsContacts;
private void Page_Load(object sender, System.EventArgs e)
{
// 装载XML数据原，注意：这里与数据原类型没有关系，换成数据库也是适用的
_dsContacts = new DataSet();
_dsContacts.ReadXml(Server.MapPath("Contacts.xml"));
DataColumn[] dcPk = {_dsContacts.Tables["Contact"].Columns["Email"]};
_dsContacts.Tables["Contact"].PrimaryKey = dcPk;
if (!Page.IsPostBack )
{
BindContacts();
}
}
private void BindContacts()
{
DataView dv = new DataView(_dsContacts.Tables["Contact"]);
dv.Sort = "LastName, FirstName";
dgContacts.DataSource = dv;
dgContacts.DataBind();
}
protected string FormatFullName(object FirstName, object LastName)
{
// 格式划名称列
return (string)LastName + ", " + (string)FirstName;
}
protected void FormatDataGrid_ItemDataBound(object source,
System.Web.UI.WebControls.DataGridItemEventArgs e)
{
// 确保处理的是数据行，而不是Header或者Footer
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
// 得到Manager字段的值
string isManager = (string)DataBinder.Eval(e.Item.DataItem, "Manager");
if (isManager == "1")
{
// ' 设定文字和背景颜色
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 = "普通员工";
}
}
}
}
格式化DataGrid的例子【将数据原中的0,1值转换成实际的文字】
do.NETplayground.com/">http://lucky_elove.www1.dotnetplayground.com/
下面的代码实现格式化DataGrid的列，也即是将数据原中的0,1值转换成实际的文字的功能，主要是在数据绑定的帮定事件。
ASPx">查看例子
首先准备数据源，数据源采用数据库、XML、数组等都可以。下面以XML做例子。Contacts.xml文件如下：
FormatDataGridVB.aspx
FormatDataGridVB.aspx.vb
C#版本
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10752019/viewspace-958424/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
