Re: visual basic.net standard 2003 (ado.net)

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 15:50:24 -0700

I suggest that you look more closely at your database design. I virtually
all cases when we've seen designs with this many columns it's because the
database is not normalized. Since an average (albeit wide) normalized
relational table might have 20 or 30 columns, 100 is excessive. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"ADO data adapter limit" <ADO data adapter limit@discussions.microsoft.com> 
wrote in message news:D486C190-4B8C-4CA1-AFFB-B86D1B424BF2@microsoft.com...
> Why is there a 100 field limit when using the adapter wizard to configure 
> a
> data adapter. I have a database that has over 200 fields and need the 
> ability
> to add, update and delete. The wizard fails with an error message "There 
> were
> errors configuring the data adapter". I do not understand how Microsoft 
> can
> provide the ability to have 200+ fields in Access or SQL and not support 
> them
> with ADO that they have been highly promoting. I never had a problem with 
> DAO
> using VB6. What's up! frustrated with .net

Relevant Pages

  • RE: Datagridview vb.Net (Update Insert delete)
    ... you use a data adapter to fill a data table. ... After you update in the datagridview, ... use the data adapter to save the changes to the database. ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)
  • RE: Datagridview vb.Net (Update Insert delete)
    ... you use a data adapter to fill a data table. ... After you update in the datagridview, ... use the data adapter to save the changes to the database. ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)
  • RE: DataAdapter, sedond update
    ... I modified my code to use SQLClient objects and an SQL Server database. ... This line of code uses the commandbuilder to set up the dataadapter's ... Dim cb As New OleDb.OleDbCommandBuilder ... > you are using an oleDB data adapter connecting to an access database, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Relationships. Does anyone use them?
    ... If you do not care to "go in into the relationships window to set the relationship" you are, quite simply, going to fail badly any relational database course. ... Relationships are the constraints that are needed to be set up to ensure database structural integrity. ... You really need to go over this in detail, because right now I can tell you, no offence intended and with the greatest of respect, that you are NOT DOING RELATIONAL DATABASE DESIGN WORK at present. ...
    (comp.databases.ms-access)
  • Re: Table design - reducing number of entities
    ... I've looked at a lot of crappy code written against databases. ... lot of that code is crappy, because the database design itself was crappy. ... > look at all the constraints on the putative entities--not forgetting the ...
    (comp.databases.theory)