Select case Sex when 0 then '女' else '男' End as Sex,其它字段 from 表名 还要查询其他字段,怎么加上查询其他字段?
SELECT CASE i WHEN 0 THEN '女' WHEN 1 THEN '男' END AS 性别, ....... from .....
SELECT CASE i WHEN 0 THEN '女' WHEN 1 THEN '男' END AS 性别,年龄,职位,其他字段 from .....
"SELECT case bet when 201 then '女' else '男' End as bet , sum(betn) as 1号 FROM [bet] WHERE (([bet].[BetItem] = 1))"IErrorInfo.GetDescription 因 E_FAIL(0x80004005) 而失败。
select (case 性别字段 when 1 then '男' else '女') from 性别表
更正: select (case qq when 1 then '男' else '女'end) from table1 100%准確﹐快給分
在SQL里更好判断: select 性别 =case when sex=1 then '男' else '女' end from tablename
如果SQL太复杂,那就考虑放在前台处理吧!
in html: Text ='<%# ((int)DataBinder.Eval(Container.DataItem,"Agenda")==0)?"女":"男" %>' ============================================================ 这个好
Text ='<%# ((int)DataBinder.Eval(Container.DataItem,"Agenda")==0)?"女":"男" %>' 这个方法最好
唉,CSDN有搜索功能,能不能搜一下,已经有很多人问过了!浪费
SELECT case bet when 201 then '女' else '男' End as bet , sum(betn) as 1号 FROM [bet] WHERE (([bet].[BetItem] = 1)) group by bet聚合函数的SELECT命令如果出现非聚合输出要group by
Private Sub dgcheckbox_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dgcheckbox.ItemDataBound If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then Dim isman As String = CType(DataBinder.Eval(e.Item.DataItem, "psex"), String) Dim wyears As String = CType(DataBinder.Eval(e.Item.DataItem, "worktime"), String) If isman = "0" Then e.Item.Cells(2).Text = "男" Else e.Item.Cells(2).Text = "女" End If End If end sub
方法很多,但是还是这个最简单:in html: Text ='<%# ((int)DataBinder.Eval(Container.DataItem,"Agenda")==0)?"女":"男" %>'
Text ='<%# ((int)DataBinder.Eval(Container.DataItem,"Agenda")==0)?"女":"男" %>'
public void string strsex(string str)
{
if(str == 1)
return str = "男";
if(str == 0)
return str = "女";
}
然后在页面绑定的时候就写
'<%# strsex(DataBinder.Eval(Container.DataItem,"字段名").ToString()) %>'
private void grid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
//用颜色表示Bug状态
if( e.Item.Cells[2].Text == Constants.BUG_STATUS_ACTIVE )
{
System.Web.UI.WebControls.Image image = (System.Web.UI.WebControls.Image)e.Item.FindControl("imageStatus");
image.ImageUrl = "../Images/red.gif";
image.ToolTip = "Active";
}
else if( e.Item.Cells[2].Text == Constants.BUG_STATUS_RESOLVED )
{
System.Web.UI.WebControls.Image image = (System.Web.UI.WebControls.Image)e.Item.FindControl("imageStatus");
image.ImageUrl = "../Images/yellow.gif";
image.ToolTip = "Resolved";
}
else if( e.Item.Cells[2].Text == Constants.BUG_STATUS_CLOSED )
{
System.Web.UI.WebControls.Image image = (System.Web.UI.WebControls.Image)e.Item.FindControl("imageStatus");
image.ImageUrl = "../Images/green.gif";
image.ToolTip = "Closed";
}
}
还要查询其他字段,怎么加上查询其他字段?
CASE i
WHEN 0 THEN '女'
WHEN 1 THEN '男'
END AS 性别, .......
from .....
CASE i
WHEN 0 THEN '女'
WHEN 1 THEN '男'
END AS 性别,年龄,职位,其他字段
from .....
你把你的数据库结构贴出来,把你的要求也贴出来,这里高人很多,应该可以帮你搞定.
更正:
select (case qq when 1 then '男' else '女'end) from table1
100%准確﹐快給分
select 性别 =case when sex=1 then '男' else '女' end from tablename
Text ='<%# ((int)DataBinder.Eval(Container.DataItem,"Agenda")==0)?"女":"男" %>'
============================================================
这个好
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string sex=Convert.ToString(DataBinder.Eval(e.Item.DataItem, "sex"));
if (sex == "1")
{
e.Item.Cells[3].Text="男";
}
else
{
e.Item.Cells[3].Text= "女";
}
} }
这个方法最好
<ItemTemplate>
<asp:Label id="lbStatus" runat="server">
<%# turnToflag(DataBinder.Eval(Container.DataItem,"性别").ToString())%>
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
public string turnToflag(string Flag)
{
switch(Flag)
{
case "0":
return "<font color=red>男</font>";
case "1":
return "<font color=blue>女</font>";
default:
return "<font color=red>状态错误</font>";
}
}
private void ChengedStatus()
{
foreach (DataGridItem item in dgrdQuery.Items) //dgrdQuery,你的datagrid名字
{
if(item.Cells[1].Text.ToString().Trim()=="0") //注意你是第几列
{item.Cells[1].Text="女";}
if(item.Cells[1].Text.ToString().Trim()=="1")
{item.Cells[1].Text="男";}
}
}
private void grdTopics_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemIndex >= 0)
{
String hint;
hint=e.Item.Cells[7].Text; //获取列内容
if (hint==1){
e.Item.Cells[7].Text='男';
}
else{
e.Item.Cells[7].Text='女';
}
}
}
再把数据库里那个字段写成布尔型的不就可以了。
If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
Dim isman As String = CType(DataBinder.Eval(e.Item.DataItem, "psex"), String)
Dim wyears As String = CType(DataBinder.Eval(e.Item.DataItem, "worktime"), String)
If isman = "0" Then
e.Item.Cells(2).Text = "男"
Else
e.Item.Cells(2).Text = "女"
End If
End If
end sub
Text ='<%# ((int)DataBinder.Eval(Container.DataItem,"Agenda")==0)?"女":"男" %>'