[2.0] how ADO.net work?

i use the following code but it doesnt work:


using System.Data;
using System.Data.OleDb;

//connection
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + "\\dbTest.mdb";

OleDbConnection conn = new OleDbConnection(connectionString);
//

string commandString = "Select * from Table1";

oleDbDataAdapter(commandString,conn);

dataTable = ds.Tables["Table1"];

DataSet ds = new DataSet();
dataAdapter.Fill(ds, "Table1");


******************Note:

using System.Data.OleDb;

using System.OleDb;
The type or namespace name 'OleDb' does not exist in the namespace 'System' (are you missing an assembly reference?)


kindly help me pls?

See this tutorial on ADO.NET as it should help. :)

http://vbforums.com/showthread.php?t=466658

I assume you just copy and paste that code. Make sure you add reference the System.Data dll.