table adapter fill problem

[fanor]

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

 

[Cor Ligthert [MVP]]

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?ID=550279ec-6767-44ff-aaa3-eb8b44af0137

I hope this helps,

Cor

 

[Fanor]

What does this code mean?

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

 

[Cor Ligthert [MVP]]

Did you try the samples?

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