Error, cannot find OleDb [* Resolved *]

[steve_rm]

Hello

I have a problem with the following code. It gives an error saying that the OleDb could not be found. I have included using System.OleDb at the top of my form. But still get the error.

cnnTeacher.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\IBS Library System\LibrarySystem.mdb;Persist Security Info=False";
 
                OleDbCommand cmdTeacher = cnnTeacher.CreateCommand();
                cmdTeacher.CommandText = "Select * From Teacher Where TeacherID = txtIDNumber.text";
 
                cmdTeacher.Parameters.Add("ID", OleDb.VarWChar, 40).Value = txtIDNumber.Text; //OleDb could not be found
                OleDbDataAdapter daTeacher = new OleDbDataAdapter(cmdTeacher);
                OleDbCommandBuilder cbTeacher = new OleDbCommandBuilder(daTeacher);
 
                daTeacher.Fill(dtTeacher);

Many thanks in advance,

Steve

[Cander]

Post the EXACT error.

[steve_rm]

Hello,

thanks for your reply. This is the full error message:

The type or namespace name 'OleDb' could not be found (are you missing a using directive or an assembly reference?).

I hope you can help.

Steve

[Pirate]

using System.Data.OleDb;

[steve_rm]

Hello Pirate,

Thanks for your reply. I am using

using System.Data.OleDb;

Any more help with this.

Thanks,

Steve

[Pirate]

Check in the References item in the project solution explorer if you have System.Data . and also can you use fully qualified namespace in declaring OleDb objs ?

[steve_rm]

Hello,

Thanks for your help. I managed to find the answer. I don't need the line to add parameters. So l deleted it and made a few changes and now it works fine. Below is the correct code for your own review.

cnnTeacher.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\IBS Library System\LibrarySystem.mdb;Persist Security Info=False";
                OleDbCommand cmdTeacher = cnnTeacher.CreateCommand();
                cmdTeacher.CommandText = "Select * From Teacher Where TeacherID = '" + txtIDNumber.Text + "' ";
 
                OleDbDataAdapter daTeacher = new OleDbDataAdapter(cmdTeacher);
                OleDbCommandBuilder cbTeacher = new OleDbCommandBuilder(daTeacher);
 
daTeacher.Fill(dtTeacher)