SQL 语句: public ArrayList GetDptArrayList()
{
ArrayList list = new ArrayList(); string sql = @"select x.dpt_id,x.dpt_name,x.emp_id,count(emp.emp_id) [count] from (
select d.dpt_id,d.dpt_name,e.emp_id from department d left join employee e on e.dpt_id = d.dpt_id and e.rol_id =3
) x left join employee emp on x.dpt_id = emp.dpt_id
group by x.dpt_id,x.dpt_name,x.emp_id"; System.Data.DataTable dt = DBHelper.GetDataSet(sql); foreach (DataRow row in dt.Rows)
{
ArrayList dpt = new ArrayList(); dpt.Add(row["dpt_id"].ToString());
dpt.Add(row["dpt_name"].ToString());
dpt.Add(row["emp_id"].ToString());
dpt.Add(row["count"].ToString());
list.Add(dpt);
}
return list;
}
页面代码:
<asp:DataList id="dlDepartment" runat="server" CellPadding="4" ForeColor="#333333" HorizontalAlign="Center" Width="90%">
<HeaderTemplate>
<ul><li>部门编号</li><li>部门名称</li><li>部门人数</li><li>部门经理</li></ul>
</HeaderTemplate>
<ItemTemplate>
<ul>
<li><asp:Label ID="dpt_IDLabel" runat="server" Text='<%# Eval("dpt[0]") %>'></asp:Label></li>
<li><asp:Label ID="dpt_nameLabel" runat="server" Text='' ></asp:Label></li>
<li><asp:Label ID="countLabel" runat="server" Text='' ></asp:Label></li>
<li><asp:Label ID="emp_IDLabel" runat="server"Text='' ></asp:Label></li>
</ul>
</ItemTemplate>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#EFF3FB" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
</asp:DataList>请问 如何将GetDptArrayList() 的数据 绑定到DataList上去.
{
ArrayList list = new ArrayList(); string sql = @"select x.dpt_id,x.dpt_name,x.emp_id,count(emp.emp_id) [count] from (
select d.dpt_id,d.dpt_name,e.emp_id from department d left join employee e on e.dpt_id = d.dpt_id and e.rol_id =3
) x left join employee emp on x.dpt_id = emp.dpt_id
group by x.dpt_id,x.dpt_name,x.emp_id"; System.Data.DataTable dt = DBHelper.GetDataSet(sql); foreach (DataRow row in dt.Rows)
{
ArrayList dpt = new ArrayList(); dpt.Add(row["dpt_id"].ToString());
dpt.Add(row["dpt_name"].ToString());
dpt.Add(row["emp_id"].ToString());
dpt.Add(row["count"].ToString());
list.Add(dpt);
}
return list;
}
页面代码:
<asp:DataList id="dlDepartment" runat="server" CellPadding="4" ForeColor="#333333" HorizontalAlign="Center" Width="90%">
<HeaderTemplate>
<ul><li>部门编号</li><li>部门名称</li><li>部门人数</li><li>部门经理</li></ul>
</HeaderTemplate>
<ItemTemplate>
<ul>
<li><asp:Label ID="dpt_IDLabel" runat="server" Text='<%# Eval("dpt[0]") %>'></asp:Label></li>
<li><asp:Label ID="dpt_nameLabel" runat="server" Text='' ></asp:Label></li>
<li><asp:Label ID="countLabel" runat="server" Text='' ></asp:Label></li>
<li><asp:Label ID="emp_IDLabel" runat="server"Text='' ></asp:Label></li>
</ul>
</ItemTemplate>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<AlternatingItemStyle BackColor="White" />
<ItemStyle BackColor="#EFF3FB" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
</asp:DataList>请问 如何将GetDptArrayList() 的数据 绑定到DataList上去.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货