private void Bindata()
{
DataSet ds = new DataSet();
SqlDataAdapter dap = ttopicmanager.PTopicListGet();
dap.Fill(ds);
DataTable dt = ds.Tables[0];
//绑定分页控件
if (dt.Rows.Count > 0)
{
this.MyPaper1.RecordCount = dt.Rows.Count;
}
else
{
this.MyPaper1.RecordCount = 0;
}
dap.Fill(ds, MyPaper1.DataSet_StartIndex, MyPaper1.PageSize, "TOR");
this.GVTopicList.DataSource = ds.Tables["TOR"];
this.GVTopicList.DataBind();
//数据绑定后过滤每一行即可
for (int i = 0; i <= GVTopicList.Rows.Count - 1; i++)
{
DataRowView mydrv;
string gIntro;
if (GVTopicList.PageIndex == 0)
{
mydrv = ds.Tables[0].DefaultView[i];
gIntro = Convert.ToString(mydrv["TopicName"]);
GVTopicList.Rows[i].Cells[1].Text = SubStr(gIntro, 5).ToString();
}
else
{
mydrv = ds.Tables[0].DefaultView[i + (5 * GVTopicList.PageIndex)];
gIntro = Convert.ToString(mydrv["TopicName"]);
GVTopicList.Rows[i].Cells[1].Text = SubStr(gIntro, 5).ToString();
}
}
}
private object SubStr(string sString, int nLeng)
{
if (sString.Length <= nLeng)
{
return sString;
}
string sNewStr = sString.Substring(0, nLeng);
sNewStr = sNewStr + "...";
return sNewStr;
}