how to edit column value before binding to gridview after retriving from database?
<p>After i retrieved a set of datatable from database, i need to edit the rows value before binding to the gridview.
for example, a set of datatable is retrived from database. </p>

<p>eg: [userid], [userEmail]  --> 1 , james@hotmail.com</p>

<p>i would like to change "james@hotmail.com" to "james" then bind it to gridview. 
Every rows of [userEmail] will be separated with the mail extension (@hotmail.com) ...
how should i do..?</p>
