By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,558 Members | 1,673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,558 IT Pros & Developers. It's quick & easy.

Manipulating Access Database

P: n/a
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.
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Daniel Kaseman" <da*@cfaith.com> schrieb
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...terdataset.asp
There's also a group for ADO.Net specific questions:
microsoft.public.dotnet.framework.adonet

Armin

Nov 21 '05 #2

P: n/a
thank you!

"Armin Zingler" <az*******@freenet.de> wrote in message
news:O4**************@TK2MSFTNGP09.phx.gbl...
"Daniel Kaseman" <da*@cfaith.com> schrieb
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...terdataset.asp

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

Armin

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.