DataGrid 6.0 and SQL

[Craf]

hi!

is it possible to load the cells of a DataGrid 6.0 control from more than 1 table without using ADO? If so, then can any1 pls show me?

tnx n advnce!

:)

[TheBeansprout]

Hmm....only thing I can think of is to use two datagrids?

But I've only just started VB + SQL stuff.

[quatu]

What do you mean? Can you be more specific?

If you want to combine two SQL queries together you can use UNION:

strSQL = "SELECT Fname, Lname FROM Users " & _
"UNION SELECT Id, Name FROM Roles"