62,046
社区成员
发帖
与我相关
我的任务
分享
DataTable dtNew = dt.Clone();
StringBuilder strWhere = new StringBuilder();
DataRow[] drs;
if (txtKeyWord.Value.Trim().Length > 0)
{
drs =
dt.Select(String.Format(" value like '%{0}%'", Common.PageValidate.SqlFilterString(txtKeyWord.Value)));
foreach (DataRow dr in drs)
{
strWhere.Append(" '" + dr[0].ToString() + "' like key+'%' or");
}
if (strWhere.ToString().Length > 0)
{
strWhere = strWhere.Remove(strWhere.ToString().Length - 2, 2);
}
else
{
rstMsg.InnerText = "查无相关内容!";
}
}
drs = dt.Select(strWhere.ToString().Length > 0 ? strWhere.ToString() : "1=1");
if (drs.Length > 0)
{
foreach (DataRow dr in drs)
{
DataRow drnew =dtNew.NewRow();
int paddingCount = 0;
//父级加空格以显示出层级关系
drnew[0] = dr[0].ToString();
paddingCount = ((dr[0].ToString().Trim().Length - 3) / 2) * 10;
drnew[1] = "style='padding-left:" + paddingCount.ToString() + "px;'," + dr[1].ToString();
dtNew.Rows.Add(drnew);
}
}
rptList.DataSource = dtNew;
rptList.DataBind();