Hi

I'm stuck at this problem here. When I put thi statement
"detailsview.pageindex = gridview.selectedindex"
I can only see the correct one provided that the gridview have not been sorted or paged before.
How can I overcome this problem?

Thank you

I think the details view may simply be giving you the default initial value. It sounds like it's not pulling the correct values from the database at all. It just looks like it, because the default SELECT looks the same as your unsorted unpaged gridview. Can you post your database access code?

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

Hi chroniclemaster1

Thank you for replying. Yes, it gives me the initial loaded value only. However, I would like it not to give me that.
Below are my codes:

ASP GridView
<asp:GridView ID="GridView1" runat="server" Height="308px" Style="z-index: 106; left: 15px; position: absolute; top: 146px" Width="512px" Font-Names="Arial Narrow" CellPadding="4" ForeColor="#333333" GridLines="None" PageSize="20" OnPageIndexChanging="GridView1_PageIndexChanging" AllowPaging="True" AutoGenerateSelectButton="True">
  <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White"/>
  <RowStyle BackColor="#EFF3FB" />
  <EditRowStyle BackColor="#2461BF" />
  <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
  <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  <AlternatingRowStyle BackColor="White" />
</asp:GridView>

Bind database record to GridView
Private Sub BindData()
  Dim dbconn As OleDbConnection
  Dim sql As String
  Dim dbcomm As OleDbCommand
  Dim dataAdap As OleDbDataAdapter
  Dim ds As DataSet

  dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" & Server.MapPath("DB.mdb"))
  dbconn.Open()
  sql = "SELECT ID, acct, eNo, Name FROM table"
  dbcomm = New OleDbCommand(sql, dbconn)
  dataAdap = New OleDbDataAdapter(dbcomm)

  ds = New DataSet
  dataAdap.Fill(ds)

  GridView1.DataSource = ds
  GridView1.DataBind()

End Sub

My DetailsView currently is running on AccessDataSource control, I linked it to a drop down list where user can choose by the ID. However, I want to change it to be able to use the selection button in the gridview.

The initial code for the DetailsView to actually show the result after selection button is clicked, but the problem lies here.
Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs)
  DetailsView1.PageIndex = GridView1.SelectedIndex
End Sub

Above are my codes, please advice.
Thank you!