How to insert, delete, update and display data with MS Access database

[Haff]

Hello again guys,
I have a problem with Access database, I have two database with 12 table. I have connected the database using Datasaurces Wizard in VB 2005 xpress edition. The problem is how I want to retrive the data using SQL Statement and along with that how I am going to insert, delete, update and display the data in the Textbox, Richtextbox and Datagrid. That all, TQ.

[umararif]

If u r using vb, use adodc component.
u can add adodc component by pressing CTRL+T, add this component in form, right click and select properties. cnfigure ur db connection.
finally add ur text box and configure their property according to ur db data but the source connection for these boxes should be adodc.

umar

[jasonli]

Look up ADO.NET classes in namespace "System.Data.OleDb".

[aniskhan]

Article

[Haff]

Thank you for answering my questions but I am still confuse because all the sample coding is based upon SQL server rather than MS Access. Could you guys provide a coding in MS Access. Thank you.

[jasonli]

Sample code:

Public Shared Function getDataFromDB() As DataSet
	Dim conn As New OleDb.OleDbConnection("connection string here")
	Dim da As New OleDb.OleDbDataAdapter("SELECT * FROM TableName;", conn)
	Dim ds As New DataSet

	da.Fill(ds)
	Return ds
End Function