شاید به همراه کمبوباکس یه سویچ هم به کار برده شود ...... و نیاز به چند شرط در کوئری از بین بره .....
string query = null;
string selectedItem = null;
switch (Indx)
{
case 0:
selectedItem = "kala_name";
break;
case 1:
selectedItem = "price";
break;
case 2:
selectedItem = "payment";
break;
case 3:
selectedItem = "faktor_num";
break;
}
query = "SELECT * FROM zirna WHERE " + selectedItem + " LIKE N'" + searchtxt.ToString() + "%';";
var connection = new SqlConnection(constring);
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);