110,538
社区成员
发帖
与我相关
我的任务
分享
protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemIndex >= 0)
{
//e.Item.Cells[4].Text = e.Item.Cells[4].Text.Trim() == "1" ? "是" : "否";
if (e.Item.Cells[3].Text.Trim() == "1")
e.Item.Cells[3].Text = "男";
else if (e.Item.Cells[3].Text.Trim() == "0")
e.Item.Cells[3].Text = "女";
}
}
<asp:TemplateColumn HeaderText="性别">
<ItemTemplate>
<asp:Label runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Sex").ToString()=="1"?"男":"女" %>' ID="Label1">
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
/// <summary>
/// 查询列表
/// </summary>
private void Query()
{
Hashtable queryItems = new Hashtable();
DataTable dt = Myweb.BusinessLogicLayer.Worker.Query(queryItems);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
}
/// <summary>
/// 根据查询条件哈希表,查询数据
/// </summary>
/// <param name="queryItems">查询条件哈希表</param>
/// <returns>查询结果数据DataTable</returns>
public static DataTable Query(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "select * from View_worker where WorkerDept=1";
Database db = new Database();
return db.GetDataTable(sql);
}
SELECT
列1,
列2,
CASE sex
WHEN '1' THEN '男'
WHEN '0' THEN '女'
END AS sex
from 表
/// <summary>
/// 得到用户的选择
/// </summary>
/// <returns>用户选择图书的编号集合</returns>
private ArrayList GetSelected()
{
ArrayList selectedItems = new ArrayList();
foreach (DataGridRow row in DataGrid1.Rows)
{
if (((CheckBox)row.FindControl("chkSelected")).Checked)
{
selectedItems.Add(Convert.ToInt32(row.Cells[1].Text));
}
}
return selectedItems;
}