Searching Access Database based on Textbox choice
<pre><code>private void btnSearchDB_Click(object sender, EventArgs e)
    {
        OleDbConnection accessConnect = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\ECM\ECM\ECM\ECM.mdb");
        DataTable dt = new DataTable();
        OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM ECMeasurements WHERE [Job Number] LIKE " + txtJobNumber.Text, accessConnect);

        da.Fill(dt); 
        dataGridView1.DataSource = dt;



    }
</code></pre>

<p>There are also choices that can be searched by Date.....(txtDate.Text) and a comboBox (cbAlloyyTemper.Text). Do I write three different queries or can all the search criteria be together?</p>
