DBGrid connection through ADO (SQL)

[Sharad Singh]

Hi All,

Can any body help me to retrieve the data from MS access table in to the DB Grid at user form through MS SQL Query.

I am trying to use ADO for the same.

Thanks,
sharad

 

[xenou]

I'm afraid I can't be of great assistance since I'm not able to use this control myself, and haven't done so in the past.

Here is a website that has some info on using a flexgrid (article 2 of 2):
http://www.pbdr.com/vbtips/gen/Article-UsingFlexGrids(2).htm

I would add the following comments:
1) The first question I would ask is do you want your flexgrid control to maintain a dynamic connection to the underlying data source? In other words, if your user edits a value, should this update travel back to the original data source? That's probably a little more work - either committing changes or coding the updates.

2) If the control only needs to "show" data, then its probably simpler. Just query your data source, get the information of interest, and use the additem method of the flexgrid control to populate the grid. There would be no need to worry about changes to the data if it is all read-only.

3) I'm guessing that Norie is only asking what kind of information you want to display and why you need a flexgrid to do it. There are other ways to display data on a userform in Excel. Where is the data coming from? Who knows if you even need ADO for that matter...

Alex