protected void gvOrderInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvOrderInfo.PageIndex = e.NewPageIndex;
string sqlstr = "select distinct OrderMember from tb_OrderInfo where "
+ ddlCondition.SelectedValue + " like '%" + txtKey.Text.Trim() + "%'";
sqloperate.gvDataBind(gvOrderInfo, sqlstr);
}
}
{
gvOrderInfo.PageIndex = e.NewPageIndex;
string sqlstr = "select distinct OrderMember from tb_OrderInfo where "
+ ddlCondition.SelectedValue + " like '%" + txtKey.Text.Trim() + "%'";
sqloperate.gvDataBind(gvOrderInfo, sqlstr);
}
}
//下面开始拼sql语句
string sqlstr = "select distinct OrderMember from tb_OrderInfo where "
+ ddlCondition.SelectedValue + " like '%" + txtKey.Text.Trim() + "%'";
//绑定,显示新页码的内容
sqloperate.gvDataBind(gvOrderInfo, sqlstr);
distinct,去掉重复的记录
from,表示从什么数据源取得数据
where,条件,根据where表达式,筛选出符合条件的记录
like,根据通配符比较,比如 like '%abc%',那么aabc abcd abcde 123abc123都是匹配的,123,abac, 123ab,都是不匹配的。
gvOrderInfo.PageIndex = e.NewPageIndex;//为gridview设置此次转到的页码
//根据DropDownList中的选项来排序查询相关数据
string sqlstr = "select distinct OrderMember from tb_OrderInfo where "
+ ddlCondition.SelectedValue + " like '%" + txtKey.Text.Trim() + "%'";
//重新绑定,显示鼠标选定的页码的内容
sqloperate.gvDataBind(gvOrderInfo, sqlstr);