Gridview and Paging

[alwinSCH]

Hello, Please can somebody help me! On my page I have a radiobuttonlist with 2options 1option name 2option User When I click option1 a textbox becomes visible, enter any text in here and a dataset will be filled with information and bound to gridview to display (textbox textchanged event) (so far so good) then when i press option2 the gridview stays visible, a dropdownlist becomes visible where i can choose a user,a new dataset is filled and bound to the gridview (function selectedindexchanged event) (so far so good) in the gridview allowpaging=true pagesize =10 now when i press a button (next, previous)the paging does not work I still see page 1. Please can you give me an idea how to solve this! Thanks, Alwin

[alwinSCH]

Maybe I little code could help! This i what i call on dropdownlist1.selectedindexchanged Protected Sub change_dropdownlist() Dim ds As New DataSet Dim cmdopvolging As New SqlCommand("SP_Gridresult", objconnection) cmdopvolging.CommandType = CommandType.StoredProcedure Dim parbeh As New SqlParameter("@beh", SqlDbType.Int) Dim parsessie As New SqlParameter("@sessie", SqlDbType.Char, 50) parbeh.Direction = ParameterDirection.Input If dropdownlist1.SelectedItem.Text = "[ALL]" Then parbeh.Value = 0 Else parbeh.Value = CInt(dropdownlist.SelectedValue) End If parsessie.Direction = ParameterDirection.Input parsessie.Value = CStr(Session.SessionID) cmdopvolging.Parameters.Add(parbeh) cmdopvolging.Parameters.Add(parsessie) Dim aantal As Integer objconnection.Open() aantal = cmdopvolging.ExecuteNonQuery objconnection.Close() 'Show temporary table in gridview Dim voorw1 As String = " select streefdatum,naam,polisnr,code from t_leven_selectie" Dim daresult As New SqlDataAdapter(voorw1, objconnection) daresult.Fill(ds, "T_leven_selectie") 'Here comes the gridview GrdResult.DataSource = ds GrdResult.DataMember = "T_leven_selectie" GrdResult.DataBind() 'empty the table T_leven_selectie (temporary table) Dim cmddel As New SqlCommand("SP_deltempSelectie", objconnection) cmddel.CommandType = CommandType.StoredProcedure Dim parsessiedel As New SqlParameter("@sessie", SqlDbType.Char, 50) parsessiedel.Direction = ParameterDirection.Input parsessiedel.Value = CStr(Session.SessionID) cmddel.Parameters.Add(parsessiedel) objconnection.Open() aantal = cmddel.ExecuteNonQuery objconnection.Close() And now i want to be able todo paging! But it does not work Alwin

[Ista]

your not sync the PageIndexChange event and you not set the current page upon pastback if( IsPostBack ) { ... do code here } I'm not an expert yet, but I play one at work. Yeah and here too.

[alwinSCH]

In the page load event, i do if ispostback =false then ... 'Fill dropdownlist1 endif That is all i do in here why do i have to use these 2 functions PageIndexChanged --> used after the paging PageIndexChanging --> used before paging I have created them but there is no code in it So i don't know what you mean with PageIndexChange event? Thanks Alwin

[Ista]

Well I saw grid and with the datagrid you need to record the current page it is on and each postback set the index page inside the grid the grid doesn't maintain state, you have too If we're on the same page, so to speak Nick I'm not an expert yet, but I play one at work. Yeah and here too.

[alwinSCH]

I know if i do it with a datagrid it will work, (done something on an earlier project) But know using VS2005 --> a draw a gridview, because didn't see the datagrid, and here it will not work! Thanks i will solve it with a datagrid like earlier! Alwin