title: Default parameters if textBox is empty
body: <p>I have this to filter the table.      </p>
  
  <pre><code>using (SqlConnection myDatabaseConnection = new SqlConnection(myConnectionString.ConnectionString))
              {
                  myDatabaseConnection.Open();
                  using (SqlCommand mySqlCommand = new SqlCommand("Select * from Employee WHERE EmpID &gt;= @from  AND EmpID &lt;= @to", myDatabaseConnection))
                  {
                      mySqlCommand.CommandType = CommandType.Text;
                      mySqlCommand.Parameters.AddWithValue("@from", textBox1.Text);
                      mySqlCommand.Parameters.AddWithValue("@to", textBox2.Text);
                      {
                          ds = new DataSet();
                          adapter = new SqlDataAdapter(mySqlCommand);
                          adapter.Fill(ds, "Employee");
                      }
                  }
              }
  </code></pre>
  
  <p>For example I have <code>4001</code> in textBox1 and <code>4017</code> in texBox2. I gives me the result of <code>4001</code>,<code>4002</code>,<code>4003</code> . . . <code>4017</code></p>
  
  <p>The problem is for example I <code>4001</code> in textBox1 and none in textBox2 it gives no result. How I will do it to have a result from <code>4001</code> until to the last value of the table? And if the textBox1 is empty and textBox2 is <code>4017</code> , the result will be 1,2,3 up to 4017 assuming that 1 have the least value?</p>