title: C# Oracle command Parameters add. How can I add part of the text itself into the command text?
body: <p>For example below is my code:</p>
  
  <p>ss.StoreNumber is string from user, store_no is int type in database.</p>
  
  <pre><code>string sql = "SELECT * FROM SALES_STATUS WHERE store_no = :SerchStore";
  //Creating cmd using sql and conn
  OracleCommand cmd = new OracleCommand(sql, conn);
  //Create Parameters to add value
  if (int.TryParse(ss.StoreNumber, out int n) == true)
  {
  cmd.Parameters.Add("SerchStore", int.Parse(ss.StoreNumber));
  }
  else
  {
  cmd.Parameters.Add("SerchStore", "store_no");
  }
  </code></pre>
  
  <p>Simple function, I want to create a SQL application, if user type in store number, then it will return the sales status by the store number.</p>
  
  <p>Otherwise, if user didn't type in anything or typed in any non-numeric information in the store number text box, then it should return information from all stores. </p>
  
  <p>I used below code:</p>
  
  <pre><code>cmd.Parameters.Add("SerchStore", "store_no");
  </code></pre>
  
  <p>because I want to make it into this Query, which is working in Oracle Develoepr:</p>
  
  <pre><code>SELECT * FROM SALES_STATUS WHERE store_no = store_no;
  </code></pre>
  
  <p>So my question is, what should I put into below "X" to make the query to be the query I want above? </p>
  
  <pre><code>cmd.Parameters.Add("SerchStore", X);
  </code></pre>