Saving to Access Database

Question

Hi
I'm busy writing a windows app in c# and are using a Access Database. App needs to travel on memory stick. I've done a few apps using SQL databases before but Access is something else! Does anybody got an example app for me? I need to Insert, update & delete.
Any help will be appreciated.
Cheers
Melger

Sam Hobbs · Answer

My Database Table Update in a DataGridView without Writing Code might help. You can use the Data Sources window described in that article to create a data source for your Access database. You can use that article to quickly create a simple program that does as you request.

Hirendra Sisodiya · Answer

this is very easy. you can use oledb connection and most general query for select insert etc are same as sql . so try and let me know. thanks

Melger · Answer

I did say I'm new in this huh? Provider? I this it? Microsoft.JET.OLEDB.4.0 Sorry that I look so stupid with this but I taught myself programming and don't always know the right wording. Learning very slowly this way! Hope you can help. Thanks Melger

Hirendra Sisodiya · Answer

Melger Which provider you are using? thanks