i have a table with a GetData(Param1) method that has this select

SELECT     empid, firstname, lastname
FROM         employees
WHERE     (empid NOT IN
                          (SELECT     empid
                            FROM          WorkOn
                            WHERE      (job = ?)))

in a form I want to fill it like this

......................

System.Data.OleDb.OleDbParameter mypar= new
System.Data.OleDb.OleDbParameter();

if (MNjob > 0)

{

mypar.Value= MNjob;  // MNjob is int

this.workEmpTA.FillByJob(this.dBCCmangrDataSet.WorkEmp, MNjob);

this.empAvailTA.Fill(this.dBCCmangrDataSet.EmpAvail,mypar);  // HERE THE
ERROR

}

............................

empAvailTA is the table adapter

What is wrong with mypar???



I'm using VS2005



TIA

What does this code mean?
The second parameter is AFAIK the Table name

Have a look at the this sample on our webpage

http://www.vb-tips.com/dbPages.aspx?ID=550279ec-6767-44ff-aaa3-eb8b44af0137

I hope this helps,

Cor

Is to populate the EmpAvail table and mypar is the parameter that is causing
the error.

Did you try the samples?

Show quoteHide quote

Closing Connections
Re: Connection to ORACLE: Need some explanations
Connection to ORACLE: Need some explanations
Concurrency violation and DateTime
Query runs slow from web app, but not from management studio