I used this code to show the data in DataGridView and it show me as it show in the pic in Table1. I want to make the data shows each collection same items alone. Asit show in pic in Table2. with empty row between them.
vb Code:
Dim sql As String = " SELECT B,C,D,E,F,G FROM Table1 ORDER BY B " conn.Open() Dim dp As New OleDbDataAdapter(sql, conn) Dim Table1 As New DataTable dp.Fill(Table1) Form1.DataGridView1.DataSource = Table1 conn.Close()




Reply With Quote