Paging in Datagrid

[Troy]

Hello
Having some issues with the Paging functionality of the
datagrid.
When on my development machine (server/client in one),
the paging works correctly. However, when I deploy to the
production IIS machine, the paging works correctly once
then does not proceed to the next page. (That is, it will
toggle between page 1 and 2 only). What's the problem?

Thanks for your help.
Troy

The code:
private void Page_Load(objec t sender, System.EventArg s e)
{

bindData();
#region Web Form Designer generated code
override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form
Designer.
//
InitializeCompo nent();
base.OnInit(e);
}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeCompo nent()
{
this.Button1.Cl ick += new System.EventHan dler
(this.Button1_C lick);
this.dgResults. PageIndexChange d += new
System.Web.UI.W ebControls.Data GridPageChanged EventHandler
(this.dgResults _PageIndexChang ed);
this.Load += new System.EventHan dler(this.Page_ Load);

}#endregion
private void bindData()
{

SqlConnection cn = new SqlConnection(" Initial
Catalog=Test;Da ta Source=Test;UID =uid;PWD=pwd");

cn.Open();

sSQL = "select col1, col2 from table";
// *** Load resultset ***
DataSet ds1 = new DataSet();
SqlDataAdapter daINV = new SqlDataAdapter( sSQL, cn);
daINV.Fill(ds1, "dt");

if (ds1.Tables["dt"].Rows.Count > 0)
{

dgResults.DataS ource = ds1;

dgResults.DataB ind();
dgResults.Visib le=true;
}

// *** close connection ***
cn.Close();
}

private void dgResults_PageI ndexChanged(obj ect source,
System.Web.UI.W ebControls.Data GridPageChanged EventArgs e)
{
dgResults.Curre ntPageIndex = e.NewPageIndex;
bindData();
}