protected void btnSelect_Click1(object sender, EventArgs e)
{
string search = txtKeyWord.Text.Trim();
string sqlstr = "select * from ModuleInfo_View where CardName like @title order by CardDate desc";
CardInfo.DataSource = sqlBind.Search(sqlstr, search);
CardInfo.DataBind();
}
protected void gvModuleInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
if (txtKeyWord.Text.Trim() == "")
{
CardInfo.PageIndex = e.NewPageIndex;
string sqlstr = "select * from ModuleInfo_View order by CardDate desc";
sqlBind.gvBind(CardInfo, sqlstr);
}
else
{
CardInfo.PageIndex = e.NewPageIndex;
string search = txtKeyWord.Text.Trim();
string sqlstr = "select * from ModuleInfo_View where CardName like @title order by CardDate desc";
CardInfo.DataSource = sqlBind.Search(sqlstr, search);
CardInfo.DataBind();
}
}
