前台部分代码:
<asp:GridView ID="grvPerson" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BorderWidth="0px" CellPadding="0" CellSpacing="1"
EmptyDataText="暂无信息!" PageSize="16" Width="100%" OnDataBinding="grvPerson_DataBinding">
<PagerSettings Visible="False" />
<EmptyDataRowStyle ForeColor="Red" />
<Columns>
<asp:TemplateField HeaderText="姓名">
<ItemTemplate>
<%#Eval("BY_Person_Name") %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>后台:
private void mybind()
{
string BY_Company_ID = Request.QueryString["BY_Company_ID"];//获取公司编号
Front_Company front=new Front_Company();
Front_Jobs job = new Front_Jobs();
DataTable dt_front= front.select_1(Convert.ToInt32(BY_Company_ID));//查询公司
DataTable dt_job= job.select_1(0, Convert.ToInt32(BY_Company_ID));//查询发布的职位
//公司绑定
PagedDataSource pds_Company = new PagedDataSource();
pds_Company.DataSource = dt_front.DefaultView;
dlCompany.DataSource = pds_Company;
dlCompany.DataBind();
//招聘职位绑定
PagedDataSource pds_Position = new PagedDataSource();
pds_Position.DataSource = dt_job.DefaultView;
dlPosition.DataSource = pds_Position;
dlPosition.DataBind();
} protected void dlPosition_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//取出ITEM数据
DataRowView drv = (DataRowView)e.Item.DataItem;
GridView grv_Person = (GridView)e.Item.FindControl("grvPerson"); string BY_Company_ID = Request.QueryString["BY_Company_ID"];//获取公司编号
Front_Jobs job = new Front_Jobs();
DataTable dt_job = job.select_1(0, Convert.ToInt32(BY_Company_ID));//查询发布的职位 for (int i = 0; i < dt_job.Rows.Count; i++)
{
//获取职位名称
string BY_Position_Name = dt_job.Rows[i]["BY_Jobs_Name"].ToString(); Front_Person person = new Front_Person();
//查询有该职位名称的相关人员
DataTable dt_person = person.Person_SearchToNewsPerson("0", "", BY_Position_Name, "1055", "", 0, 0, 2, 8, 0); for (int j = 0; j < dt_person.Rows.Count; j++)
{
grv_Person.DataBound += new EventHandler(grvPerson_DataBinding);
grv_Person.DataSource = dt_person;
grv_Person.DataBind();
}
}
}
}
}
现在的结果是:
****公司 职位: 业务
人才: 张三,李四,王五
职位: 会计
人才: 张三,李四,王五
这个地方的人才都出现重复了,根本就和数据库里面的不一样,
想请教一下问题所在?
<asp:GridView ID="grvPerson" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BorderWidth="0px" CellPadding="0" CellSpacing="1"
EmptyDataText="暂无信息!" PageSize="16" Width="100%" OnDataBinding="grvPerson_DataBinding">
<PagerSettings Visible="False" />
<EmptyDataRowStyle ForeColor="Red" />
<Columns>
<asp:TemplateField HeaderText="姓名">
<ItemTemplate>
<%#Eval("BY_Person_Name") %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>后台:
private void mybind()
{
string BY_Company_ID = Request.QueryString["BY_Company_ID"];//获取公司编号
Front_Company front=new Front_Company();
Front_Jobs job = new Front_Jobs();
DataTable dt_front= front.select_1(Convert.ToInt32(BY_Company_ID));//查询公司
DataTable dt_job= job.select_1(0, Convert.ToInt32(BY_Company_ID));//查询发布的职位
//公司绑定
PagedDataSource pds_Company = new PagedDataSource();
pds_Company.DataSource = dt_front.DefaultView;
dlCompany.DataSource = pds_Company;
dlCompany.DataBind();
//招聘职位绑定
PagedDataSource pds_Position = new PagedDataSource();
pds_Position.DataSource = dt_job.DefaultView;
dlPosition.DataSource = pds_Position;
dlPosition.DataBind();
} protected void dlPosition_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//取出ITEM数据
DataRowView drv = (DataRowView)e.Item.DataItem;
GridView grv_Person = (GridView)e.Item.FindControl("grvPerson"); string BY_Company_ID = Request.QueryString["BY_Company_ID"];//获取公司编号
Front_Jobs job = new Front_Jobs();
DataTable dt_job = job.select_1(0, Convert.ToInt32(BY_Company_ID));//查询发布的职位 for (int i = 0; i < dt_job.Rows.Count; i++)
{
//获取职位名称
string BY_Position_Name = dt_job.Rows[i]["BY_Jobs_Name"].ToString(); Front_Person person = new Front_Person();
//查询有该职位名称的相关人员
DataTable dt_person = person.Person_SearchToNewsPerson("0", "", BY_Position_Name, "1055", "", 0, 0, 2, 8, 0); for (int j = 0; j < dt_person.Rows.Count; j++)
{
grv_Person.DataBound += new EventHandler(grvPerson_DataBinding);
grv_Person.DataSource = dt_person;
grv_Person.DataBind();
}
}
}
}
}
现在的结果是:
****公司 职位: 业务
人才: 张三,李四,王五
职位: 会计
人才: 张三,李四,王五
这个地方的人才都出现重复了,根本就和数据库里面的不一样,
想请教一下问题所在?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货