title: Data Reader trimming the leading zeros
body: <p>I have a string coming from a stored procedure looks like '001234567'. </p>
  
  <pre><code>sqlCommand = new SqlCommand("csp_Bbp_OBN_GetBasePageList", BBConnection);
  sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
  
   sqlCommand.Connection.Open();
  
  // Run the SQL statement, and then get the returned rows to the DataReader.
  accReader = sqlCommand.ExecuteReader();
  
   while (accReader.Read())
  {    
        BasePage basePage = new BasePage();
        basePage.GroupNum= accReader.GetValue(0).ToString().Trim();
        basePageList.Add(basePage);
        accReader.Close();
        accReader.Dispose();
  }
  return basePageList;
  </code></pre>
  
  <p>In my case, from the stored procedure I am returning the varchar, after executing and reading it I am getting the value to basePage.GrouNum which is a string. So, I don't see where it is trimming the leading zeros.</p>
  
  <p>Example: GroupNumber in the table is : "001234567"
  BasePage.GroupNum after reading from DataReader : "1234567"</p>
  
  <p>But, I do not want the leading zeros being trimmed.
  Can any one help me how to solve this problem?</p>