Wrox Programmer Forums
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 19th, 2007, 03:08 AM
Registered User
Join Date: Mar 2007
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to imjayakumar
Default sqldatasource

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...

Old May 19th, 2007, 03:31 AM
Imar's Avatar
Wrox Author
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

Hi there,

Take a look here:



Imar Spaanjaars
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.
Old May 21st, 2007, 01:41 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi

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)...



================================================== =========
Read this if you want to know how to get a correct reply for your question:
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
================================================== =========
I know that CVS was evil, and now i got the proof:
================================================== =========
Old May 21st, 2007, 01:56 PM
Registered User
Join Date: May 2007
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

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!

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQLDatasource cymerman ASP.NET 1.0 and 1.1 Basics 1 February 28th, 2008 12:38 AM
sqldatasource imjayakumar Crystal Reports 0 May 19th, 2007 03:12 AM
sqldatasource imjayakumar ASP.NET 2.0 Professional 0 May 19th, 2007 02:58 AM
CheckBoxList and SqlDataSource extendedram ASP.NET 2.0 Basics 2 June 8th, 2006 02:54 PM
SQLDataSource bmains ASP.NET 2.0 Basics 1 December 19th, 2004 09:12 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.