动态修改DataGrid中列的呈现

最新推荐文章于 2024-07-12 16:55:56 发布

weixin_34166847

最新推荐文章于 2024-07-12 16:55:56 发布

阅读量140

点赞数

文章标签：人工智能 c# ui

原文链接：http://www.cnblogs.com/netboy/archive/2005/05/09/151724.html

版权

修改DataGrid显示列的呈现大体有四种方法,下面以"经典"的性别显示为例介绍这几种方法.

1>绑定的时候修改列的呈现之前台实现.

CodeBehind:
==================================================================
/// <summary>
/// Fetch data from db.
/// </summary>
  private void GetData()
  {
   SqlConnection cnn=new SqlConnection("data source=localhost;initial catalog=pfizer;integrated

security=sspi");
SqlCommand cmd=new SqlCommand("select seqid,employeename, malefemale from pub_employee where

seqid>10",cnn);
   SqlDataAdapter adapter=new SqlDataAdapter(cmd);
   DataSet dst=new DataSet();
   try
   {
    adapter.Fill(dst);
    DataGrid1.DataSource=dst.Tables[0].DefaultView;
    DataGrid1.DataBind();
   }
   catch (Exception ex)
   {
    Response.Write(ex.ToString());
   }
  }

aspx:
==========================================================================
<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="sharptest.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
  <title>WebForm1</title>
  <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
  <meta name="CODE_LANGUAGE" Content="C#">
  <meta name="vs_defaultClientScript" content="JavaScript">
  <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
  <form id="Form1" method="post" runat="server">
   <asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 24px; POSITION: absolute; TOP: 24px"

runat="server"
    Width="272px" AutoGenerateColumns=False ShowHeader=True>
    <Columns>
    <asp:BoundColumn DataField="seqid" HeaderText="编号"></asp:BoundColumn>
    <asp:BoundColumn DataField="employeename" HeaderText="姓名"></asp:BoundColumn>
    <asp:TemplateColumn HeaderText="性别">
    <ItemTemplate>
    <%#DataBinder.Eval(Container.DataItem,"malefemale").ToString()=="F"?"男":"女"%>
    </ItemTemplate>
    </asp:TemplateColumn>
    </Columns>
    </asp:DataGrid>
  </form>
</body>
</HTML>

这里用到是c系列的三目运算符 == ? :,如果你用vb.net可以用 IIf(testexpression,truepart,falsepart) 实现 .

2>绑定的时候修改列的呈现之自定义函数实现

CodeBehind:
==================================================================

后台代码和1>相同

aspx:
==================================================================
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 24px; POSITION: absolute; TOP: 24px" runat="server"
    Width="272px" AutoGenerateColumns=False ShowHeader=True>
    <Columns>
    <asp:BoundColumn DataField="seqid" HeaderText="编号"></asp:BoundColumn>
    <asp:BoundColumn DataField="employeename" HeaderText="姓名"></asp:BoundColumn>
    <asp:TemplateColumn HeaderText="性别">
    <ItemTemplate>
    <%#ShowSex(DataBinder.Eval(Container.DataItem,"malefemale"))%>
    </ItemTemplate>
    </asp:TemplateColumn>
    </Columns>
    </asp:DataGrid>

3>绑定的时候修改列的呈现ItemDataBound事件实现
CodeBehind:
==================================================================
绑定函数同1>相同,加上下面的处理过程.
  private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {

if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.EditItem)
   {
    if(DataBinder.Eval(e.Item.DataItem,"malefemale").ToString()=="F")
     e.Item.Cells[2].Text="男";
    else
     e.Item.Cells[2].Text="女";
   }

}

aspx:
==================================================================
<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 24px; POSITION: absolute; TOP: 24px" runat="server"
    Width="272px" AutoGenerateColumns="False" ShowHeader="True">
    <Columns>
     <asp:BoundColumn DataField="seqid" HeaderText="编号"></asp:BoundColumn>
     <asp:BoundColumn DataField="employeename" HeaderText="姓名"></asp:BoundColumn>
     <asp:TemplateColumn HeaderText="性别">
      <ItemTemplate>
       <%#DataBinder.Eval(Container.DataItem,"malefemale")%>
      </ItemTemplate>
     </asp:TemplateColumn>
    </Columns>
   </asp:DataGrid>

4>在sql语句中修改列的呈现

CodeBehind:
==================================================================
private void GetData()
  {
   SqlConnection cnn=new SqlConnection("data source=localhost;initial catalog=pfizer;integrated

security=sspi");
SqlCommand cmd=new SqlCommand("select seqid,employeename, case malefemale when 'F' then '男' else '女

' end as malefemale from pub_employee where seqid>10",cnn);
   SqlDataAdapter adapter=new SqlDataAdapter(cmd);
   DataSet dst=new DataSet();
   try
   {
    adapter.Fill(dst);
    DataGrid1.DataSource=dst.Tables[0].DefaultView;
    DataGrid1.DataBind();
   }
   catch (Exception ex)
   {
    Response.Write(ex.ToString());
   }
  }

主要是用了sql里的case语句.

aspx:
==================================================================
同 3>.

结束语:
一样每种方法都有各自的优势.方法二看起来比较垃圾,但是如果你要里面实现比较复杂的逻辑它会排上用场,绝对比其他的用起来要爽的多.
方法三你可以随意扩展不只是显示,可以更改北京,可以实现内嵌下来列表默认选择的实现等.

对于这几种方法完全适用于"字符串太长用省略号显示"之类的问题,大家可以自由发挥!

转载于:https://www.cnblogs.com/netboy/archive/2005/05/09/151724.html

weixin_34166847

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
动态修改DataGrid中列的呈现

修改DataGrid显示列的呈现大体有四种方法,下面以"经典"的性别显示为例介绍这几种方法. 1>绑定的时候修改列的呈现之前台实现. CodeBehind: ================================================================== /// <summary> /// Fetch data from db. ...
复制链接

扫一扫