Manipulating Access Database

[Daniel Kaseman]

What's the best way to manipulate a Microsoft Access Database from VB .Net?

I have gotten as far as making and configuring a OleDbAdapter, connection,
and Dataset, which is bound to a data grid. I'm able to see the data in the
table on the data grid when my VB program is running, and I can type new
data in, but I don't know how to actually update the database file (*.mdb
file).

So what's the best way to do this. I don't want to do alot of
programmatical SQL stuff.

It seems like there's gotta be some setting on the properties window
somewhere for one or more of these objects, to allow me to change the data
in the database.

[Armin Zingler]

Re: Manipulating Access Database

"Daniel Kaseman" <dan@cfaith.com > schrieb[color=blue]
> What's the best way to manipulate a Microsoft Access Database from VB
> .Net?
>
> I have gotten as far as making and configuring a OleDbAdapter,
> connection, and Dataset, which is bound to a data grid. I'm able to
> see the data in the table on the data grid when my VB program is
> running, and I can type new data in, but I don't know how to actually
> update the database file (*.mdb file).
>
> So what's the best way to do this. I don't want to do alot of
> programmatical SQL stuff.
>
> It seems like there's gotta be some setting on the properties
> window somewhere for one or more of these objects, to allow me to
> change the data in the database.[/color]

Call the Dataadapter's Update method to update the database by the values in
the Dataset shown and edited in the Datagrid:
http://msdn.microsoft.com/library/en...terdataset.asp


There's also a group for ADO.Net specific questions:
microsoft.publi c.dotnet.framew ork.adonet

Armin

[Daniel Kaseman]

Re: Manipulating Access Database

thank you!

"Armin Zingler" <az.nospam@free net.de> wrote in message
news:O4EJCziWFH A.3996@TK2MSFTN GP09.phx.gbl...[color=blue]
> "Daniel Kaseman" <dan@cfaith.com > schrieb[color=green]
> > What's the best way to manipulate a Microsoft Access Database from VB
> > .Net?
> >
> > I have gotten as far as making and configuring a OleDbAdapter,
> > connection, and Dataset, which is bound to a data grid. I'm able to
> > see the data in the table on the data grid when my VB program is
> > running, and I can type new data in, but I don't know how to actually
> > update the database file (*.mdb file).
> >
> > So what's the best way to do this. I don't want to do alot of
> > programmatical SQL stuff.
> >
> > It seems like there's gotta be some setting on the properties
> > window somewhere for one or more of these objects, to allow me to
> > change the data in the database.[/color]
>
> Call the Dataadapter's Update method to update the database by the values[/color]
in[color=blue]
> the Dataset shown and edited in the Datagrid:
>[/color]
http://msdn.microsoft.com/library/en...terdataset.asp[color=blue]
>
>
> There's also a group for ADO.Net specific questions:
> microsoft.publi c.dotnet.framew ork.adonet
>
> Armin
>[/color]