Hi,have got a linq query to retutn data from table in my databse.I can see that it picks the columns i need returned but cannot display the data.I have a method to query that and i would appreciate if someone tells me whats wronng with my query below.Here is the query and method.Am filling the comboboxes on page load directly from the database.Here is the code.i cant figure whats wrong with this query really
public List<Student> GetStudentsData(int studentId,int schoolId ,int admissionNumber)
{
var query = from students in db.students
where students .studentId== studentId
where students .admissionNumber== admissionNumber
where students .schoolId== schoolId
select students ;
return query.ToList();
Mark as answer if satisfied