title: Sorting Datatable according to number not alphabetically
body: <p>I have a datatable dt1:</p>
  
  <pre><code>Name Amount
  ----  -----
  A     10
  B     15
  C     5
  D     22
  E     16
  F     30
  G     31
  </code></pre>
  
  <p>In c# I want to sort the data based on Low to High or Log to High depending on user select in the drop down box. I am using this function but it always sort alphabetically like 10,15,16,22,30,31,5. Anyone can please tell me what should I use to sort data.</p>
  
  <pre><code>protected void ddlHotelAPISearchBoxSorting_SelectedIndexChanged(object sender, EventArgs e)
      {
          DataTable dt2 = new DataTable();
          dt2 = dt1;
  
          DataView dv = new DataView(dt1);
  
          if (ddlHotelAPISearchBoxSorting.SelectedValue == "Low_Price_First")
          {
              //dt2.DefaultView.Sort = "CalculatedPrice ASC";
              dv.Sort = "CalculatedPriceWithNoSymbol ASC";
          }
          else if (ddlHotelAPISearchBoxSorting.SelectedValue == "High_Price_First")
          {
              dv.Sort = "CalculatedPriceWithNoSymbol DESC";
          }
          else if (ddlHotelAPISearchBoxSorting.SelectedValue == "Best_Match")
          {
          }
          DataList1.DataSource = dv.ToTable();
          DataList1.DataBind();
      }
  </code></pre>