Hello guys ,

I am new to here... I need the output as shown below... So please edit my code according to the output.

My code:

Code:
Dim r As ADODB.Recordset

Private Sub Form_Load()

Set r = New ADODB.Recordset

With r.Fields
.Append "First name", adBSTR
.Append "Second name", adBSTR
.Append "Third name", adBSTR
End With

r.Open

r.AddNew 0, "Siva"
r.AddNew 1, "Chand"
r.AddNew 2, "SivaChand"

Set DataGrid1.DataSource = r

End Sub
For the above code output:

First name Second name Third name
Siva
Chand
Sivachand

But i want the output like this:

First name Second name Third name
Siva Chand Sivachand
test1 test2 test3

Please help me to make this change..... Advance thx....