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
|
|
|
|
|
|
|