最简单就是:
<script runat="server" >
string TransformName( string numberStr ){
string newNameStr = null; if( numberStr == "01" ){
newNameStr = "中国";
}
return newNameStr;
}
</script>Page Html:
<asp:DataGrid runat="server" id="DataGrid1" >
<Columns>
<asp:TemplateColumn >
<ItemTemplate>
<%# TransformName( DataBinder.Eval( Container.DataItem,"columnName") )%>
</ItemTemplate>
</asp:TemplateColumn >
</Columns>
</asp:DataGrid>
<script runat="server" >
string TransformName( string numberStr ){
string newNameStr = null; if( numberStr == "01" ){
newNameStr = "中国";
}
return newNameStr;
}
</script>Page Html:
<asp:DataGrid runat="server" id="DataGrid1" >
<Columns>
<asp:TemplateColumn >
<ItemTemplate>
<%# TransformName( DataBinder.Eval( Container.DataItem,"columnName") )%>
</ItemTemplate>
</asp:TemplateColumn >
</Columns>
</asp:DataGrid>
sql 好是好,但你想过可移植吗?
而且现在XML 用做数据存储越来越多了呀!
如何联接,给点代码,谢谢
用数据适配器,很简单的就得到SQL语句
1.在数据源里,
str_sql = " SELECT CASE WHEN flag='01' THEN '中国' ELSE 'XX' END AS temps FROM mytable ";
2.在datagrid的ItemDataBound事件里处理
if ( ( e.Item.ItemType != ListItemType.Header ) && ( e.Item.ItemType != ListItemType.Footer ) )
{
string sel_spzt = e.Item.Cells[0].Text ;//datagrid的0列
if ( sel_spzt == "0" )
e.Item.Cells[0].Text = "中国";
else
e.Item.Cells[0].Text = "XX";
}