|
There are multiple ways, of doing it, but in the VB way, you just need to use the Data Access control. You can link it directly to an Access 97 database, but this is a bit out of date - if you have Access installed, you should be able to choose ODBC and go at it that way (using the more up to date SQL drivers). If you have anything other than the crippled learning edition, you should have the VisData sample project and code, which should do what you're looking for, though it's a pain to strip out all the rubbish (haven't Microsoft heard of object-oriented modularisation?).
There is a built in "retrieve stuff from database" function, where you go around setting the datasource property on textboxes, grids etc to bind to the control, which is quick though restrictive - I've never seen the point, personally. There is actually a wizard somewhere that'll do it for you, though if you want to do anything more I'd do the data update/retrieval manually.
Hope this helps - search through the documentation (walkthrough of the VisData project in your Samples folder should help) or look on MSDN for more information.
|