62,046
社区成员
发帖
与我相关
我的任务
分享
Select 字段名1,(case [字段名2(取值为1,2,3的那个字段)] when 1 then '故障' when 2 then '维修' else '正常' end) as state from tablename
或者你在gridview 的RowDataBound事件中 用
switch (value)
{
case "0":
e.Row.Cells[6].Text= "正常";
break;
case "1":
e.Row.Cells[6].Text= "故障";
break;
case "2":
e.Row.Cells[6].Text= "维修";
break;
}
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:TemplateField HeaderText="yourField">
<ItemTemplate>
<%# ShowResult(Eval("yourField").ToString()) %>'
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
protected string ShowResult(string value)
{
string result = string.Empty;
switch (value)
{
case "0":
result = "正常";
break;
case "1":
result = "故障";
break;
case "2":
result = "维修";
break;
}
return result;
}