access database query

  • Thread starter Thread starter rajjjjjjjjjjj
  • Start date Start date
R

rajjjjjjjjjjj

query = "Select * from AssociateDetails where Project_Name ='" +
drop_proj_name.SelectedValue + "' and Competency_level='" +
drop_comp_level.SelectedValue +"' and Experience='" +
drop_exp.SelectedValue + "'";

I am performing this code in oledb connection with acess data base,
but i m not getting output for "AND" operator.same query using "OR"
gives the o/p.pls help me out to solve this problem how to use "AND"
operator in my query.Very urgent

thanks
 
Back
Top