ADO to ADO.NET 2.0

We're beginning a major rewrite of a VB6 application that currently uses ADO
and an Access database. In this application, we routinely query multiple
table through JOINs and place the result in a single connected record set
that is often bound to a grid for display and editing by the user. Changes
to the database are implemented by the record set's Update command.

We're looking to rewrite using VB.NET in VS2005 and either SQL Express or
Access (haven't decided yet). We can seem to get a handle on how to acheive
the same sort of data handling in ADO.NET 2.0 as we used in ADO, that is,
query into multiple table combined into a single entity that can be bound to
a grid for display and editing by the user, and with a simple Update command
updating the database tables.

There are plenty of examples of this using single tables, but how do we go
about combining data from multiple db tables via query JOINs, and then
binding the result to a single grid or view for display and editing, and
then updating the tables?

Can someone point us to samples or examples illustrating the best way to do
this? TIA!


.

Relevant Pages

  • Re: Merging data from Access Query
    ... Data from the database will be placed in the document, ... Y/N ?" ... If the query references the Form, ... The process starts in an access database. ...
    (microsoft.public.word.mailmerge.fields)
  • This ones a challenge: 1.9 not equaling 1.9..... Whats going on???
    ... I've got a real challenge this time with an access database that I'm ... I'm writing this database for work, ... column #1 in the query is titled ...
    (microsoft.public.access.queries)
  • Re: Multiple MS Access table sources for pivot table
    ... I have created a query in Access using multiple tables and then used the ... Data-Get External Data option to connect the Excel spreadsheet to the Access ... same Access database... ...
    (microsoft.public.excel.misc)
  • Re: Creating a multiple table query...
    ... >I have a database that has multiple tables and would like to do a few thing. ... >like to do is create a query that get a user input, looks at the data in all ... >will look at all of the colums in the table to see if it matches the string. ...
    (microsoft.public.access.queries)
  • Re: Trying to build a database driven website
    ... content blocks in multiple pages and one or more of those links has changed. ... You would have to query all html fragments ... No database experience? ... You have made it very obvious you have no idea how a database can be used effectively for websites. ...
    (comp.lang.php)
Loading