How to divide the value in grid view by 1000000 and put a unit after it.

See more:

ASP.NET

I am retrieving data from SQL Server to a grid view in ASP.Net. Below is the grid view after I retrieved the data from the database.

Time   | City_1    | City_2   | City_3
02/12  | 30000000  |12000000  |55000000000
02/12  | 14000000  |1000000   |7200000000  

So I want the values in the grid view to be divided by 1000000(one million) and put "mil" after it. After dividing it, I also want to put a comma in every thousandth place of the remainder value for the ease of the user.
So my grid view will look like this after formatting.

Time   | City_1 | City_2  | City_3
02/12  | 30mil  | 12mil   | 55,000mil
02/12  | 14mil  | 1mil    | 7,200mil  

What I have tried:

Below is the code how I am retrieving the data from SQL Server to the grid view.

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();