protected void gvCardInfo_PageIndexChanging(object sender, GridViewPageEventArgs e) { if (search.Text.Trim() == "") { gvCardInfo.PageIndex = e.NewPageIndex; string sqlstr = "select * from ModuleInfo_View order by CardDate desc"; sqlBind.gvBind(gvCardInfo, sqlstr); } else { gvCardInfo.PageIndex = e.NewPageIndex; string searchstr = search.Text.Trim(); string sqlstr = "select * from ModuleInfo_View where CardName like @title order by CardDate desc"; gvCardInfo.DataSource = sqlBind.Search(sqlstr, searchstr); gvCardInfo.DataBind(); } }
protected void gvModuleInfo_PageIndexChanging(object sender, GridViewPageEventArgs e) { string idStr = Page.Request.QueryString["ModuleName"]; if (txtKeyWord.Text.Trim() == "") { gvModuleInfo.PageIndex = e.NewPageIndex; string sqlstr = "select * from ModuleInfo_View where ModuleName='" + idStr + "' and CardName like '%" + txtKeyWord.Text + "%'order by CardDate desc"; sqlBind.gvBind(gvModuleInfo, sqlstr); } else { gvModuleInfo.PageIndex = e.NewPageIndex; string search = txtKeyWord.Text.Trim(); string sqlstr = "select * from ModuleInfo_View where ModuleName='" + idStr + "' and CardName like @title order by CardDate desc"; gvModuleInfo.DataSource = sqlBind.Search(sqlstr, search); gvModuleInfo.DataBind(); } }