关于查询和 翻页

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using System.Data.SqlClient;
namespace Chaxun_stu
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        string strSQL;
        SqlConnection conn;
        DataSet ds;
        SqlDataAdapter da;
        private void Form1_Load(object sender, EventArgs e)
        {
            strSQL = "select * from stuInfo";//执行　SQL 读出stuInfo 中的数据
            conn = DB.CreateConn();//引用ＤＢ中的连接语句
            da = new SqlDataAdapter(strSQL, conn);

            ds = new DataSet();
            da.Fill(ds, "stuInfo");
            this.dataGridView1.DataSource = ds.Tables["stuInfo"].DefaultView;

            this.txtSno.DataBindings.Add("Text", ds, "stuInfo.Sno");
            this.txtSname.DataBindings.Add("Text", ds, "stuInfo.Sname");
            this.txtSage.DataBindings.Add("Text", ds, "stuInfo.Sage");

            this.EnableButtons();
           

        }
        private void btnSearch_Click(object sender, EventArgs e)
        {
            ds.Tables["stuInfo"].DefaultView.RowFilter = "sno='" + this.txtSno.Text + "'";
//            ds.Tables["stuInfo"].DefaultView.RowFilter = "sname= '" + this.txtSname.Text + "'";
        }

        private void btnSearchAll_Click(object sender, EventArgs e)
        {
            DataView dv = new DataView(ds.Tables[0]);
            this.dataGridView1.DataSource = dv;

        }

        private void btn_Click(object sender, EventArgs e)
        {
            if (sender == this.btnFirst)
            {
                this.BindingContext[ds, "stuInfo"].Position = 0;
            }
            else if (sender == this.btnPreviouse)
            {
                this.BindingContext[ds, "stuInfo"].Position--;
            }
            else if (sender == this.btnNext)
            {
                this.BindingContext[ds, "stuInfo"].Position++;
            }
            else if (sender == this.btnLast)
            {
                this.BindingContext[ds, "stuInfo"].Position = ds.Tables[0].Rows.Count - 1;
            }

            this.EnableButtons();
        }
        private void EnableButtons()//设置按钮是否可用
        {
            this.btnLast.Enabled = false;
            this.btnNext.Enabled = false;
            this.btnPreviouse.Enabled = false;
            this.btnFirst.Enabled = false;

            if (this.BindingContext[ds, "stuInfo"].Position > 0)
            {
                this.btnFirst.Enabled = true;
                this.btnPreviouse.Enabled = true;
            }
            if (this.BindingContext[ds, "stuInfo"].Position < ds.Tables[0].Rows.Count - 1)
            {
                this.btnLast.Enabled = true;
                this.btnNext.Enabled = true;
            }
        }

       }
}