DATAGRID CONTROL

P

pratik

How can i use datagrid control to display data in tabular format and lock
columns as desired.
 
P

pratik

kakkal,

Thanks for your artcicle and example.

please let me know how can i display data in the datagrid?
I can do the same in vb with the help of Adocdc. I am unable to find the
datagrid.datasource property in ms-access.

PM
 
A

Albert D. Kallal

kakkal,

Thanks for your artcicle and example.

please let me know how can i display data in the datagrid?
I can do the same in vb with the help of Adocdc. I am unable to find the
datagrid.datasource property in ms-access.

Well, those examples of mine don't use data grids at all, but use simply
plain old ms-access forms. You just build form, and set it into continues
mode.

For those forms, you then use the RecordSouce. You can go:

me.RecordSouce = "select * from tblCites order by city"

The "me" refers to the current form for the code running. A full qualified
ref would be:

forms!MyFormName.ReocrdSource = strMySqlString

So, you can just stuff the sql right into the forms recordsouce..and it
fills..and queues the data for you. No extra work is needed. You don't need
a connection string, or even a data object like you do in VB.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top