tekk

tekk

  • NA
  • 101
  • 0

how to bind two sqldatasource in one gridview of two different columns

Mar 13 2010 5:03 AM
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


Answers (4)