title: How to add text to asp:BoundField in GridView?
body: <p>I have the following GridView in which data is being fed from the <code>OleDB</code> Database.  </p>
  
  <pre><code>&lt;asp:GridView ID="GridViewSavingsTracker" AutoGenerateColumns="false" runat="server"&gt;
      &lt;Columns&gt;
          ...
          &lt;asp:BoundField DataField="interestRate" HeaderText="Interest Rate" /&gt;
          ...
      &lt;/Columns&gt;
  &lt;/asp:GridView&gt;
  </code></pre>
  
  <p>And I am reading the contents from the Database and printing in the GridView in the following manner: </p>
  
  <pre><code>protected void ShowGridView()
  {
      string connectionString = GetConnString();
      OleDbConnection con = new OleDbConnection(connectionString);
      con.Open();
      string sqlQuery = "select * from ... ";
      OleDbCommand showGridViewCommand = new OleDbCommand(showGridViewQuery, con);
      showGridViewCommand.ExecuteNonQuery();
  
      DataTable dt = new DataTable();
      OleDbDataAdapter olda = new OleDbDataAdapter(showGridViewCommand);
      olda.Fill(dt);
  
      GridViewSavingsTracker.DataSource = dt;
      GridViewSavingsTracker.DataBind();
  
      con.Close();
  
  }
  </code></pre>
  
  <p><strong>What I want to do:</strong> I want to append <code>%</code> symbol to the contents of interestRate column in the GridView such that they should be displayed as <code>3%</code> instead of <code>3</code>. But the % symbol should not be inserted into the Database. In other words, the <code>%</code> symbol should only be used for display purposes in the GridView.  </p>