ADO.net ~ Generate typed dataset in code? - simple question - help

From: Matthew (mososky_at_hotmail.com)
Date: 07/20/04 

Date: 20 Jul 2004 16:28:52 -0700

I'm coming back into a little database programming via ADO.net And I'm
having a hard time swallowing some of this stuff. My basic problem is
this, although it seems easy enough to use the data wizards to plop
down form bound data componets, there seems to be a heluva-lot of
overhead in designing the data at run-time in code- like a module. I
just like to do it this away, because i believe it's more reliable and
portable, yada, yada, yada.

Anyway, building the connection and queries seems easy but when i get
to the data adapter / dataset it seems far more difficult than when i
did it back in VB6 (not that i really remember that, it's been awhile,
but it surely was not this compicated) I can't figure out how, or if
its possible to create a typed-dataset at runtime so i'm stuck with an
untyped. Which is making me manualy define the dataset's schema,
adding the tables and colunms. This is a real pain in the ass. I
remember it being pretty easy in vb6, i could build a data connection
and do all the data return and navigation with probably less than
20-25 lines of code.

Am I being stupid about something? What's the easiest way for me to
plop down some code that just will allow me to read/update an access
database and do all the configuration in runtime?

-thx!
matthew

Relevant Pages

  • Re: ADO.net ~ Generate typed dataset in code? - simple question - help
    ... My personal opinion is that using any automated tools do not give you big ... > portable, yada, yada, yada. ... > did it back in VB6 (not that i really remember that, it's been awhile, ... > remember it being pretty easy in vb6, i could build a data connection ...
    (microsoft.public.data.ado)
  • Foxpro Programming
    ... I'm a programmer with a fair amount of database programming and admin ... vb6, and 2 yrs exp. ... Some experience writing java as ...
    (microsoft.public.fox.programmer.exchange)
  • Re: SQL Server does not exist error
    ... > I'm making the transition from VB6 to VB.Net and decided I'd FINALLY try ... > hand at database programming. ... When you installed SQL Server you gave it a name. ...
    (microsoft.public.vb.database)
  • SQL Server does not exist error
    ... I'm making the transition from VB6 to VB.Net and decided I'd FINALLY try my ... I purchased "Database Programming with VIsual ... I finally found that SQL Server isn't included with VB.NET, ...
    (microsoft.public.vb.database)