Populating MS DataGrid with a database, but without using MS ADO control -- How to?

[ur_unholyness]

Is there a way to populate the fields of the MS DataGrid by the fields of a database without using the MS ADO control, and also allowing Add, Delete and Modify capabilities?

[erickwidya]

Is there a way to populate the fields of the MS DataGrid by the fields of a database without using the MS ADO control yes, via Recordset Object

..and also allowing Add, Delete and Modify capabilities? yes too

for the first one..r u familliar with adodb before? if not..plz read this http://www.vbforums.com/showthread.php?t=81916
to populate the datagrid simply use this code

rs.open "SELECT * FROM tbl1"
set datagrid1.datasource = rs
datagrid1.refresh


for ur second question..just right click at the datagrid and tick mark for the one u want

hope can help