`
netxdiy
  • 浏览: 673381 次
  • 性别: Icon_minigender_1
  • 来自: 上海
社区版块
存档分类
最新评论

DataGrid应用技巧两则(downmoon)---列求和与列字段转换d

 
阅读更多

DataGrid应用技巧两则(downmoon)
一:增加求和列:

private void dgMeets_ItemDataBound( object sender,System.Web.UI.WebControls.DataGridItemEventArgse)
... {

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.Item)
... {
// 某列总和
intTotalNew = 0 ;
int i;
DataTablemyTable;
myTable
= (DataTable)((DataSet) this .dgMeets.DataSource).Tables[ 0 ];
for (i = 0 ;i < myTable.Rows.Count;i ++ )
... {
intTotalNew
+= int .Parse(myTable.Rows[i][ " attendnum " ].ToString());
}

}

else if (e.Item.ItemType == ListItemType.Footer)
... {
e.Item.Cells[
6 ].Text = " 总计: " + intTotalNew.ToString() + " " ;
e.Item.Cells[
6 ].Attributes.Add( " Align " , " Right " );
}

}

二:列字段转换:
方法1:

< asp:TemplateColumn HeaderText ="是否可见" >
< HeaderStyle HorizontalAlign ="Center" Width ="10%" ></ HeaderStyle >
< ItemStyle HorizontalAlign ="Center" ></ ItemStyle >
< ItemTemplate >
< asp:Label runat ="server" ID ="lb" Text ='<%# ((DataBinder.Eval(Container,"DataItem.Conf_show","{0}")) =="0")?"是":"<font color =red > </ font > "%>'>'> </ asp:Label >
</ ItemTemplate >
</ asp:TemplateColumn >

方法2:
后台------------

public string ConvertToBool( string k)
... {
string s = (k == " 0 " ) ? " " : " <fontcolor=red>否</font> " ;
return s;

}



前台:

< asp:TemplateColumn HeaderText ="是否可见" >
< HeaderStyle HorizontalAlign ="Center" Width ="10%" ></ HeaderStyle >
< ItemStyle HorizontalAlign ="Center" ></ ItemStyle >
< ItemTemplate >
< asp:Label runat ="server" ID ="lb" Text ='<%# ConvertToBool(DataBinder.Eval(Container,"DataItem.Conf_show","{0}"))% > '>'> </ asp:Label >
</ ItemTemplate >
</ asp:TemplateColumn >

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics