Hi Spacy,

I have solved 1st problem, as stated in my previous post.
Now, the only problem is, I can't view the 2nd page onwards.

My last post is a solution for your problem with 2nd page onwards.

This:
        DataGrid1.CurrentPageIndex = e.NewPageIndex
        DataGrid1.DataBind()

wont work as you have not specified what to bind to the datagrid.
Thats the reason for the blank page.
Store the ddlView1.SelectedValue in a global variable.

Private Sub DataGrid1_PageIndexChanged(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEvent Args) Handles DataGrid1.PageIndexChanged
        Try
            DataGrid1.CurrentPageIndex = e.NewPageIndex
             Dim Str As String
        Str = "Select * From Library where CategoryID = " & globalVar
        SqlDataAdapter1.SelectCommand.CommandText = Str
        SqlDataAdapter1.Fill(DsLibrary1)
        DataGrid1.DataSource = DsLibrary1
        DataGrid1.DataMember = "Library"
        DataGrid1.DataBind()

        Catch ex As Exception
            Dim a As String
            a = ex.Message
        End Try

    End Sub

Hope this helps.

Cheers..
Spacy...

Or else you can put the connection code in a procedure:

Private Sub BindGrid()
         Dim Str As String
        Str = "Select * From Library where CategoryID = " & ddlView1.SelectedValue
        SqlDataAdapter1.SelectCommand.CommandText = Str
        SqlDataAdapter1.Fill(DsLibrary1)
        DataGrid1.DataSource = DsLibrary1
        DataGrid1.DataMember = "Library"
        DataGrid1.DataBind()

    End Sub

Private Sub DataGrid1_PageIndexChanged(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEvent Args) Handles DataGrid1.PageIndexChanged
        Try
            DataGrid1.CurrentPageIndex = e.NewPageIndex
            BindGrid()
        Catch ex As Exception
            Dim a As String
            a = ex.Message
        End Try

    End Sub

 Private Sub ddlView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlView1.SelectedIndexChanged
       BindGrid()
 End Sub

Hi Spacy, now I use ur 2nd suggestion. i.e when i select
Books, the data is displayed, then I navigate through the records.
But when I select Journals, the following error is displayed.

Server Error in '/e-library' Application.
--------------------------------------------------------------------------------

Invalid CurrentPageIndex value. It must be >= 0 and < the PageCount.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: Invalid CurrentPageIndex value. It must be >= 0 and < the PageCount.

Source Error:


Line 219: DataGrid1.DataSource = DsLibrary1
Line 220: DataGrid1.DataMember = "Library"
Line 221: DataGrid1.DataBind()
Line 222: End Sub
Line 223:


Source File: c:\inetpub\wwwroot\e-library\Borrow.aspx.vb Line: 221

Stack Trace:


[HttpException (0x80004005): Invalid CurrentPageIndex value. It must be >= 0 and < the PageCount.]
   System.Web.UI.WebControls.DataGrid.CreateControlHi erarchy(Boolean useDataSource)
   System.Web.UI.WebControls.BaseDataList.OnDataBindi ng(EventArgs e)
   System.Web.UI.WebControls.BaseDataList.DataBind()
   e_library.Borrow.BindGrid() in c:\inetpub\wwwroot\e-library\Borrow.aspx.vb:221
   e_library.Borrow.ddlView1_SelectedIndexChanged(Obj ect sender, EventArgs e) in c:\inetpub\wwwroot\e-library\Borrow.aspx.vb:135
   System.Web.UI.WebControls.ListControl.OnSelectedIn dexChanged(EventArgs e)
   System.Web.UI.WebControls.DropDownList.System.Web. UI.IPostBackDataHandler.RaisePostDataChangedEvent( )
   System.Web.UI.Page.RaiseChangedEvents()
   System.Web.UI.Page.ProcessRequestMain()

I don't understand why it happens.

Thanks!

You need to reset the currentpage index every time your selection changes.

 Private Sub ddlView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlView1.SelectedIndexChanged
       DataGrid1.CurrentPageIndex = 0
       BindGrid()
 End Sub

Cheers..
Spacy...

Thanks Spacy, I solved the problem already.

People have spent so much time and energy trying to help you solve your problem.

As a common courtesy, please post your solution.

reset the currentpage index tpo 0

protected void DropDown_SelectedIndexChanged(object sender, EventArgs e)
 {
      GataGrid.CurrentPageIndex = 0;
  }

Regards,
Rajesh Sawant