How to merge cells in VB.net Data Grid View with equal values from SQL

Question

here are my example cells

it should be like this one

here is my code for filling my data grid

    con.Open()
    Dim query As String = "select * from tbllogin"
    Dim cmd As New SqlCommand(query, con)
    Dim rd As SqlDataReader
    rd = cmd.ExecuteReader

    DGV.Columns.Clear()
    DGV.Rows.Clear()

    DGV.Columns.Add("col1", "UserName")
    DGV.Columns.Add("col2", "Password")

    While rd.Read
        DGV.Rows.Add(rd("UserName").ToString, rd("Password").ToString)
    End While

    rd.Close()
    con.Close()

Answer 1

There is no simple way to merge cells in DataGridView. You need to manually alter the way the grid painted and that is not a fun work :(

Some questions already asked addressing similar requirement :

• How to Merge DataGridView Cell in Winforms
• Merge cells in datagridview