这样写sql,怎么显示错误。 源代码如下: string sql, sql1; sql = "Select EventDateTime,MessageId,FileName,(case Status when '1' then 'Message Unknown' when '2' then 'Message Queued' when '3' then 'Delivered to Gateway' when '4' then 'Received by Recipient' when '5' then 'Error with Message' end) as Status From SentMessagesLog"; sql1 = "Select EventDateTime,Description,Severity From EventsLog"; MSA.OleDbDataAdapter odb = new MSA.OleDbDataAdapter(sql, dbConn); DataSet ds = new DataSet(); odb.Fill(ds); drvSentMessage.DataSource = ds.Tables[0];
取出来后对比一下1 或者2
对应输出 男 女
你试试看
choose(dataset1.table(0).rows(i).column("性别").value,"男","女")
select name,(case age then'1' when '男' then'2' when '女' end) as age from table
写个方法
public string ShowSex(Object obj)
{
string sex=obj.toString();
return sex=="1"?"男":"女";
}绑定时调用<%# ShowSex(Eval("sex"))%> (sex为数据库表中的性别字段名)
这样写sql,怎么显示错误。
源代码如下:
string sql, sql1;
sql = "Select EventDateTime,MessageId,FileName,(case Status when '1' then 'Message Unknown' when '2' then 'Message Queued' when '3' then 'Delivered to Gateway' when '4' then 'Received by Recipient' when '5' then 'Error with Message' end) as Status From SentMessagesLog";
sql1 = "Select EventDateTime,Description,Severity From EventsLog"; MSA.OleDbDataAdapter odb = new MSA.OleDbDataAdapter(sql, dbConn);
DataSet ds = new DataSet();
odb.Fill(ds);
drvSentMessage.DataSource = ds.Tables[0];
在GridView中<asp:TemplateField HeaderText="性别">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Eval("B_Sex") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# (bool)Eval("B_Sex")?"男":"女" %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>