I want to make a empty row between the items in DataGridView

[nader]

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.

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()

[stanav]

You can hack it by looping thru the datatable and testing the value of column B for changes. If a change occurs, insert a blank row to the table. When done, bind the table to your DGV...
However, I would just change the background color of the DGV rows instead of inserting blank rows to the datatable.

[nader]

I want to make directly from DataGridView.

[stanav]

Of course you can loop the datagridviewrows collection and detect for value changes in specific cells and insert a (blank) datagridviewrow to the DGV where the change occurs. However, your DGV is bound to a datatable thus whatever changes made in it will go into the datatable also, you may better just loop the datatable. Besides, by looping the datatable and inserting blank datarows to it, you can set the rows state to unchanged so when it's time to update your database, those blank rows won't get inserted into your database table.

[nader]

I treid this code But it show me this error:
"Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound".

Dim i As Integer
        For i = 0 To DataGridView1.Rows.Count - 1
            If DataGridView1.Rows(i).Cells(1).Value Like _
            DataGridView1.Rows(i + 1).Cells(1).Value Then
 
                DataGridView1.Rows.Add()
            End If
 
        Next