title: InvalidCastException: Unable to cast object of type 'System.Decimal' to type 'System.String'
body: <p>I am attempting to get the sale price from a table and put it into a text box. On my table the sale price is a Decimal variable, and of course the text box is string.. When I run this, there is an exception that is stopping it in my Data Access Layer. </p>
  
  <p>Here is some code:</p>
  
  <pre><code>textSellPrice.Text = DAL.Util.getSellPrice(listItemsPricing.SelectedValue.ToString());
  
  
  public static String getSellPrice(string item)
  {
      string sql = "SELECT Price FROM Item it INNER JOIN Customers cu 
          ON it.SalesRep = Cu.SalesRep WHERE CustomerID='" 
          + HttpContext.Current.Session["SelectedCustomer"] +
          "' AND ProductID='" + item + "'";
      string dt = AdoUtil.GetDataColumn(sql);
      return dt;
  }
  
  
  
      public static string GetDataColumn(string sqlQuery)
      {
          string result = String.Empty;
          try
          {
              SqlCommand cmd = new SqlCommand(sqlQuery, GetACESConn());
  
              if (cmd.Connection.State != ConnectionState.Open)
                  cmd.Connection.Open();
  
              SqlDataReader reader = cmd.ExecuteReader();
  
              if (reader.HasRows)
                  while (reader.Read())
                  {
                      result = reader.GetString(0);
                  }
  
  
              if (cmd.Connection.State != ConnectionState.Closed)
                  cmd.Connection.Close();
  
              return result;
          }
          catch (Exception ex)
          {
  
              return result;
          }
      }
  </code></pre>
  
  <p>So is there something completely obvious that I am missing?<br>
  Thanks for any helpful insight to this, and if any other code could be of use, I can provide it. Thank you</p>