my cascading dropdown boxes. Eveything works I just need to remove the duplicates from the States and Cities drop down box. Any idea how? I got it to work on the Country drop down but can't figure out the rest.
private void FillCountry()
{
DataSet ds = (DataSet)Cache["InfoToFilter"];
[code]...
I'm trying to follow this article on cascading dropdown list in a GridView control in edit mode (except I'm using C#) [URL] I keep getting this error message "ProjectID is neither a DataColumn nor a DataRelation for table DefaultView."
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)
{
DataRowView dv = (DataRowView)e.Row.DataItem;
//// Preselect correct value in Projects list
DropDownList listProjects = (DropDownList)e.Row.FindControl("DropDownList1");
listProjects.SelectedValue = dv["ProjectID"].ToString(); // *****************this is where I get the error *********
// Databind list of categories in dependent drop-down list
DropDownList listCategories = (DropDownList)e.Row.FindControl("DropDownList2");
SqlDataSource dsc = (SqlDataSource)e.Row.FindControl("sdsDDL2");
dsc.SelectParameters["ProjectName"].DefaultValue = dv["ProjectName"].ToString();
listCategories.DataBind();
listCategories.SelectedValue =(dv["CategoryID"].ToString());
}
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>" SelectCommand="SELECT
TE.TimeEntryID,
P.ProjectName,
CAT.CategoryName,
TE.TimeEntryDescription,
TE.TimeEntryDuration,
TE.TimeEntryDate
FROM dbo.aspnet_starterkits_TimeEntry TE inner join
dbo.aspnet_starterkits_ProjectCategories CAT on
TE.CategoryID=CAT.CategoryID inner join
dbo.aspnet_starterkits_Projects P on
CAT.ProjectID=P.ProjectID
Where TimeEntryUserID=(SELECT UserId FROM dbo.aspnet_Users WHERE
UserName=@UserName) AND
TE.TimeEntryDate=@WeekEnding
" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE dbo.aspnet_starterkits_TimeEntry
SET
TimeEntryDescription=@TimeEntryDescription,
TimeEntryDuration=@TimeEntryDuration,
TimeEntryDate=@TimeEntryDate
WHERE
TimeEntryID=@original_TimeEntryID">
<SelectParameters>
<asp:ControlParameter ControlID="UserList" Name="UserName"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="WeekEnding2" Name="WeekEnding"
PropertyName="Text" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="TimeEntryDescription" />
<asp:Parameter Name="TimeEntryDuration" />
<asp:Parameter Name="TimeEntryDate" />
<asp:Parameter Name="original_TimeEntryID" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" BorderWidth="0px"
BorderStyle="None" Width="100%" CellPadding="2" PageSize="25"
DataKeyNames="TimeEntryID" onrowdatabound="GridView1_RowDataBound"
onrowupdating="GridView1_RowUpdating" >
<Columns>
<%--<asp:CommandField ShowEditButton="True" />--%>
<asp:BoundField DataField="TimeEntryID" HeaderText="ID"
SortExpression="TimeEntryID" InsertVisible="False" ReadOnly="True"
ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="Project" SortExpression="ProjectName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="sdsDdlProjectsEdit"
DataTextField="ProjectName"
DataValueField="ProjectID"
AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDdlProjectsEdit"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT ProjectID,ProjectName FROM dbo.aspnet_starterkits_Projects">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("ProjectName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList2"
runat="server"
DataSourceID="sdsDDL2"
DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDDL2"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT CategoryID,CategoryName FROM dbo.aspnet_starterkits_ProjectCategories WHERE ProjectID=@ProjectID">
<SelectParameters>
<asp:Parameter Name="ProjectID" />
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:BoundField DataField="TimeEntryDescription" HeaderText="Description"
SortExpression="TimeEntryDescription" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="TimeEntryDuration" HeaderText="Hours"
SortExpression="TimeEntryDuration" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField ApplyFormatInEditMode="True" DataField="TimeEntryDate"
DataFormatString="{0:d}" HeaderText="Week Ending"
SortExpression="TimeEntryDate" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:CommandField ShowEditButton="True" HeaderText="Edit" ButtonType="Image" EditImageUrl="images/icon-edit.gif"
UpdateImageUrl="images/icon-save.gif" CancelImageUrl="images/icon-cancel.gif" />
</Columns>
</asp:GridView>
Have spent hours trying to create a Dynamic Data Field Template holding a DropDownList which is extended by the AJAX Cascading DropDown extension.Final form holds multiple cascading dropdown boxes. User selects Country (Land) then Postcodes, Counties (Provincie) are populated. Once postcode is selected then towns (Plaats) are populated. The problem I am now facing is that the viewstate for the dropdown lists is not being saved/restored after an insert action or custom validation error. So basically the dropdown lists are being reset to their default values.Some code (if missing parts, just ask and I will post them) - Don't mind the code structures etc... needs some refactoring :)Attribute I created:
[Code]....
KlantMetaData (=> Klant is Dutch for Customer ):
[Code]....
DynamicDropDownList Control I created:
[Code]....
Dynamic FieldTemplate created for inserts:
[Code]....
EntityTemplate I created:
[Code]....
Webservice methods created:
[Code]....
Code in masterpage:
[Code]....
i use cascading dropdown lists (in a user registration form) and when the user hits the submit button i get the error: "Invalid postback or callback argument" I've seen on the net that this is a problem dating back many years but still haven't found a solution to this. I've read about changing EnableEventValidation to false, but this poses a security risk.
View 2 RepliesI don't want to link my dropdownlists with a database like most of tutorials and forums show. I just want to link 2 dropdownlists, for instance if one says "Food" I want to show only the food producs in the other DropDownList. All this items are not from a database, I just inserted them in the DropDownList control.
View 9 RepliesI have 3 dropdown lists. All 3 are using the same generic list for there items. I am using C# as the code behind. The code below shows the DTO list i am using and how I'm adding them to the drop downs...
[Code]....
I need to create 2 cascading dropdown menus for a website. I am really new to ASP so don't understand a lot of it yet.. now is that the website pulls the list items from a SQL database and I don't want to use this method. I need to use either JavaScript or just hard code the items. Here are the directions for what I need to do:
Drop down list box for selecting a state (populate it with names of five states)
I have a dropdown for tradertype which on selection should populate the dropdown for traders.My view looks like :
[Code]....
I tried using JQuery, but I couldn't get the change event of the 'TraderType' dropdown. My script is: [Code]....
The code in the controller is: [Code]....
I am not receiving any alert when I change the 'TraderType' dropdown.
I tried cascading dropdown in asp.net using ajax. I have tried with 3 dropdown control. The scenario is First dropdown is loaded when page gets loaded and the second dropdown is loaded based on first is selected and thrid dropdown is loaded based on second one selected, now I want to know how do I load third dropdown based on first and second selected value...
View 1 Replies i havce this web service
[Code]....
and this aspx page
[Code]....
perhaps i followed this example here
http://programming.top54u.com/post/AJAX-Cascading-Dropdown-Example-using-SQL-Database.aspx
it return an error that
System.InvalidCastException: unable to cast di object of 'AjaxControlToolkit.CascadingDropDown' on tye 'System.Web.UI.WebControls.DropDownList'.
Suppose parent dropdown is car (Values are car1, car2, car3)and its child is color(for car1 R Y G B, For car2 R Yand for car3 G B).Now on selection of car2 R and Y will appear and select R, then again made the change on car and select car3 then again select is comiing with G and B and select B.
Now if I select again in car, car1 then the child is populating with the values of car1 but it takes the B as a default value as it was previously selected and also present for car1 too.This case is only happen. on select of child value which is availble for both parent selection.
I have a form that needs to display 3 dropdown lists, one for my client type, then, based on the selection, my second list shows the clients for that type, and then based on the client name, my third dropdown box shows the contacts for that client. The first dropdown list one being a normal html.dropdownlist, and the other 2 being CascadingDropdownLists.
I have followed Stephen Walther's method 1 located at [URL]. If I select my client type, then my client names in my second dropdown shows perfectly, but when I choose my client name, the third dropdown does not work. When I view my page source, all my contacts are listed in my <select> control, but my dropdown box stays blank. Did anyone ever get a third dropdown to work?
i am going to use cascading dropdown in my project But i cant understand why it is not working let me know what i am doing wrong...
this is my aspx page,
[code]....
I have a cascading dropdown which is dynamically created and does a postback based on a certain condition. How do i set the selected value after the postback
View 1 Replies[Code]....
Dont go away by looking a difficult probem.
A form contains 2 cascading dropdowns. When an item is selected in the first dropdown, jQuery retrieves a list (json) from the server and fills the 2nd dropdown.
The user posts the page to the server, and when the page is returned the dropdown is empty because its not stored in viewstate.
What do you do in this situation? Is this the point where cascading dropdowns using jQuery and trying to make your page a little more stateless gets tedious?
I want to make a cascading dropdown list without using an UpdatePanel. I need tips for starting out this task. Currently,
I am using asp.net 2.0 .Will I be able to parse JSON in VSS 2005 if I use JQuery ?
What is the recommended alternate for UpdatePanel in Visual Studio 2005 ?
I am using Cascading Dropdown nad would be populating the values of the second dropdown from the session thats created when the page load.With the initial page load, the cascading dropdown works fine. But when I change the selection for the first one, the session values are not retained.
View 1 RepliesI have been trying to make a cascading drpdown using ajax using this link [URL] But m nt getting a clear picture abt it.. I have a table 'car' with fields of 'id','make','model','color'. I have 2 dropdowns on my form for make & model.I want to populate the model dropdown using the make dropdown but without postback.Till nw I have tried this :-
using System;
using System.Web;
using System.Collections;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Web.Services;
using System.Web.Services.Protocols;
using AjaxControlToolkit;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
//using System.Web.Script.Services.ScriptService;.............................
I want to display the image before the data in the dropdown based on the data category? is it possible with cascading dropdown?
View 2 RepliesI have a user control in which i have implemented Cascading dropdown. It works perfectly fine in IE but doesnt in Firefox. I am using webservice to get my data for the dropdowns.
View 3 RepliesI am trying to get the selected text of a cascadingdropdown control. I search over web but with no luck.
View 2 Replies<asp:DropDownList ID="ddlModuleName" runat="server" ClientIDMode="Static">
</asp:DropDownList>
<cc1:CascadingDropDown ID="cdlModule" TargetControlID="ddlModuleName" PromptText="Select Module" PromptValue="0" ServicePath="~/controls/WebService.asmx" ServiceMethod="GetModules" runat="server" Category="ModuleID" LoadingText="Loading..." />
I am binding the dropdownlist by using ajax cascading drop down now i need to preselect the dropdown value in code behind page in page load (for update operation) is it possible
I want to populate the cascading Dropdown values without Promttext.
Scenario is .If a single value is retrived from the database then I think no need to populate the promt text. It may populate only that value and call the next function from the inside of it. Can it be possible using web methods.
I am new to using Ajax Control toolkit. I need to create a dynamic cascading dropdowns in which the no of dropdowns will be programatically decided. Also the last dropdown can be replaced with a listbox as well. how i can leverage the Ajax toolkit's cascading dropdown.
View 2 Replies