title: Replace the name of the cities with "City"
body: <p>I am retrieving data from SQL Server to a grid view in ASP.Net. Below is the header of the grid view after I retrieved the data from the database.</p>
  
  <pre><code>Time| Atlanta_1| Atlanta_2| Atlanta_3|
  </code></pre>
  
  <p>I want to replace the name of the cities with "City" dynamically e.g. </p>
  
  <pre><code>Time| City_1| City_2| City_3|
  </code></pre>
  
  <p>So basically I want to replace a part of the header with "City" and I want to do it while binding it in a grid view NOT in SQL Server. Below is the code how I am retrieving data from the database to my gridview</p>
  
  <pre><code>SqlConnection con = new SqlConnection("My Connection");
  
  string s = "My Stored Procedure";
  
  con.Open();
  SqlDataAdapter da = new SqlDataAdapter(s, con);
  DataSet ds = new DataSet();
  
  da.Fill(ds);
  
  gridView1.DataSource = ds;
  gridView1.DataBind();
  
  con.Close();
  </code></pre>