Hi all

I am passing a dataset to a dgv and i need to add a column to the DGV that is not in the dataset but is made from info in the dataset

example

col1
12
34
14
47

col0(<-add) col1
hyperlink12 12
hyperlink34 34
hyperlink14 14
hyperlink47 47


I also want to go through certain column's and remove some text

companyname/user
companyname/user2

to just:
user
user2


then the last thing i want to do is filter feilds by date or other criteria



So my question is

should i do this at the data table level or should i do it at the data grid level because i'm not sure i want to mess with the original data just yet

then depending on where i edit the data does anyone have a good example that i could look at to point me in the right direction?