how about adodb???

does the adodb (as a connection to database) is not applicable when using datagrid in vb.net?i'm sorry if i sound weird, i just don't know how to do it in vb.net. i just know how to do it in vb6. let say, i have cn as adodb.connection, rs as adodb.recordset. then i open the connection (eg. cn.open("<here's my connection string>")), rs.open("here's my sql statement", cn, adOpenDynamic,adLockPessimistic) and finally i'll just write this code:

DataGrid1.Datasource = rs

that's the way i know to do it,but it's in vb6. vb.net is far more different,

thanks.,