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
Printable View
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
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