allybta.blogg.se

My code is as follows: If i restrict the query to under 10 rows then it works fine but when it returns over the default 10 rows i get the error. 'Response.Write("NewpageIndex: " & e.NewPageIndex) This is the event (I think?) Protected Sub dg_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs) This declaration is at the top of all the code Dim dg As New GridView The table cell add is as follows: (dgSearchResults) Private Function dgSearchResults() As GridViewĭim con As New SqlConnection(CONNECT_STRING)įor Each colDataColumn In ds.Tables(0).Columns()ĭg.Columns.Add(CreateBoundColumns(colDataColumn))ĭg.Columns(0).ItemStyle.Width = Unit.Pixel(30)ĭg.Columns(1).ItemStyle.Width = Unit.Pixel(200)ĭg.Columns(2).ItemStyle.Width = Unit.Pixel(60)ĭg.Columns(3).ItemStyle.Width = Unit.Pixel(100)ĭg.Columns(4).ItemStyle.Width = Unit.Pixel(100)ĭg.HeaderStyle.BackColor = Color.Gainsboroĭg.HeaderStyle.HorizontalAlign = HorizontalAlign.Centerĭg.HeaderStyle.VerticalAlign = VerticalAlign.Middleĭg.RowStyle.BackColor = Color.FromName("#C3DAFA")ĭg.AlternatingRowStyle.BackColor = Color.Transparentĭg.AlternatingRowStyle.ForeColor = Color.Blackĭg.PagerSettings.Mode = PagerButtons.Numericĭg.EnableSortingAndPagingCallbacks = "true" What i don't understand is how to kick of the page index change event? My code is below. I'm pretty sure it is a data binding error as the row 416 in the error is where the data binding is done, row 99 is where the gridview is added to the table cell. () atĮ.wpSearch.dgSearchResults() inĮRS_SHAREPOINT\WebPartCode\wpSearch.vb:line 416 at .wpSearch.CreateChildControls() inĮRS_SHAREPOINT\WebPartCode\wpSearch.vb:line 99 DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) at (IEnumerable dataSource, Boolean dataBinding) at (Int32 rowIndex, Int32 dataSourceIndex, DataControlRowType rowType, DataControlRowState rowState, Boolean dataBind, Object dataItem, DataControlField fields, TableRowCollection rows, PagedDataSource pagedDataSource) at (GridViewRow row, Int32 columnSpan, PagedDataSource pagedDataSource) at (TableRow row, PagedDataSource pagedDataSource, Boolean addFirstLastPageButtons) at When i enable paging i get the following error. I have created a table with code and then inserted my code created gridview.

For development i have an aspx page to view my work.

I am creating a web part in vb.net so have programatically created all the controls.

Hi I'm really struggling to make the leap in understanding to get paging working for my gridview.