How would YOU do it?

Please help me with an idea. I have a dynamically populated datagrid with 3 sortable columns: Last Name, First Name, Age. I need to add another column '#' which values will never change even if user sorts by other columns. Example: # Last Name First Name Age 1 Doe John 29 2 Loe Joe 28 3 Moe Jerry 35 Now, if user sorts by age, this is what I want the output to be: # Last Name First Name Age 1 Loe Joe 28 2 Doe John 29 3 Moe Jerry 35 See, only 3 columns get sorted. Column "#" is ALWAYS the same. Number of people is always different, depending on the company. What would be the easiest way to accomplish this. Thank you all in advacne.

If you are populating your datagrid by way of a datatable it is quite easy. Take a look at the following example. Your # column is "SL.No" in the following datatable structure. public void LoadDataGrid() { // Create First column. ds=new DataSet(); myDataTable = new DataTable(); myColumn = new DataColumn(); myColumn.DataType = Type.GetType("System.String"); myColumn.ColumnName = "SL No"; myDataTable.Columns.Add(myColumn); } void FillData() { sql = "select * from event"; drevent = objSql.ExecRetDR(sql); int slno=1; while (drevent.Read()) { myRow = myDataTable.NewRow(); myRow["SL No"] = slno; myRow["FirstName"] = drevent["firstname"].ToString(); myDataTable.Rows.Add(myRow); slno +=1; } ds.Tables.Add(myDataTable); DG.DataSource = ds; DG.DataBind(); }