I am trying to use a solution for a cascading dropdownlist (the selection in one dropdownlist determines the options in the second one) found here:
[URL]
[code]...
how to get a default value for the dropdownlists. Since otherwise the customer dropdownlist will have a value when you first get to the page, but the task list won't...
i tried to change an cascading dropdownlist example
http://www.codedigest.com/Articles/jQuery/224_Building_Cascading_DropDownList_in_ASPNet_Using_jQuery_and_JSON.aspx
But i get always the message "Microsoft JScript runtime error: Object expected"
<asp:Content ID="Content1" ContentPlaceHolderID="contentplaceholderHEAD" runat="Server">
</script src="~/_scripts/jQuery-1.4.2.js" type="text/javascript">
<script language="javascript">[code]...
Can't tag all my code as "Sourceode" because its not working corectly..
<asp:Content ID="Content2" ContentPlaceHolderID="maincontent" runat="Server">
<div> [code]...
I am new to ASP.NET MVC 2. In my project, there are two selects: one that contains a list of countries and another that should contain the states/provinces/etc for the country selected in the previous select.
Is there any possibility to create a cascading select without using any client scripting?
I am referring to following line from this link [URL] ....
data 'continentId ' 'ddlContinents.ClientID'.val ''
In your code. i tried using this code and facing a tiny problem. In above mentioned code 'ddlContinents.ClientID'.val stores integer value in contentId for obvious reasons but the requirement of my code is different. i want to pass text which is selected instead of id no.for example if mumbai is listed as second option and i select mumbai it should store mumbai in contentId instead of 2 i.e. integer value.
I have 2 dropdownlist in my page
1--ddlTarde
2--ddlTradeClass
and 2 table in database
1-Trade table
ID Tname
1 Industry
2 Cloth
2-Tradeclass
ID Class Tname
1 Electronic Industry
2 Car Industry
3 Scarf Cloth
4 Pants Cloth
I bind ddlTrade from Tradetable and I want when users click on Item from ddlTrade it bind data from ddlTradeclass that TNAME=ddlTrade.selectedItem in ddltradeClass for this I used below code
for binding ddltrade
BindDropDownList(DDLtrade, "tradename", "Name", "id");
protected void BindDropDownList(DropDownList DDL, string spname, string dataTextfield, string dataValuefield) {
SqlCommand _cmd = new SqlCommand(spname, _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
[Code] ....
NOW my problem is that when I select Item from ddlTrade it didn't show any thing in ddlTradeClass but when I delete this code
DDL.DataValueField=dataValuefield;
from BindDropDownList Metod and change like below:
protected void BindDropDownList(DropDownList DDL, string spname, string dataTextfield)
{
SqlCommand _cmd = new SqlCommand(spname, _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[Code] ....
It worked correctly I mean when I click Item from ddlTrade in ddlTradeClass show data from TradeClass Table
so here what should I do ? I need DataValueField in ddlbinding ... Why this problem happen?
I have 2 dropdownlists and on change 1st dropdownlist (ddlPlant), the 2nd dropdownlist (ddlCategoryName) refreshes its data based on 1st dropdownlist value. However, the codes does not worked.
My codes:
[Code]....
I am using jQuery to do a cascading dropdown list (State, City). In order to pull the information from the database I have a web service that I reference. The code all works like a champ when I use the JavaScript on the ASPX page for proof of concept, but when I place the JavaScript in the userControl and then put the userControl on the ASPX page, it breaks.
The next foreseeable thing that will potentially complicate things further is that the userControl will be inside of an updatePanel
I am having two dropdownlist in my project,one dropdownlist for empid, another dropdownlist for month, if the user select the empid, the values are retrieved in the textbox.
In the second dropdownlist, if the user select the month in the dropdownlist it will display the leave details, its all working fine, if the user again select the first dropdownlist that means empid, I want to show the second dropdownlist as select month, how can do this.....
i have 3 drop down list in my page
1-ddlzone1
2-ddldistrict1
3-ddlstore1
this is ddlzone1 code
protected void DDLzone1_SelectedIndexChanged(object sender, EventArgs e) {
DDLstore1.Items.Clear();
DDLstore1.Items.Add(new ListItem("select center", ""));
DDLstore1.AppendDataBoundItems = true;
SqlCommand _cmd = new SqlCommand("selectcenter", _cn);
[CODE].....
I inherited a site which I am in the middle of updating which has a DropDownList and a RangeValidator assigned to it. The data is bound to the dropdown on Page_Load. The values are retrieved from the database so the value property of each item is set to the unique ID of the item in the DB.
The RangeValidator looks something like:
<asp:rangevalidator id="ddRangeValidator" runat="server" ControlToValidate="ddMenu" ErrorMessage="Please select value in range" MinimumValue="1" MaximumValue="100000" Type="Integer">*</asp:rangevalidator>
I have a method which automatically populates this value in jQuery e.g.
$("#ddMenu").val("An Option");
This works, however, when I try to post the page the range validation fails. Then even if I manually select that value, or select another valid value it still won't validate. The only way to make it validate is to select non-valid value and then re-selecting a valid one.
Here is the data binding code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load
If Not Page.IsPostBack Then
Dim ds As New DataSet()
Dim myDbObject As New myDbObject()
ds = myDbObject.ToDataSet() // retrieves all objects from the database
[Code]....
I am making an application that deals with vehicles. I need two DropDownLists:
Makes: All Vehicle Makes
Models: Models that belong to the selected value of the Make DropDownList
How is this done in MVC2? My Idea: Do I use an ajax call when my first list is selected and then pull back the Models to bind to the Model DDL? How would model binding come into play that way? UPDATE I posted what I ended up doing as an answer. It is super simple and works great. You can use a get too if you feel so inclined, but you have to specify that you want to like so... return Json(citiesList, JsonRequestBehavior.AllowGet);
Cascading html select server control, jQuery does not retain value on post back
View 4 RepliesIn my previous question mentioned below.
My previous question mentioned
[URL]
Now i am having two dropdown one is asp dropdownlist and 2ND is MultiSelect-DropDownList-with-CheckBoxes. 2nd dropdown is populating on selected value of first.On page load it works fine. Now, on change of value in dropdown, selected index change 2nd dropdown (MultiSelect-DropDownList-with-CheckBoxes) fills but i see a list box instead of dropdown.
I have a .aspx page having two dropdowns, the data to be loaded in them is usually static(but may change everyday), the first dropdown always displays the main categories and the second dropdown is initially empty.
Now, the requirement is:
As the user selects a category from the first dropdownlist, the second dropdownlist should populate based on the selection just made.
The road-block:
This should be done without a postback. My boss wants something like the drop downs on this page.
So what I gather is, I'd have to retrieve the data from the database on page load event, store it in the cache(or somewhere else?), then use javascript to handle the selectedindexchanged event of the 1st dropdown, use the data from database stored at pageload and populate the second dropdown according to the selected value of first dropdown.
P.S.- I'm a beginner ASP.Net C# programmer and have no knowledge of Javascript.
implementing cascading static dropdownlist in asp.net
View 1 RepliesMy application includes a gridview control with and Edit mode which allows users to do selections using cascading dropdownlist. My code is based on tutorial by Brian Orrell (link below). I am able to statically populate the dropdownlist but in my case I need to populate it dynamically based on a previous selection of a dropdownlist, I would like to do it programatically so I can manipulate data.
[URL]
I am trying to get two cascading dropdownlist to work but cannot get either to populate. How do I de-bug this? I'm not getting any errors, just blank dropdowns.
I've been trying to fill in webservice from SQL Server. But in-case this was the problem. I found an example on this site to fill with test values, but this still does not work. Since I cannot even get first to populate, to simplify I'm just giving code for first dropdown and its function(s)
[code]....
i have a table with three columns as ID,baseid,name.
[code]...
i will display all baseid 0 values in first dropdownlist1
based on the selection corresponding values will be shown in dropdownlist2 (like when desc1 is selected desc1212 &desc2323 will be shown in dropdownlist2. now i want to edit/add details to the table from aspx page.
I am trying to select some data with dropdown lists which are related.
I select one of selection in dropdownlist1. After that, when my page reloads, dropdownlist2 is filled with table name which i am trying to get data from. (TBLYETKILI)
My code is below..
For dropdownlist1:
[Code]....
For dropdownlist2:
[Code]....
Also I am calling these functions as follows:
[Code]....
I think this needs to be a sticky since this is not solved anywhere that I have been looking... I have been googling this for a while now and came across the answer by shear luck and a simple typo when I was writing the code...
Problem: I have 2 dropdown lists...
ddllist1 and ddlist2... Both are code-behind populated via a sql DB.
they are cascading lists via the ajax control.
I am trying to dynamically populate them with values from a DB for edit reasons.
When I try to get them populated I kept getting the error...
"dropdownlist has a SelectedValue which is invalid because it does not exist in the list of items"
Solution:
1) get the values from the DB or from where ever...
2) create a sql select to get the values from the ddl db
3) set the ID of the first DDL control to cddcontrol1.SelectedValue = id (this is a number)
4) set the value of the DDL to the string value ddlist2.SelectedValue = value (this is a string)
here is the code.
[Code]....
let me know if some body tried to use a cascading dropdownlist inside a formview to be used in update and insert templates.known that my tables are like this:
Section:
SecID SecTitle
Category: [code]...
I need to create a formview to insert and update all my news but I need a cascading Dropdownlist to select a section and generate the related categories Note that I need to display the Sectoin and the Category Titles
I have 5 dropdown list (sector-country-year-project code-project title) so what i need is when i select specific sector for example education , the rest of the label should show me the only data related to the sector education in dropdown list. the same with other if i select year 2011 should show me in other dropdown list just the data related to year 2011.
View 1 RepliesI would like to populate Cascading DropDownList From SQL Server.
I prepare my project the same way as in this article: [URL] ....
But all the time I have "Method error 500" I read many articles how to solve this issue but without success.
Below there are my codes:
----SQL DB has two tables:
1.tblUAP (UAP (PK), Start_Date,End_Date)
2.tblGAP(idGAP (PK),GAP,UAP(FK to tblUAP))
---project1.aspx
<%@ Page Language="C#" EnableEventValidation="false" AutoEventWireup="true" CodeBehind="Project1.aspx.cs" Inherits="TEST.Project1" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>
....
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
[Code].....
----Services.asmx
using System;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
[Code] ....
What else Can I check ??
I used your link [URL]"
and implement in my Project your code is working but error is
I have 4 columns in database country, States, City and Area
in the area table 991 recordes are exists I am binding area onchange of City dropdown but records is not binding only showing loadding than I changed my storeprocedure write qurey to select top 673 records now area is binding but if I remove "top" from select its showing loading in area dropdown.
how can I solve this issue
<script type="text/javascript">
function PopulateArea() {
$("#<%=ddlArea.ClientID%>").attr("disabled", "disabled");
if ($('#<%=ddlCity.ClientID%>').val() == "0") {
$('#<%=ddlArea.ClientID %>').empty().append('<option selected="selected" value="0">Please select</option>');
}
[CODE]...
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]....