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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Creating cascading dropdowns - Unable to add filter

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
Hi all ! I'm trying to learn about how to create cascading dropdowns.In fact I found good explainations, but something very weird is happening... When I click on the filter (using external datasource) a message like 'There is no support atr the web form of infopatrh 2007 for filter' (or something like this).Then the buttons to add, modify, etc appear disabled to me. Any hint, felas ?

View Complete Post

More Related Resource Links

Unable to select any stored procedure while creating TableAdapters in wizard


I'm using VS 2008 and SQL 2008.

I have created the tables and the stored procedures in SQL 2008.

In VS 2008, I created DataSet1.xsd in App_Code and created the connectionString in web.config file.

Then when I go into the DataSet1.xsd and try to add a TableAdapter, strange things happened.

First I chose the data connection, then selected "Use existing stored procedure", then there was nothing listed in the dropdownlists (in Select, Insert, Update, or Delete). 

I'm sure the connectionString is correct because if I choose "Use SQL statement" and type in a "select * from mytable1", the TableAdapter can be created without any problem.

Any suggestions?

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:



IP2003 cascading dropdowns w/SP2007

I'm new to IP.  My client base is IP2003 only on SP2007.  The forms have repeating data sections so web form is out of the question as I understand it. :(  

The forms are run on the clients local version off IP.  I would like to use a SharePoint list as the basis for some cascading drop downs.  Is that a realistic idea in IP as described? 

Displaying IDs in cascading dropdowns

Hi, I am using sharepoint RTM on windows server 2008 sp2, i have implemented Cascading dropdown scenario by reading the following blog: http://msdnvietnam.net/blogs/quang/archive/2010/03/30/cascading-drop-down-list-in-sharepoint-2010-using-infopath-2010.aspx I am having a problem that if i select the City Dropdown for the first time, then it works fine and cascading works fine but if i reselect (or select another city) then the value selected in District dropdown loads the respective items but the previous selection Id is also displayed. e.g, I select City1 from City DropDown, District dropdown shows District1 Name(ID = 1) and District2 Name (ID = 2) Then I select District2 Name then I select City2 from City DropDown, District dropdown shows "2" (District2 ID) and District3 Name and so on. Can anybody help me with this....

Unable to add filter to a sharepoint DateTime Column

Hi ,I have a DateTime column in  a List. When I try to create a view the column doesnt appear in the folter Column List.When i create a calculated column out of the DateTime Column, the new calculated column appears in the Filter Column ListCan any one explain why?ThanksSrila

Unable to filter the "E-mail To" field in email enabled document library

Hi, We have setup a few email enabled docuement libraries to store emails relating to project work. Is there a way to make the "E-mail To" field in the library be filtered? It is greyed out and doesnt give you the option. The "E-mail From" and "E-mail Subject" are able to have a filter applied to them but for some reason the "E-mail To" field wont let you filter the content. The probelm is that there are over 500 files in the library and the easiest way to find messages is to be able ot filter this column in the library if it is at all possible.

infopath 2007 cascading dropdowns



Can anyone suggest me the Infopath cascading dropdowns. I need to create one form ...it will have 3 dropdown and based on the users selection in the first dropdown 2nd dropdown should display only one item (out of 3 standard items..users dhould see only one item int he dropdown). based on the user's selection wrd dropdown should show 2 items (out of 5 standard items....users should see some items only based ont he first dropdwons selected value). Can anyone one suggest how to accomplish this?. Thanks in advance to all.

Cascading dropdowns without JavaScipt/jQuery


I have 2 dropdown's in my form in a view.  (Countries and regions)

Obviously I need the regions dropdown to change it's content whenever the countries list have been change.

However, I do NOT want to do this with any dependancy on JavaScript.

Did not do webforms for years, but remember one let the dropdown postback the form.  I dont think it work like this in MVC, as posting my form will force validation to kick in to easy, and the user see a lot of "error messages" just because they are selecting their country and region?

Any advice / tips / links?

Problems with creating a set or filter



I have a cube with several measures in it. I also have 2 time dimensions called Repoting Date (RD) and Business date (BD). The reporting date dimension is pretty small only containing the dates as the end of the month. The business date dimension is a normal time dimension on day basis.

Now I want to create a set  or filter where the reporting date is the same as the business date. And that should apply to all measures.

So I should get (BD.Date.2010-01-31, RD.Date.2010-01-31), (BD.Date.2010-02-28,RD.Date.2010-02-28)

Any thoughts on this one ?



unable to connect to sqlserver while creating my account using VS2010 proffessional in WIN 7 home pr



I am getting  an error while  debug my application that unable to connect SQL server......The message is...


 at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString)
   at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)
   at System.Web.Security.SqlRoleProvider.RoleExists(String roleName)
   at System.Web.Security.Roles.RoleExists(String roleName)
   at BusinessApplication4.Web.UserRegistrationService.CreateUser(RegistrationData user, String password) in C:\Users\Balakrishna\documents\visual studio 2010\Projects\BusinessApplication4\BusinessApplication4.Web\Services\UserRegistrationService.cs:line 51
   at CreateUser(DomainService , Object[] )
   at System.ServiceModel.DomainServices.Server.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
   at System.ServiceModel.DomainServices.Server.DomainService.Invoke(InvokeDescription invokeDescription, IEnumerable`1& validationErrors)
   at System.

Cascading Dropdowns Reload on Event Trigger



I have three cascading dropdowns and two of them need to trigger something outside of the dropdowns, so I have OnSelectedIndexChanged events on them.  So as to not reload the whole page when these items are triggered, I have all of this in an Update Panel.

Everything works fine -- the only issue that the client doesn't like is that the cascading dropdowns reload on the asynchronous postback.  Can you think of any way to avoid this?


Calendar View: Unable filter Recurring Event by Start/End Time and Group by Recurring Event View

Hi All,
I have just found several issues with Calendar View from WSS 3.0:

Unable to filter by [Start Time] and [End Time]
I am not sure why these 2 columns doesn't appear in the Filtering column in the View Settings. The workaround found in the internet is to create calculated column for Start Time and and End Time. However, it doesn't work for Recurring Event, the calculated column will show only first recurring event Start Time.

Unable to use "Group By"
When I create new view in Calendar using format: "Standard View, with Expanding Recurring Events", there is no option to specify "Group By". Anyone knows how to show all recurring event in List view and grouped by Start Time (or any other column).

Thank you and apprecate for any idea.

Unable to Clear Filter on SharePoint List


Hi all,

  How on earth do we clear the radio button filter that appears along side a list webpart thats providing its row via connections to another list.

 Here is my scenario:


 List 1 : Col 1 , Col 2 , Col 3

 List 2:  Col A, Col 1, Col B

 I have Connected 'List 1' to 'List 2' with List 1 providing a row to List 2, and configured to match it by 'Col 1' . In page the filter works fine.

 But once selected the selection remains and there seems to be no way of clearing the selection .....even on refreshing the page or navigating away and returning to the page.....the filter doesnt go... any suggestions ?


 How to get an option like Clear selected Filter, or Show All ...



Still issue with Cascading Dropdowns


I have looked at the post on http://www.dotnetcurry.com/ShowArticle.aspx?ID=221 and got this to work somewhat.  I have 2 fields just like the example.   One is Location and the other is Lab.  I can have multiple locations, and within the locations, multiple labs for each location.  So when I select a Location, I want to show all labs for that location.  This part works.  But when I click Update, I the Lab value is not getting written back to the database.  I suspect it is because I dont have a SelectedValue='<%# BIND' but when I add one, I get an error.  Also, in the example post above, he does not have one either. 

The code for the Lab field is below.  What am I doing wrong.  This cant be that difficult. 



<asp:TemplateField HeaderText="Lab" SortExpression="LAB">
                            <asp:DropDownList ID="gvLABS_DROPDOWN" runat="server" DataSourceID="SqlDataSource8"  

Adobe I-Filter creating thousand of folders on system root.


I have adobe's v9 ilfilter installed with Sharepoint 2010 on a windows server 2008 r2 box. Indexing seems to working fine and pdf results are returned in a a sharepoint search.  My problem however is that thousands of directories are being created on the C:/ drive beginning with "A9R" followed by a bunch of numbers and letters with legitimate pdf documents (with normal documents names) inside. I read about a similar issue here http://forums.adobe.com/thread/707241?tstart=1 and here http://blogs.adobe.com/acrobat/2008/12/adobe_pdf_ifilter_9_for_64bit.html (about half way down the page). No one seems to have a solution let alone an explanation. Even more scary, is that I cannot seem to find any of these documents anywhere else.


Dynamic Data Foreign Key Filter - how to limit the # of dropdowns on the list view



I have a visual basic website in VS 2010 framework 4, linx to SQL, with scafolding.... and this dataclass has about 10 foreign key fields, of which all 10 are shown in the list view of the website.  I want the ability to exclude those filters from the list view (or exclude some and keep some), but without eliminating them from the edit forms.  Using <scafoldingcolumn("False")> does the trick to remove them entirely but that will also remove them from the grid/list itself, which I don't want, and remove the column from the edit record views, which I don't want either.

Any help would be great!!!!

Add rows dynamically to a table and poulate data in cascading dropdowns

hi,I am using ASP.NET3.5,
I want to Add rows dynamically to a table.I am using masterpage in my .aspx pages.
I have written the following code code.This code is working fine.
but I need to load data in dropdownlist2 dynamically based on another dropdownlist1.and i need to do few calculations based on table data.
but how can I do using  javascript/jquery/Ajax ??
can i do all my calculations using these html controls?

1  dynamically Add rows to table.(which doesnt give burden to server)
2  need to use cascading dropdowns (like Country,States,villages )
3  Have to do some calculations (like Tax calculations based on table data)
4  Have to enable/disable few controls base on input data of dropdowns and textboxes.

    <TITLE> Add/Remove dynamic rows in HTML table </TITLE>
    <SCRIPT language
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