[2.0] how ADO.net work?

[arshesander]

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?

[RobDog888]

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

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

[mar_zim]

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