Sql instruction doesnt obey...

Question

Hi!

 

I am writing sql code to search the number up or less than "x" (dsiplaying on my datagrid). But its doent work. For instance, show me all number up than 2 or less using a textbox. See my codes please:

 

conn.Open();

OleDbCommand cmd = conn.CreateCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = "select * from Cliente where [age] ? ?"; // Its here

var param1 = new OleDbParameter("@idade", OleDbType.Numeric); 

param3.Value = txtAge.Text;

cmd.Parameters.Add(param1);

cmd.ExecuteNonQuery();

DataTable dt = new DataTable();

OleDbDataAdapter da = new OleDbDataAdapter(cmd);

da.Fill(dt);

conn.Close();

dvgCons.DataSource = dt;