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]....
Into my application there is EditAds.aspx page where the user get a link on his email after he add an Ad into my application. My inquiry is can i bind the cascading ddl to show the value of State column into Ad/product row as well if the user want to update the rest of state will be also reachable. It maybe hard to get what i am looking for exactly so i make a short screen record ...
Rebinding values of Ad/product depending on AdsID which is a query string in the page called: QADNUM
[URL] ....
if (!IsPostBack)
{
if (cookie["Location"] == null)
{
DataTable rEfilterstathpBizDT = new DataTable();
using (SqlConnection REGGfilterstathpBizCon = new SqlConnection(sc))
[Code] ......
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 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 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]....
I 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 am dealing with a problem that i have to make decision based on the number of items in a cascading dropdownlist. unfortunately this ajax toolkit control does not expose a Items collection.how do i count the number of items in this control ?
View 1 RepliesI'm wanting to maintain the dropdownlist values that were selected when i use postbackurl with a button. They cascading dropdowns are on a masterpage in an accordion pane. I select the 3 vales in the ddl and then presss a button which redirects to the new content page.
I've been able to get the values using previousPage.master.fincontrol... but am then setting the selectedValue in the page_init of the conent page, but they aren't set when the page loads... does anyone know where to put the code to set the values?
Now i'm working on the cascading dropdownlist for to bind a country and city, city is based on country dropdownlist. its working well , if city comes more than 8000 records in city dropdownlist , takes more to bind city.
View 1 RepliesI really have no idea on this problem on the cascading dropdownlist. I have a cascading dropdownlist that bind with calling the web services.
I wan to do a autopostback to get the value of the Album GUId so that i can query out all the photo list of that album. it is working well if my page without the AlbumGUId query string.
my problem is:
when i redirect from other page and passing the Album GUId querystring to this page, it will display all my photo for this album guid. but when i change the album to Select which should be able to display all the Photos, it cannot display out. It only will work is when i choose another album and then go back to Select then it only can work..
[code]....
I'd like to set the selected value of cascading dropdownlist by reading from a Textbox.Text value when the dropdownlist has been populated, is this possible?
View 3 Repliesat last project i need to deploy cascading dropdownlist without using web serive or cascadingDropDownList Extender
i try to do this using updatepanel :D this work , but at many times that apear my computer and my internet Explorer as busy and hang and i can not do any thing untill populate the second dropdownlist :(
is there any way to avoid that and to view a wait message until populate the second dropdownlist , i mean is there a sample code for doing that
here is my code
[Code]....
I have two dropdownlist in cascading working, in my file file.aspx, all work good.the selected values from cascading dropdownlist bind my repeater. when select item inside repeater redirect me to second.aspx. when comeback to first.aspx i lose all selected values in cascading dropddowlist and also values in repeater.
View 1 Repliesi can populate cascading dropdownlist by using webservice now. but may i know how do i trigger function while selectedindex changed? (without using auto postback...)
View 3 RepliesI want to add items to a dropdownlist with values return by a webservice which will be called from javascript without cascading extender...
View 3 RepliesI have 3 Dropdownlist
1-DDlcity 2-DDlRegion 3-DDlDistrict
and below is House_info table
district region city Id can
1 Canada
1 Lon
1 London
2 Ita
2 Canada
3
Now when I select city from DDlcity after that select region from DDlregion according to my selected item from DDlcity and DDlregion it bind DDlDistrict... before I used OnselectedIndexChange below is SP...
ALTER procedure [dbo].[SelectِDistrict]
@Region NVARCHAR(30),
@city NVARCHAR(40)
[Code] ....
It worked correctly but now I use cascadingdropdown list
[WebMethod]
public CascadingDropDownNameValue[] GetDistrict(string knownCategoryValues)
{
string region = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues)["Region"];
string query = string.Format("SELECT District FROM District WHERE Region = N'{0}'", region);
[Code] ....
problem is that when I select city=canada then region=1 I want it bind in DDldistrict =can but here it show in DDLdistrict can and Lon
here it just select district that region=1 it doesn't attention to city selected Item I want it do like SP that I used...
I wan to do a required field validation for the cascading dropdownlist . When my page first load out the validator is fired first in the google chrome, the callout extender message is prompt out first in the Google Chrome. I have tested the code in IE and safari, this two browsers never prompt out the validator callout first when the page is loaded.
i wonder why the google chrome will prompt out the validator when i validate the cascading dropdownlist. I have did some research on it, but failed to get any solution.
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 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 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);
I have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
[Code]....
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?
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 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 Replies