How would YOU do it?

Question

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.

sunil · Answer

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