thanks Pavan,
It works fine.

Jeby

-----Original Message-----
From: Pavankumar T [mailto:PavanKumar.T@k...]
Sent: Thursday, July 18, 2002 2:40 PM
To: ASPX_Professional
Subject: [aspx_professional] RE: retrieving runtime value


Hi,

1) First you set the listbox property Autopostback=3Dtrue
2) Put the below code in on Select change function of a list box.

	 Dim paramcount As SqlCommand
        paramcount =3D New SqlCommand("select Sub_Ledger_flag FROM
General_Ledger where GL_Code =3D" & "'" & listbox.selectedItem.value & 
"'"
& "
", mobjCommon.gConn)
        Dim rec_count As Boolean =3D paramcount.ExecuteScalar()
        textbox.text=3D rec_count

Hope this helps you



-----Original Message-----
From: jeby [mailto:jeby@c...]
Sent: Wednesday, July 17, 2002 1:53 PM
To: ASPX_Professional
Subject: [aspx_professional] retrieving runtime value


Hi,
Can someone tell me how to obtain a corresponding value of another into
a text box on runtime??

okay!! let me explain!

I have two fields (id, rate)  in the table and I am populating one of
them (id) into a dropdown list using a data reader . Now when i select a
particular id in the drop down list, I want the corresponding rate(of
that specific id) to appear in another text box without submitting the
page. I used to do this using XML in ASP.

Best Regards,
Jeby George
COMPUSOL Software Pvt. Ltd.