how to bind two sqldatasource in one gridview of two different columns
hi friend,
Thanks for advance,
my quesstions:
1) how to bind two sqldatasource in one gridview of two different columns?
2) how to update the dropdownlist selected value into table?
here i briefly explain,
I have two columns of gridview. first time binding two columns data through label of one table [table1] , then when click edit button then one of column was convert into dropdwonlist that time dropdownlist data are binded from another table [table2] . finally updated the dropdownlist selected value into table1.
here my tables:
table1: table2:
jobid | jobtitle | recruitername recruiterid | recruitername
01 developer empy value 1 anil
2 arun
gridview format: [initial stage]
"jobtitle" "recruitername"
developer [empty value binded from table1]
gridview format: [click edit button stage]
"jobtitle" "recruitername"
developer [dropdownlist value binded from table2]
Thanks,
Tekk