Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to Put a recordset into a flexgrid colunm by recordset ID
- Thread starter JMohammed
- Start date
Smack an Adodc onto your form. Click on (Custom) in it's properties. Connect it to your database:
1) Select Use Connection String, hit Build.
2) Select Microsoft Jet 4.0 OLE DB Provider, hit Next.
3) Select the database you wish to use. Hit OK.
4) Hit OK again to close this window and return to design time.
5) Select your Adodc object, in the properties window select RecordSource and click the little button.
6) Select the Command Type as "2 - adCmdTable"
7) In the "Table or Stored Procedure Name" field set the table you want to use.
Now select Project > Components, select Microsoft DataGrid Control 6.0 and hit OK. Drop a DataGrid onto your form. Now bind your DataGrid by setting it's DataSource property to your Adodc object (should be called Adodc1 if you didn't rename it).
Run the program.
1) Select Use Connection String, hit Build.
2) Select Microsoft Jet 4.0 OLE DB Provider, hit Next.
3) Select the database you wish to use. Hit OK.
4) Hit OK again to close this window and return to design time.
5) Select your Adodc object, in the properties window select RecordSource and click the little button.
6) Select the Command Type as "2 - adCmdTable"
7) In the "Table or Stored Procedure Name" field set the table you want to use.
Now select Project > Components, select Microsoft DataGrid Control 6.0 and hit OK. Drop a DataGrid onto your form. Now bind your DataGrid by setting it's DataSource property to your Adodc object (should be called Adodc1 if you didn't rename it).
Run the program.
- Status
Similar threads
