Datasets - Best approach to use?

From: Dave Stumbles (Stumbles_at_discussions.microsoft.com)
Date: 01/12/05 

Date: Tue, 11 Jan 2005 18:57:02 -0800

I am writing a VB.NET 2003 web application to operate on my company's
intranet. It accesses data in an SQL Server database. I have developed a
couple of pages that display data successfully. However, there is one area
that I am having trouble getting a handle on, despite purchasing a couple of
Wrox books.

Up until now, I have used a whole lot of data adapters and datasets to be
able to display my information. The data is stored in a very hierarchical
structured database. I now want to be able to edit, delete and add new
records to most of these tables. The data would be edited in datagrids.

I have seen some information that indicates that having a 'mirror-image' of
the original database stored in a dataset is the way to go, ie this is
retrieved from the database, then modified and then sent back.

My questions are:

Is it best to have a single large dataset mimicking the tables and table
structure in the database?

If so, how is this achieved effectively? I only seem to be able to bring
across a table at a time.

Any help would be greatly appreciated.

Dave.

Relevant Pages

  • Re: VBA/Access Global Search&Replace from LUT
    ... Your client has a flawed database design that makes it difficult to ... In a properly structured database, all those fields in all those tables ...
    (comp.databases.ms-access)
  • Re: Datasets - what is the best approach?
    ... "Dave" wrote in message ... > (My apologies for posting this on two forums. ... The data is stored in a very hierarchical> structured database. ...
    (microsoft.public.dotnet.languages.vb)
  • Datasets - what is the best approach?
    ... one was the incorrect location) ... I am writing a VB.NET 2003 web application to operate on my company's ... It accesses data in an SQL Server database. ... structured database. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Login failed for user sa. (Error code: 18456).
    ... What transport mechanism is your default for SQL? ... > SQL Server database name: ... I tried windows authentication to access sql server database. ... I got different error message as "Login failed for user ...
    (microsoft.public.sharepoint.portalserver)
  • Re: MS Access with Linked tables Security Issue
    ... connect to SQL Server database with one Super ID that has all the super ... Dim dbs As Database, rs As Recordset, tdfAccess As TableDef ... Set dbsODBC = OpenDatabase ...
    (microsoft.public.access.forms)