table adapter fill problem

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

>
> this.empAvailTA.Fill(this.dBCCmangrDataSet.EmpAvail,mypar); // HERE THE
> ERROR
>
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...a3-eb8b44af0137

I hope this helps,

Cor

"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:%232PAm1nlGHA.3588@TK2MSFTNGP02.phx.gbl...
> >
>> this.empAvailTA.Fill(this.dBCCmangrDataSet.EmpAvail,mypar);
> What does this code mean?

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

Did you try the samples?

"Fanor" <xreed2000@yahoo.com> schreef in bericht
news:%23%23MJQltlGHA.4196@TK2MSFTNGP03.phx.gbl...
>
> "Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
> news:%232PAm1nlGHA.3588@TK2MSFTNGP02.phx.gbl...
>> >
>>> this.empAvailTA.Fill(this.dBCCmangrDataSet.EmpAvail,mypar);
>> What does this code mean?
>
> Is to populate the EmpAvail table and mypar is the parameter that is
> causing the error.
>
>
>