Set DBGrid Datasource property?

[jasonp45]

I know I've done this before, but I can't remember...how do I set the MSDBGrid control's datasource property?

 

[Micash]

Hi jasonp45!
If you're using the standard DBGrid control, you will find that the 'intrinsic data control' - the one that appears when you open a standard project - can be bound to the Grid. Obviously the data control should be on the form so it will appear as an option in the dropdown under DATASOURCE. Ado (OLEDB) controls will not work with DBGrid.
Hope this helps
Regards - Micash

 

[gk207541]

dim rs As New ADODB.Recordset
Set rs.ActiveConnection = (u know here)
rs.Open " Select * from Custommers" 'Better don't do this
set myGrid.DataSource = rs