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.