What's the best method for connecting VS2005 and Access Database. I want to ADD, EDIT, REMOVE and DELETE data from Access. Thanks!
Printable View
What's the best method for connecting VS2005 and Access Database. I want to ADD, EDIT, REMOVE and DELETE data from Access. Thanks!
Take a look at the articles in our Database Development FAQs/Tutorials (at the top of the Database Development forum), particularly the "ADO.Net Tutorial"
OleDbDataAdapter
I'm using OleDbdDataConnection and OleDbDataAdapter and DataSet, but problem is how to edit some date, and how to view some specific dates when I press add button
Code:Me.BindingContext (XDataSet, "Dates").AddNew
Check out this web site - They have a really good beginners tutorial for manipulating an Access database with code.
http://www.homeandlearn.co.uk/NET/vbNet.html