(22-04-23, 02:02 AM)foo كتب : ما الفرق بين هذا الموضوع والموضوع السابق "تصفح الداتاغريد فيو"؟

(22-04-23, 02:33 AM)foo كتب : هذا الشرح ليس له علاقه بسؤال الموضوع
والحل في موضوعك السابق لا يلغي اي سطر

اعمل مشروع بسيط فيه نفس فكرة الاقساط للتعديل عليه

(26-04-23, 09:01 PM)aljzazy كتب :

كود :

Private Sub LoadData(pageNumber As Integer)
   ' Define the number of rows to display per page
   Dim rowsPerPage As Integer = 25

   ' Calculate the starting row for the current page
   Dim startRow As Integer = (pageNumber - 1) * rowsPerPage

   ' Connect to the database and retrieve the data
   Dim connString As String = "Your connection string here"
   Dim query As String = "SELECT * FROM YourTable ORDER BY YourColumn OFFSET " & startRow & " ROWS FETCH NEXT " & rowsPerPage & " ROWS ONLY"
   Dim adapter As New SqlDataAdapter(query, connString)
   Dim dataTable As New DataTable()
   adapter.Fill(dataTable)

   ' Set the data source for the DataGridView
   DataGridView1.DataSource = dataTable
End Sub

Private Sub btnNext_Click(sender As Object, e As EventArgs) Handles btnNext.Click
   ' Increment the page number and reload the data
   pageNumber += 1
   LoadData(pageNumber)
End Sub

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
   ' Load the first page of data when the form loads
   pageNumber = 1
   LoadData(pageNumber)
End Sub