Data Binding-DataAdapter

Hi i'm a new to ASP.NET and for some reason when i click the Next button in the code below, the pageIndex does not change. Please assist, Basically what i'm trying to do is to use DataAdapter.fill but passing in the start index and the number of records to pull from the dataset table.

using System;

using System.Data;

using System.Configuration;

using System.Collections;

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.OleDb;

public partial class Home : System.Web.UI.Page

{

//ConnectionOleDbConnection dbConn;

//discount that can be change by user using a gui interface

//CurrentPageint pageIndex = 0;double discount = 0.15 ;

 protected void Page_Load(object sender, EventArgs e)

{

// homeGridView.Visible = true;

 

BindList();

 

 

}protected string getSpecial(string price,object sale)

{String special = "";if (sale.ToString().CompareTo("True") == 0)

{special = String.Format("{0:C}",double.Parse(price) * (1-discount));

}return special;

}

protected void BindList()

{

//Creating an object for the 'PagedDataSource' for holding the data.

 

//PagedDataSource objPage = new PagedDataSource();

try

{

//open connection

openConnection();

//sql commandstring columns = "*";

string SqlCommand = "Select " + columns + " from Books";

//create adapters and DataSetOleDbDataAdapter myAdapter = new OleDbDataAdapter(SqlCommand, dbConn);DataSet ds = new DataSet("bSet");

 

//create tableDataTable dt = new DataTable("Books");myAdapter.Fill(ds, pageIndex, 9, "Books");

 

Response.Write("Page Index: "+pageIndex);

//create table data viewDataView dv = new DataView(ds.Tables["bTable"]);

booksDataList.DataSource = ds;

booksDataList.DataBind();

 

myAdapter.Dispose();

dbConn.Close();

}catch (Exception ex)

{

 Response.Write("Exception thrown in BindList()");

dbConn.Close();throw ex;

}

 

}

 

 public void openConnection()

{string provider="Microsoft.Jet.OLEDB.4.0";

string dataSource = "C:/Documents and Settings/Owner/My Documents/Visual Studio 2005/WebSites/E-BookOnline/App_Data/BooksDB.mdb";dbConn = new OleDbConnection("Provider =" + provider + ";" + "Data Source =" + dataSource);

dbConn.Open();

}protected void nextClick(object sender, EventArgs e)

{

pageIndex=pageIndex+1;Response.Write("In nextClick"+pageIndex);

BindList();

}protected void prevClick(object sender, EventArgs e)

{if (pageIndex > 0)

{

pageIndex=pageIndex-1;

BindList();

}

}

}