GridView

Question

Hi Sir/mam,

 I m using Gridview in my web application. In my project my task is to retrieve one column from one table and show it in one gridview. As using Gridview I have retrieved data from Table 1 and Show in Grridview1. My task is as Operation is new column with dropdownlist. the values of Operation to stored along with new gridview 2 showing username alone. How to get username and insert query for operation field in gridview?


Eg: Table1:

Username	Status	DOB	EmaildId

Table2: 

username	Operation

I want The username of table1 in table2 and Operation values also. So both the values to stores as seprately as table2... can anyone help me?