sita k

sita k

  • NA
  • 43
  • 52k

Adding two columns in listbox

Sep 16 2013 2:08 AM

Hello Everyone,
           
         I got two tables Table Employee : Eno , Ename ,Sal and Table Works_on :Designation Hours_Worked Eid.Now in a page I took a dropdownlist to combine ename and designation and I wrote the below query in datasource select e.ename,wo.designation from employee e,works_on wo where e.eno = wo.eid;

        Now the thing is that what should I specify in datatextfield and value field I want to get ename||designation.If I don't specify anything then I am not able to bind data.
 
        Is there any other way to do it.


    Regards,
    Sita.


 


 



 


 


 

    


 

 


Answers (4)