Sel Soft

Sel Soft

  • NA
  • 1
  • 927

Query building methods based on mulitple parameter

Jun 14 2013 9:51 AM
Hi all,

What is the best way to build a query (that depends on multiple parameters) for the purposes of updating a DataGridView from a database table.
Is creating query strings based on all the combination an efficient way of doing it?
(i.e.  query strings for all combinations like [a,x,1],[a,b,x,1],[a,c,x,1]....)

---------------------------------------------
Parameter_1  Parameter_2  Parameter_3

option_a       option_x        option_1
option_b       option_y        option_2
option_c       option_z
option_d
---------------------------------------------

Parameter_1
Parameter_2
Parameter_3








Answers (1)