The code you have in the latter code block seems like a good start. what you're missing is creating and setting the value of a parameter. In other words something like
OleDbDataAdapter da = new OleDbDataAdapter("Select * from [Customer Orders] Where [Order ID] = @OrderID", MAcon);
da.SelectCommand.Parameters.AddWithValue("@OrderID", PrdtID.Text);
DataTable dtbl = new DataTable();
da.Fill(dtbl);