Simoneasp GridView 搜索分页
的有关信息介绍如下：
asp GridView 搜索分页
user.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="user.aspx.cs" Inherits="government_web.user.user" %>
user.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using government_web.db;
namespace government_web.user
{
public partial class user : System.Web.UI.Page
{
public SqlServerDB sqlServerDB = null;
protected void Page_Load(object sender, EventArgs e)
{
}
///
/// 删除操作
///
///
///
protected void GridView_user_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
}
///
/// 搜索
///
///
///
protected void user_search_Click(object sender, EventArgs e)
{
bind();
}
///
/// 点击分页
///
///
///
protected void GridView_user_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
bind();
}
public void bind() {
//查询字符串
string sql = "select * from [users] where [username] like '%" + TextBox_username.Text + "%' "
+ " and [email] like '%" + TextBox_email.Text + "%' and [name] like '%" + TextBox_name.Text + "%'"
+ " and [phone] like '%" + TextBox_phone.Text + "%'";
//设置SqlDataSource 执行sql语句
SqlDataSource_user.SelectCommand = sql;
//设置GridView中DataSourceID
GridView_user.DataSourceID = SqlDataSource_user.ID;
//绑定GridView数据
GridView_user.DataBind();
}
}
}
注意在分页的时候也要从新绑定数据，不然点击分页就会查询所有数据
数据库
