rashmi kc

rashmi kc

  • NA
  • 113
  • 159.7k

Random query

Jul 16 2012 3:04 PM
I am doing Randomly selecting the questions , when i select from the chapters from the checkboxliat only from that chapters all the questions should display  in C# windows forms
using access .

I am getting error like this 

Syntax error (missing operator) in query expression 'where  chaptername='Electromagnetic Induction''.


and my query is

" SELECT top 5 questions FROM [tblques] ORDER BY Rnd(quescode)  where
 chaptername=' " + checkedListBox1.SelectedItem + " '  ", con);

Answers (5)