62,266
社区成员
发帖
与我相关
我的任务
分享
CustID = int.Parse(HCustID.Value);
PageDataBind();
public void PageDataBind()
{
string Sql;
//核心SQL语句,进行查询运算
Sql = "Select Top " + AspNetPager1.PageSize + " FCustID 客户内码,isnull(FCustNo,'') as 客户编号,isnull(FCustName,'') as 客户名称,FParentID from T_Customer where ( FRecordType=0 and FParentID=" + CustID.ToString() + " and FCustID not in(select top " + Convert.ToString(AspNetPager1.StartRecordIndex - 1) + " FCustID from T_Customer where FRecordType=0 and FParentID="+CustID.ToString() + " order by FCustNo )) order by FCustNo ";
DataTable dt = DBHelper.GetDataSet(Sql);
GridView1.DataSource = dt;
GridView1.DataBind();
}