VB2005 Datagrid help for beginner!

[micki_free]

I am currently trying to create a program using Microsoft Visual Basic 2005 in conjunction with Microsoft Access 2003 but I am having a few problems and I was hoping that you could help me out.

I want to use some sort of DataGrid to present data to users

I also want to be able to define the contents of the Datagrid at run time, namely what table to display, what rows to display and what fields to display. I would prefer to do this through the use of an SQL query

I also want to define whether the information in the datagrid is read-only or writeable as well as whether the user can add new records

Do you guys have any suggestions?

 

[georgedwilkinson]

I'm conflicted on what to say to you.

You say that you're a beginner but you're using more advanced programming techniques. I can't imagine why you would want to learn both Access and VB 2005 both at the same time.

Yes, VB has a plethora of data grids available. Yes, they take SQL statements as one of their properties. Just select a data grid control from the VS controls toolbar. You probably won't be able to get much more help on these forums on using them, though.

If you're just learning, you should really just stick with Access...you can design your forms in Access. If you're really stuck on learning VB outside of Access, you could start with Access and when you are comfortable that you've mastered it (not many people have), you can export your forms to a class module for inclusion in a VB project.