I keep getting the following error and unsure has to how fix it. As a fairly new user to VB.NET, I think it is saying that there are no rows at that position? To compensate for this, I included an If statement to check the row count, but it is still producing this error. In fact, the messagebox is not firing at all. The error seems to happen when I use the combobox to change the value of the pagesize. Can someone please advise as to how I can correct this error. Thanks
There is no row at position 1.combobox sub to change pagesizeCode:Private Sub loadpages() Dim i As Integer Dim startRec As Integer Dim endRec As Integer Dim dtTemp As DataTable 'Dim dr As DataRow 'Duplicate or clone the source table to create the temporary table. dtTemp = dtSource.Clone If currentPage = PageCount Then endRec = maxRec Else endRec = pageSize * currentPage End If startRec = recNo 'Copy the rows from the source table to fill the temporary table. If dtSource.Rows.Count <> 0 Then For i = startRec To endRec - 1 dtTemp.ImportRow(dtSource.Rows(i)) <--- ERROR HERE recNo = recNo + 1 Next Else MessageBox.Show(dtSource.Rows.Count.ToString()) End If frmMain.DGV.DataSource = dtTemp DisplayPageInfo() 'fillPostings() End Sub
Code:Sub cmbpage() 'Set the start and max records. pageSize = CInt(frmMain.cmbPageSize.Text) maxRec = dtSource.Rows.Count PageCount = maxRec \ pageSize MessageBox.Show(CStr(maxRec)) ' Adjust the page number if the last page contains a partial page. If (maxRec Mod pageSize) > 0 Then PageCount = PageCount + 1 End If 'Initial seeings currentPage = 1 recNo = 0 ' Display the content of the current page. UDGfillPostings() loadpages() End Sub




Reply With Quote
