Display csv data into grid view using c#
I have a requirement where,I need to display comma separated values from database into gridview.(Not from a CSV file)
I have a table with KeyID,KeyName & KeyVal as columns.KeyVal column is comma separated value.
In the grid,KeyName & KeyVal should be displayed where comma separated values in KeyVal should be always falling in new row meaning
The user should be given an option to insert, update & delete these comma separated values in grid.
I am not using the basic gridview insert/update/delete options,meaning I am using buttons to perform these operations.I need help to get hold of the cell values of the gridview in these buttons so that I can edit,delete based on cell values.
The full code in C# with the aspx design will be highly appreciated.