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 not familier with DB grids - if that's a .NET control then you'd be better off posting in a .NET forum. Generally speaking:

1) Create a connection using a connection object or other interface. .NET has data adapter or something like that. ADO uses a connection object. MS Query is another brand of connection, based on ODBC I think.
2) load or fill the dataset object you are using (recordset, datatable, datagrid, etc. etc.)
3) do what you need to do.
4) close the connection

That's it. Frankly, Excel is a massive data grid unto itself so you don't always need to create one for it in a form.

For ADO generally it is very helpful to go to W3Schools - ADO. For ADO and Excel you can poke around at erlandsendata - but again, you sound to me like you're using .NET which is a slightly different animal (Excel userforms don't have datagrids by default - or is this something new in 2007?)

Alex

 

[Sharad Singh]

Thanks a lot !

Actually the DBgrid is additional tool in Excel. In which actually we show the data in Grid format.

I don't want to show excel to users.that's why used DB grid. I will try..

Thanks,
sharad

 

[xenou]

Sure thing. If you have more info on this tool I'd be interested ... I don't see it in the default set of controls for userforms. But this is the second post I've seen referring to such a control so it must be getting more popular.

Alex

 

[Norie]

Alex

Right click the control toolbox and select Additional controls...

You should then get a list of controls you can add, and one of them is Microsoft DataGrid Control.

 

[xenou]

Ah...
Thanks Norie. Excel says I don't have a license so...no joy.

Alex.

 

[Norie]

Alex

I thought something like that might happen.

I don't get the 'license' thing but I do get a message saying that 'The subject is not trusted for the specified action' when I try to add a DataGrid control to a userform.

I think that has something to do with updates and KillBits (whatever they are).

I can't even add a simple calendar control to a userform in Excel VBA.

I've tried to fix these problems but gave up because it seemed like too much trouble - but that's probably me being lazy.

I can add the controls to forms in VB6, VB.Net, C# and Access but no luck with Excel.

 

[Sharad Singh]

HI All,

Even I am facing the same problem when I try to select Microsoft Data grid or flexgird. moreover the DB grid is working fine. However I still not able to connect the DB grid with ADO.

Actually the problem is that,I want to show the report to user which has more then one column and rows on VBA user form it self. Which can't be possible without using such tool.. or I need to use lot of list boxes...???

currently I have used the list boxes. but with list box the problem is that ...if the text is very large then the user will not be able to read the whole text as no scroll bar is available for them. However the scroll bar option is "ON". and if the text is small the list box, then it is showing the scroll bar which is not required on that moment. I don't know why??

Please if you all have any solution on this..let me know...

Thanks,
Sharad Singh

 

[Norie]

Sharad

Why are you trying to do this in the first place?

 

[Sharad Singh]

Hi,

I don't understand ??

I want to use the DB grid in user form through ADO....

Thanks,
sharad