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\'

i have tried to find the response in the whole net!! i wonder if we get the solution. if you do, pls post it okay.

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

try to move this line below to you Page_Load function:
textbox1.text=dropdownlist1.selectedvalue

well ndc550,
moving that line to Page_load also works, but i didn't wanted that as i have some text as the first item on drpdwnlst.

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

Do you want this to be performed with a post back or client side?

hi david,

well, i have performed this with as post back and all is working fine.
but i feel the client side would be much better as it would save a lot of time.
Is it possible ???
if u know then plz post again.

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

If you want to do this on the client side here is the code:

on page load add this code:
DropDownList1.Attributes.Add("onChange", "changeText(this.value,'" & TextBox1.ClientID & "')")

on the page add the following script
<script type="text/javascript">
  function changeText(value,oTextbox){
    document.getElementById(oTextbox).value = value;
  }
</script>

David Rodrigues
"There is no box"

thanx

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