SQL

[jas_1]

Hi,

Can anyone help me with a SQL VB intergration problem?

I am trying to display the results of an SQL querie in a DataGrid without using a data bound controller. Does anyone know how to do this?

I would be greatful to any responses.

Thanx
Sajjad

[Chuck Sweet]

try using ado.
create a recordset that retrieves the information needed:

dim rs as new adodb.recordset
rs.open "select * from Table", cnxConnection

set the datagrids datasource property to the recordset:

set dgrid.datasource = rs

and that should work. i usually use listviews myself, but that's a little more complicated.

good luck
chuck