a quest about datagrid

i have a recordset object and has been open already. if i want to show the data in a mshflexgrid, i can use a line of code like this:
set mshflexgrid1.recordset=recordset1
the question is, what should i do if i want to use a datagrid to show the data of the recordset?
i use set datagrid1.datasource=recordset1,but no use.
will somebody tell me ? thanks in advance

datagrid. datasource is a database. To put rs to dbgrid, use
datagrid.recordsource=rs

Iouri Boutchkine
[email protected]

thanks first of all.
but I use datagrid ,not dbgrid,
this of datagrid?

"Set datagrid.datasource=record1" is what u need to display the data. Check if the recordset is still open.

Thanks

i 'm sure the recordset is open,
is there any properties need to be set before show
data in datagrid? thanks

as i said the only line of code u need to display the data is setting the data source property of the data grid. You can set other properties like if u wanna allow upadet, addnew ets operations using the grids. Right click on the grid then select properties.


Thanks

but it sames to be no use. will you please see my code? like this:
________________________________________
Dim C As New ADODB.Command
Dim rs As New ADODB.Recordset

On Error Resume Next

C.ActiveConnection = afxAdoConnection
C.CommandText = "select * from tblFiles"
C.CommandType = adCmdText

afxAdoConnection.Errors.Clear

rs.Open C

If afxAdoConnection.Errors.Count > 0 Then
Write_Error
Else
Set gridFiles.datasource = rs
End If

___________________________________
gridFiles is the name of the datagrid

Please add in the following statement:

rs.CursorLocation = adUseClient

then only follow by:

rs.open c

Hope it helps.