the problem is here
public static List GetClientByStaffId(string STAFF_CL)
{
List clients = new List();
SqlCommand selectCmd = new SqlCommand("select * from TRS_LUT_CLIENT C, TRS_TASKS T where C.CLIENT_ID = T.CLIENT_ID and T.STAFF_CL = @ STAFF_CL");
selectCmd.Parameters.Add("STAFF_CL", SqlDbType.NVarChar).Value = STAFF_CL;
DataTable dt = DBManager.ExecuteQuery(selectCmd);
foreach (DataRow row in dt.Rows)
{
clients.Add(new TRS_LUT_CLIENTS(int.Parse(dt.Rows[0]["CLIENT_ID"].ToString()), dt.Rows[0]["CLIENT_NAME"].ToString(), dt.Rows[0]["CLIENT_ADDRESS"].ToString(), dt.Rows[0]["CLIENT_DESCRIPTION"].ToString()));
}
return clients;
}
i can't c it at all !! i thought that it may be the parameters.add . but what exactly i don't know !!