Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET 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 April 20th, 2005, 05:11 AM
Registered User
 
Join Date: Feb 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dyanmic access of database

hi

i use two dropdownlist in my form. i need to display the details in the 2nd dropdownlist based upon the selection made in dropdownlist1.



Thanks,

Venkat

Strength is Life, Weakness is Death

- Swami Vivekananda
 
Old April 20th, 2005, 05:22 AM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Usually this is done by filling the 2nd DDL in the onChange handler for the 1st.

-Peter
 
Old April 20th, 2005, 05:45 AM
Authorized User
 
Join Date: Feb 2005
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to ashokparchuri Send a message via Yahoo to ashokparchuri
Default

hi..

   in the datagrid_onitem changed event just write your code to display the values in the dropdownlist.

     like if ur getting the dropdomlist values from database then u have to write the program(connection to db,retriveing data) in dropdownlist_onitemchanged event

   hope it helps...-Ashok Parchuri

 
Old April 20th, 2005, 06:20 AM
Registered User
 
Join Date: Feb 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

  Thanks for ur kind info. but i'm using two DDL's separately in a form not in datagrid. is there any way to do that

Thanks,

Venkat

Strength is Life, Weakness is Death

- Swami Vivekananda
 
Old April 20th, 2005, 08:30 AM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

You can do this as I described whether or not the DDLs are in a datagrid. The technique is the same. Where you put the code that loads the data depends on where your controls live.
 
Old April 20th, 2005, 11:40 PM
Authorized User
 
Join Date: Feb 2005
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to ashokparchuri Send a message via Yahoo to ashokparchuri
Default

hi...

  i am sorry actually i thought to write dropdownlist insted of datagrid.here i am giving the modification.

     in the dropdoenlist_onitem changed event just write your code to display the values in the dropdownlist.

     like if ur getting the dropdomlist values from database then u have to write the program(connection to db,retriveing data) in dropdownlist_onitemchanged event

   hope it helps...-Ashok Parchuri





Similar Threads
Thread Thread Starter Forum Replies Last Post
Access database database format itHighway Access 0 February 24th, 2008 06:34 PM
Dyanmic Page Break in Reporting Servies kdineshbabuct BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 February 5th, 2007 04:04 AM
Remote access to an Access Project Database bright_mulenga Access 0 February 9th, 2006 10:51 AM
Access issues with ASP and a MS Access Database rj_conceptsnrec.com Classic ASP Databases 2 May 19th, 2005 12:44 PM
dyanmic and not so dynamic... (page breaks) schaar Classic ASP Basics 12 December 17th, 2004 08:46 PM





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