How to bind two table in gridview in asp.net

Question

i want to bind two table in gridview. The first Table has username userid mailidRoleid (int) are there and the second table has Roleid (int) and rolename ( varchar(50)) are there. first table roleid is foreign key and second table roleid is primary key. which is refffered by rolename and my expected result is user name from first table role name from second table and it should comes by dropdownlist how can i get this. if i edit my dropdownlist is grid means it should change the values in database can anyone give the code for me

Nitin Sontakke · Answer

I think you are looking at it from wrong angle. Look at it like this. You populate the drop-down list with the values from the second table rold Id and role names. Basically data-bind the whole table. Role Id goes as value member and role name goes as Display member. The user selects one of the values from the drop-down list. Then while saving you take user name (and other details) and role id (value member) from the drop-down list and save it in db.