title: Dynamic Query  from GUI
body: <p>My Database stores the information of Students in a tables along with their course offerings in other tables. There are more associated tables.</p>
  
  <p>Now I wanna create a form that looks like this : <img src="https://i.stack.imgur.com/wF9UG.png" alt="enter image description here"></p>
  
  <p>Depending on the search criterion, the Query shall be executed. 
  <strong>More than one criterions may be selected.</strong> After hitting the search button, the various tupples shall be displayed.</p>
  
  <p>Whats teasing me is how should i proceed with the Query part....???</p>
  
  <p>Can anyone please help me out?
  b.t.w. I use SQL 2008R2 along with Visual Studio 2010.</p>