using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;

public partial class _Default : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {
            fillGridView();
        }

    } 
    //填充GridView
    protected void fillGridView()
    {
        DataSet ds = new DataSet();

        ds = GetData();
        GridView1.DataSource = ds;
        GridView1.DataBind();
        getRefSet(ds);

    }
    //分页
    protected void getRefSet(DataSet ds)
    {
        lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";
        lblPageCount.Text = "共 " + GridView1.PageCount.ToString() + " 页";
        lblRecordCount.Text = "总共 " + ds.Tables[0].Rows.Count.ToString() + " 条";

        if (ds.Tables[0].Rows.Count == 0)
        {
            lnkbtnFirst.Visible = false;
            lnkbtnPre.Visible = false;
            lnkbtnNext.Visible = false;
            lnkbtnLast.Visible = false;

            lblCurrentIndex.Visible = false;
            lblPageCount.Visible = false;
            lblRecordCount.Visible = false;
        }
        else if (GridView1.PageCount == 1)
        {
            lnkbtnFirst.Visible = false;
            lnkbtnPre.Visible = false;
            lnkbtnNext.Visible = false;
            lnkbtnLast.Visible = false;
        }
        lnkbtnFirst.CommandArgument = "1";
        lnkbtnPre.CommandArgument = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());
        lnkbtnNext.CommandArgument = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());
        lnkbtnLast.CommandArgument = GridView1.PageCount.ToString();
    }
    //第几页
    protected void lnkbtnJumpPage_Click(object sender, EventArgs e)
    {
        GridView1.PageIndex = int.Parse(txtJumpPage.Text) - 1;
        lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";
        fillGridView();
        GridView1.DataBind();

    }
    protected void PagerButtonClick(object sender, EventArgs e)
    {
        GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandArgument) - 1;
        fillGridView();
        GridView1.DataBind();

    }  
    // 转换SQL查询结果为DataSet
    private DataSet GetData()
    {

        OracleConnection conn = new OracleConnection("Data Source=wgyx;user=wgyx;password=wgyx;");
        OracleCommand cmd = new OracleCommand();
        cmd.Connection = conn;
        String strSql = "select id,fuid,the from sys_organ";
        cmd.CommandText = strSql;
        cmd.CommandType = CommandType.Text;
        DataSet ds = new DataSet();
        try
        {
            conn.Open();
            OracleDataAdapter ad = new OracleDataAdapter();
            ad.SelectCommand = cmd;
            ad.Fill(ds);

        }
        catch (Exception ex)
        {
            Response.Write("数据库错误，错误原因：" + ex.Message);
            Response.End();
        }
        finally
        {
            conn.Close();
        }
        return ds;
    }
}

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" >
            <AlternatingRowStyle BackColor="LightSteelBlue" />
            <PagerSetti