C#

select * from tablename where
name = 'JON' and
address like '%New%' and
age between 18 and 50

private void radButton1_Click(object sender, EventArgs e)
        {
            string query = "SELECT * FROM Mytable WHERE 1=1 ";
            if (txtValue1.Text.ToString()!= "")
            {
                query += " AND " + OpeReturn(FullName.Name.ToString(), cboOpe1.SelectedIndex.ToString(), txtValue1.Text.ToString());
            }
            if (value2.Text.ToString() != "")
            {
                query += " AND " + OpeReturn(TotalAmount.Name.ToString(), cboOpe2.SelectedIndex.ToString(), value2.Text.ToString());
            }
            query.ToString();
            SearchContractBindingSource.DataSource = RemoteClient.remoteData.QueryHopDongBan(query);
        }

private string OpeReturn(string field, string ope, string value)
        {
            switch (ope)
            {
                case "0":
                    return field + " like " + "'%" + value + "%'";
                case "1":
                    return field + " not like " + "%" + value + "%";
                case "2":
                    return field + " like " + value + "%";
                case "3":
                    return field + " like " + "%" + value;
                case "4":
                    return field + " = " + value;
                case "5":
                    return field + " != " + value;
                case "6":
                    int index = value.IndexOf(" ");
                    string value1 = (index > 0 ? value.Substring(0, index) : "");
                    string value2 = (index > 0 ? value.Substring(index + 1) : "");
                    return field + " > '" + value1 + "' AND " + field + " < '" + value2 + "'";
                case "7":
                    return field + " > " + value;
                case "8":
                    return field + " >= " + value;
                case "9":
                    return field + " < " + value;
                case "10":
                    return field + " <= " + value;
                default:
                    return " 1 = 1 ";
            }
        }

Shady George wrote:

what's a widget?