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]

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.

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-us/cpguide/html/cpconupdatingdatabasewithdataadapterdataset.asp


There's also a group for ADO.Net specific questions:
microsoft.public.dotnet.framework.adonet

Armin

 

[Daniel Kaseman]

thank you!

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-us/cpguide/html/cpconupdatingdatabasewithdataadapterdataset.asp


There's also a group for ADO.Net specific questions:
microsoft.public.dotnet.framework.adonet

Armin