i hav' a drpdwnlst and a textbox on my page. there is a table in sql server 2000 tat contains 2 columns, they are an ID column and a NAME column(the ID column is the Primary Key). the drpdwnlst displays the data from the NAME column using SqlDataSource1. the querystring in sqldatasource1 is the select query for the NAME column.
Now wat i want is, when a particular NAME is selected from the drpdwnlst then the ID for tat particular NAME should be dislayed in the textbox control. Can anyone plz share ur knowledge if u know how to achieve this ???

THANX in ADVANCE

__________________
--------------------------------------------------
therez nothin\' as impossible, bcaz the word itself says : \'i\'-\'m\'-\'possible\'

in the SelectedIndexChanged event of your dropdownlist, set the text of your textbox to dropdownlist.SelectedValue

In select Query from datasource select ID and Name..from TABLENAME
Set Dropdown Value Field as ID and Text Field as Name..
so when Name is selected
Then set textbox value to dropdown selected.value...

HTH,
Vivek

 well, i've got it!!!
select both NAME and ID columns in SqlDataSource1,
then set the DataTextField property to the NAME column,
and DataValueField property to ID column.
After that in SelectedIndexChanged Event set the textbox1.text=dropdownlist1.selectedvalue.
also u have to enable the postback of dropdownlist to TRUE

Thanx a lot guyz