F
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
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