.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Imran Ghani
Post New Web Links

Multiple Cascading Drop Down Lists - Browser

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#
 

Hi

We have a requirement to implement quite a complex cascading drop down list solution. I am aware that there are numerous articles on how to do this however I would like to confirm if it is possible to achieve the following:

1. A drop down list with multiple selections for field A. User selects field A.
2. Field B is automatically populated based on field A which was selected above.
3. A filtered drop down list appears for field C. This filtered drop down list is based on field A & B which was previously selected. User selects field C.
4. Field D is automatically populated based on field C which was selected above.
5. Field E is automatically populated based on field C which was selected above.
6. Field F is automatically populated based on field C which was selected above.

My programming skills are very limited and how I would ideally like to connect the form to a list in SharePoint so that the values can be easily maintained. We are using a browser form and would appreciate any ideas or suggestions on how to create the above functionality. Just out of interest, The custom drop down list for field C will probably have 100 values and overall we have about 5000 records which need to be autopopulated and filtered.

Thanks for any help
Tony

 




View Complete Post


More Related Resource Links

cascading drop down list in infopath forms services Using SharePoint Look up list from multiple Sh

  

Hi 

Some one can help me, if possible screen shots.
Environment : MOSS 2007, InfoPath 2007

cascading drop down lists from single table

  

my one table consists of fields (id, flying from, flying to). thus i have one drop down for flying from and another drop down for flying to. i'm hoping to cascade them so 2nd drop down values are dependant on the values from 1st drop down. is it possible to do this using a single table? or must i use two tables and link the id's from both? and do i write anyting in the SelectedIndexChange event? thanks...

the sqldatasource code looks like this:

Flying From:

        <asp:DropDownList ID="ddlFlyingFrom" runat="server" DataSourceID="SqlDataSource1"
            DataTextField="FlyingFrom" DataValueField="Id" AutoPostBack="True" OnSelectedIndexChanged="ddlFlyingFrom_SelectedIndexChanged">
        </asp:DropDownList>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>"
            SelectCommand="SELECT [Id], [FlyingFrom] FROM [Flights]"></asp:SqlDataSource>
      &nb

Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

  
Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Issue in Infopath 2007 browser form - cascading dropdown using owssvr.dll filter view

  

Referring the below link, I created a cascading dropdown. The parent dropdown has sharepoint list as datasource and the child dropdown has xml datasource that points to owssvr.dll filter view. The cascading drop down works fine in preview but throws error after publishing as admin approved form - "form cannot run the specified query" exception when trying to execute xml datasource i.e., when a value is selected in parent dropdown. The security is 'Full Trust". In the event viewer the error message states "401 unauthorised" for the user a/c. the xml data source is an approved udcx file and in central admin, have enabled cross domain for infopath service. I have tried different solution provided in tech forums but issue still exists. Not sure whether Im missing something. Can someone guide me in fixing this issue?

Link Reffered:

http://www.bizsupportonline.net/browserforms/filter-cascade-drop-down-infopath-sharepoint-browser-form-owssvr-dll.htm

http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html


Create a placeholder for drop down lists

  

First time post here, if i'm in the wrong area please move as necessary. Thanks

I'm using VWD with a database back end. I have a list of teams which are marked off by league, level, division, teamid and then using gridview for the list of players per teams.


I've got the drop downs working correctly but running into a little snag and that is on the auto postback.

When I only have one option come up in a list, i obviously don't change that list and thus it doesn't change the next drop down because there is no post back. is there a way to use a "header" value?

Example of my data

League Level Division Team

NHL 1 West Vancouver
NHL 1 West Calgary
NHL 1 West Edmonton
NHL 1 Central Chicago

OHL 2 West London
OHL 2 West Guelph

NBA 1 Central Chicago
NBA 1 Central Detroit
NBA 1 Central Milwaukee

So my drop downs choose by league, then level then division and then team then shows the player roster for that selected team.

The problem I run into is when only one value exists based on the previous choices I've made. If I choose NHL then Central only Chicago shows up in the example above. Because I'm not choosing between it and another value, the drop down does not put in a post back and thus I don't get a list of the team and then the players

Quick Note: Accessing Multiple SharePoint 2010 Lists by Using LINQ

  
In this exercise, you develop and deploy a visual Web Part that reads data from three lists by using LINQ queries and displays the results in a grid view control.

Ajax Cascading drop down method error 500!

  

Sorry to trouble you all with something that has already been posted a million times but I have tried everything I can and stuck with for about 10 days now. Please help. I have created 2 tables Categories, Subcategories.

Categories table has Category_ID(Primary Key) and "Category" fields. Subcat table has SubcatID(Primary Key, Sub_cat and Category_ID(Foreign Key). Here's the code of the asmx file.

Service methods used in ASPX file ServiceMethod="GetVendors" and ServiceMethod="GetContactsForVendor". Please help me find the source of the method erro 500 and I will be very greatful.



<%@ WebService Language="VB" Class="CascadingDropdown1" %>


Imports System.Web.Script.Services

Imports AjaxControlToolkit

Imports System.Web

Imports System.Web.Services

Imports System.Web.Services.Protocols

Imports System.Collections.Generic

Imports System.Collections.Specialized

Imports System.Data.SqlClient

<ScriptService()> _
Public Class CascadingDropdown1
Inherits System.Web.Services.WebService

<WebMethod()> _
Public Function GetVendors(ByVal knownCategoryValues As String, ByVal category As String) As Cascadi

How can I Set default value for drop down list filled with Cascading

  
Hi AllI've this problem, how can I set the default value for drop down list filled with cascading. I can't catch the event that came after cascading to set the default value and I can't call any control in this function:  "AjaxControlToolkit.CascadingDropDownNameValue[]"   I've passed the Drop down list as a session and the default value in session   When I call the session of "Drop Down List" the session value Is NULL in this function:  "AjaxControlToolkit.CascadingDropDownNameValue[]"   Any help please. 

how do i develop a cascade drop down lists which get the chart names from excel sheets

  
hi i have to develop a cascade dropdownlist. one of the drop down is used to retrive only excel docs from a specific doc library and and the other drop down to get all the chart names and attach it to the second dropdown list in doc lib item changed event thanks    

Cascading drop box holds old value if empty on auto post back

  
I have 3 drop boxes: 1.) Choose Operation 2.) Choose Site 3.) Choose Area. All three of them are linked to an SQL server database which has 3 tables following the same heiarchy of order. I.e. Areas belong to a Site and Sites belong to an operation. And there can only be one operation per site, or one site per area. First you select an operation, then the page auto postbacks to filter the sites. Then you pick a site and again it autopostbacks to filter the areas. The issue I am having is that when an associated operation has no sites underneight it, and therefore no areas under that, the previous values that were in the boxes are displayed and the user can't click on the boxes anymore. I think this is kind of cheap looking and would like a way to make it so the boxes are clear (i.e. nothin in them). Is there anyway to check if they are going to freeze like that and assign them blank values??Any suggestions on this issue would be greatly appreciated!-Jordan

Connect multiple lists

  
Hi, I have a list "List1" with column let's say "A". I have 4 more lists List2,List3,List4,List5 with different columns. Once an item is created in List1, another item will be created in all the other lists. My requirement is to connect all these lists some how may be I can use column "A" from List 1. I know look up column works but I guess it is only one way. I need to be able to navigate from one list to another ex. If I use look up column, then I can navigate only one way from List1 to List2. I need to also navigate from List2 item to List1item. Please let me know a possible solution. Thanks in advance. I am using MOSS 2007 standard edition.

Connect multiple lists

  
Hi, I have a list "List1" with column let's say "A". I have 4 more lists List2,List3,List4,List5 with different columns. Once an item is created in List1, another item will be created in all the other lists. My requirement is to connect all these lists some how may be I can use column "A" from List 1. I know look up column works but I guess it is only one way. I need to be able to navigate from one list to another ex. If I use look up column, then I can navigate only one way from List1 to List2. I need to also navigate from List2 item to List1item. Please let me know a possible solution. Thanks in advance.   I am using MOSS 2007 standard edition.

Autopostback on the last list in a Cascading drop down list series

  
Hi,First off I'm very new to Ajax for .NET.  I have a Cascading drop down list that is working fine to load the correct lists however I would like to have the last one initiate a query and display a datagrid on the same page containing the results of the query.  Without Ajax involved this seems rather easy by using autopostback on the drop downs.  If I could do it through Ajax that would be great but I can settle with having the page to reload to display the data.  Right now I'm not sure how to do either.  I enabled autopostback on the last drop down and wrote a method for it but I get an error at runtime saying:Invalid postback or callback argument So I'm really not sure what to do to get this to work right.Any help would be appreciated.Thanks,-Jordan

search on multiple lists

  
Team, I have a situation where i have to do a search on multiple lists at once. List A - Field A, Field B List A - Field A, Field C List A - Field A, Field D When a user searches by Field A i want to pull all records from all lists. How do i present it after u have done the search. What web parts should i use? Is is possible to search on multiple lists. How to do it through designer? Do i need to a roll up view and search on it. If its possible.. Should i do join of lists and try to filter it based on FIELD A? Can we filter on joined lists? Any ideas on this .... Thanks a lot in advance.      

Browser enabled - Use One Drop Down List for Mutliple Drop Down List

  
I kind of have a cascading drop down, but I cannot figure out how to make filter all the other drop down list. I have seen this URL http://blueoceansassociates.wordpress.com/2008/11/19/cascading-drop-downs-in-infopath-web-forms-made-easy/, but is there a way to use only one Drop Down List as the dataconnection for all other drop down list. I have one drop down that needs to associate with 3 others. All 4 list point to a Sharepoint Secondary Data Source. Each drop down list is associated with the first drop down list choice. I have not seen this out on the web. Thanks for your response. chrisdoran

help with drop down lists

  
Hello i have 4 ddl for factory, category, model and engine im tryin to make connection between them so i could select factory and then the other ddls will change the data that relative to the select item on factory. I know how to make connection between them but i need to use AppendDataBoundItems so the user could select "all models" or "All categories" without success!!! when i select factory the category get the models and when i select different factory the new model join the other factory models and so on and on. i was try with ajax cascading ddl but i didnt success cause the user need to have the change to select factory and engine (for example) but the engine is enabled = false until the user select 3th ddl PLEASE HELP

Select multiple controls on tabpage, Drag & Drop control(s) (WinForms)

  

I'm wondering, if somebody got some code or thoughts for selecting multiple control displayed on tab page and drag & drop control on tab page it self. Something like on windows desktop, where you can draw a rectangel with mouse cursor to select folder and files. Also, drag folder or files to different location.

Thanks.

 


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend