could change the column names inside the DataTable before binding:
var ds = GetDataSet();
foreach(DataColumn col in ds.Tables[0].Columns)
{
col.ColumnName = col.ColumnName.Replace("Atlanta_", "City_");
}
gridView1.DataSource = ds;
gridView1.DataBind();