title: C# SQL query not returning anything
body: <p>I have the public DataTable here and the code looks right, but its not returning anything, the OrderID is correct, the query itself is correct, its not returning anything...can anyone tell me why?</p>
  
  <pre><code>public DataTable get_OrderTransaction_Master_ByOrderID(Int64 orderID)
      {
  
          cn = new SqlConnection(objCommon.IpcConnectionString);
          cn.Open();
  
          string query = "select transactionID from dbo.OrderTransaction_Master where orderID = " + orderID;
          SqlCommand queryCommand = new SqlCommand(query, cn);
          SqlDataReader queryCommandReader = queryCommand.ExecuteReader();
          DataTable dataTable = new DataTable();
          dataTable.Load(queryCommandReader);
          cn.Close();
          return dataTable;
  
      }
  </code></pre>