title: Gridview with SQL data source is removing white spaces
body: <p>I have a <code>GridView</code> connected to my database through an sql data source. It is bound by the follow code:</p>
  
  <pre><code>    firstview = "SELECT ID, DC, DD, CYM, CB, ST FROM SCH_SCHEMANAME.TABLENAME WHERE CI = " &amp; txtboxvalue.text &amp; " AND ST = 'whatever' AND D = 0"
    SqlDataSource1.SelectCommand = firstview
          GridView1.DataBind()
  </code></pre>
  
  <p>There is no problem connecting to the database. Inside the database, one of the column contains extra whitespace. To make a long story short, the <code>DD</code> column is a short sentence that contains more than one space between some words. e.g. <code>"This_is____a_sentence_stored___in_the_____dd_column"</code> where each underscore is a space in this example.</p>
  
  <p>When I do the databind, the spaces in between the words are all reduced to 1 space. I do, however, need to keep the exact amount of spaces between each word when the data is bound in the <code>GridView</code>. At the moment, it is showing in the <code>GridView</code> as <code>"This_is_a_sentence_stored_in_the_dd_column"</code> but I want to keep the amount of spaces rather than have them automatically cut down.</p>
  
  <p>Can anyone help?</p>