hi ,
 in my project i m having one dropdownlstbox inthat it displays productid....
if i m selecting any value in the dropdownlistbox then the corresponding records values should be retrive from product table and it should be displayed in seperate textboxes...... it should be done with the help of sqldatasouce control can anyone help me...

jayakumar

Hi there,

Take a look here:

http://quickstarts.asp.net/QuickStar...atasource.aspx

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Hi there.. i understand your problem.. but think about this, if I select NY, how will the system know witch NY (NY1, NY2) I Select???? maybe you are seeing the problem in the wrong way??? please xplain a little more what are you trying to achieve (the whole idea)...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Hi, Imar, anyone,

Please help!
I have a project also. In my project I’ m having one dropdownlstbox in that it displays All distinct State, In the State table, there are NY1, NY2, NJ1, NJ2, NJ3 , CA1, CA2… I just want to show the ONLY different state, So I use:
Select distinct state from State,
then dropdownlstbox only show NY, NJ, CA, do not NY1, NY2, NJ1, NJ2, NJ3 , CA1, CA2 …
Then I want to show the details from specific state if i m selecting any satae in the dropdownlistbox then the corresponding records values should be retrive from State table and relationshop tables, But can not get them, Because each state has state1, state2, For example, selecting NY, NY including NY1, NY2…,
Please help!