population of data in dropdown list

[biswa47]

HI friendz, i have small problem...as u all helped me out in the past this time also expecting d same... well i have drop downlist in which i want to populate two coloumns of the table from Database "emp"(say the coloumns are firstname and lastname).what will be the respective code for it in c#.net ?

[John ph]

either you can concatenate the first and last Name at the stored proc level or you can do before binding it to the Dropdownlist (at the presentation level). try something like this while binding the data. LocalDataSet = SelectAll() ddl.DataValueField = "ID" ddl.DataTextField = "FirstName" + " " + "LastName" ddl.DataSource = LocalDataSet ddl.DataBind()

- Regards -
   JON

---

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

---

[Imran Khan Pathan]

concatenate firstname and lastname in sql query like as select firstname+ '' + lastname as name from emp now you can bind DataTextField with name

ddl.Datatextfield="Name"

bEst Regard pAthan

please don't forget to vote on the post that helped you.

[biswa47]

Thanks

[John ph]

biswa47 wrote:

Thanks

Welcome.

- Regards -
   JON

---

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

---