OleDbdataAdapter issue

radu popescu

Hello all,

I have the following code for revealing some data form my MS Access data base:

OleDbDataAdapter1 da = new OleDbDataAdapter1("SELECT * FROM [user]", @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\radhoo\desktop\test.mdb;Persist Security Info=False");
            DataSet ds = new DataSet();
            da.Fill(ds, "[nume]");
            dataGrid1.DataSource = ds.Tables["[nume]"].DefaultView;

The problem is that I get this message : "the type namespace name 'OleDbDataAdapter1' could not be found (you are missing a using directive or an essembly reference?)".

*also I have draged and droped a data grid on the form.

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bechir Bejaoui17y ago
A tip
If you are newbie in .Net before using any tip or object first check the whether the correspondant namespace is present or not for two raisons

First you will not loose time
Second you get the objects and their correspondants namespaces in your mind so event you use a simple block note to develop and entire assembly you won't be lost at all because every think is in your head.
radu popescu17y ago
I found why it didn't worked. First I neede to remove "1" - like Bechir said and it was missing a reference to System.Data.OleDb.
Bechir Bejaoui17y ago
OK
try OleDbDataAdapter without 1 instead