[How Do I:] Use the ASP.NET AJAX CascadingDropDown Control Extender?http://asp.netTue, 27 May 2008 11:21:37 GMTumbracoComments for [How Do I:] Use the ASP.NET AJAX CascadingDropDown Control Extender?enComment Posted by polawhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderTue, 04 Mar 2008 21:41:57 GMT00000000-0000-0000-00000000281I found this much more helpful than the article located at <a rel="nofollow" target="_new" href="http://www.asp.net/AJAX/AjaxControlToolkit/Samples/Walkthrough/CCDWithDB.aspx">www.asp.net/.../CCDWithDB.aspx</a>

Although, the other article gave me a vague idea of the concept, it left me with more questions than answers.

I will watch this a couple more times and re-create the code shown in order to both learn how to do this and create a re-usable portion of code.

Thanks to Joe

]]>Comment Posted by JoeStagnerhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderSat, 15 Mar 2008 12:54:36 GMT00000000-0000-0000-00000000282Glad it was usefull - THANKS !

]]>Comment Posted by nehaljainhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderFri, 21 Mar 2008 16:33:09 GMT00000000-0000-0000-00000000283This is very helpful video. Just a note that the code link shown is not matching with the code shown during presentation. I followed each step to create the same and I am able to populate the first drop down but corresponding values are not loaded in second drop down. Are category values are case sensitive? I will try to debug it through.

I will definately watch other similar video posted by Joe

]]>Comment Posted by JoeStagnerhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderSat, 22 Mar 2008 11:29:43 GMT00000000-0000-0000-00000000284Just a note: The videos is recorded with the programming done in VB. The C# code is written later to accomplish the same task.

]]>Comment Posted by Rajskahttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderSun, 30 Mar 2008 12:29:53 GMT00000000-0000-0000-00000000285Hello Joe,

I did 4 dropdownlist boxes in VB for World Regions, Countries, States/Provinces and Cities. It works.

I made a new one in C# as required by ASP.Net 3.5, but now all I get are method errors 500, 12030s. Any suggestions?

Thanks.

]]>Comment Posted by Rajskahttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderSun, 30 Mar 2008 14:16:35 GMT00000000-0000-0000-00000000286Addendum:

I get this error report:

Error 1 File 'WorldService.asmx' was not found.

How do I make it be found?

]]>Comment Posted by Rajskahttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderSun, 30 Mar 2008 20:03:39 GMT00000000-0000-0000-00000000287Ok, I solved problems of the first 3 dropdownlist boxes by placing a "~/" in front of the asmx file.  But the last 4th box still gives Method error 500 or 12031.

]]>Comment Posted by JoeStagnerhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderMon, 31 Mar 2008 09:37:30 GMT00000000-0000-0000-00000000288500 is a server error which means there is a problem in your Service Code.

This can be caused either by a prgramming defect or by failing to correctly attribute the Service Class with the ScriptService attributes.

]]>Comment Posted by realjuanchohttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderMon, 07 Apr 2008 14:35:04 GMT00000000-0000-0000-00000000289Hey Joe, im a newcomer at this whole ASP AJAX stuff

i have a little question, where is the GetDropDownContentsPageMethod in the C# Code?

]]>Comment Posted by JoeStagnerhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderMon, 14 Apr 2008 20:53:59 GMT00000000-0000-0000-00000000290It's all the way to the bottom of Default.aspx.cs

]]>Comment Posted by Musafiirhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderTue, 15 Apr 2008 03:38:19 GMT00000000-0000-0000-00000000291Thx a lot for the tutorials Joe Stagner.

In your tutorial when setting the "ServiceMethod" for the dropdownlist2, you have used "GetDropDownListContentsPageMethod". What would be the result if we use only "GetDropDownListContents" and specifying the service path "CarsService.asmx"?

Am doing a page whereby the user will type a product name which will automatically update a dropdownlist Location where that particular product is found. There is a connection to a database. Can you please guide me what should i modify to bind it to database or if there is a similar tutorial somewhere.

Thnx Joe, waiting for your response

]]>Comment Posted by idanzhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderThu, 17 Apr 2008 16:24:34 GMT00000000-0000-0000-00000000292Hello Joe,

Do you know what the [Method Error 12030] means to?

]]>Comment Posted by agnomonushttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderWed, 23 Apr 2008 23:49:45 GMT00000000-0000-0000-00000000293I appreciated the video and followed very closely. When I launched my app however the dropdownlists were populated progressively with each selection before it, but for the life of me I can't get the label to display the final text. I've looked at the downloaded source and my code is identical but the label displays nothing. Any ideas about that?

]]>Comment Posted by chjkhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderFri, 25 Apr 2008 09:12:47 GMT00000000-0000-0000-00000000294it's so cool.THANKS Joe！

i have a question：

If i add a new chidnode "TheFirstOwner" in the node "color",seem this:

 <make name="Acura">

   <model name="Integra">

     <color name="Green" >

       <TheFirstOwner name="Joe Stagner" />

     </color >

     ...

 </make>

</CarsService>

i want to know how to dispay the "TheFirstOwner" item in

the Label1 in the DropDownList3_SelectedIndexChanged

event?

thank you very much!

]]>Comment Posted by chjkhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderFri, 25 Apr 2008 09:18:19 GMT00000000-0000-0000-00000000295if i choose Acura--Integra--Green

Label1.txet will display:

"You have chosen a Green Acura Green . Nice car! The First Owner is Joe Stagner"

]]>Comment Posted by Hideyoshihttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderTue, 06 May 2008 04:33:58 GMT00000000-0000-0000-00000000296To Joe,

the attribute of the Service Class with the ScriptService attributes is compulsary in the webservice.vb file? I'm facing the problem of method error 500 too. i'm Using SQL Server 2005 as my database.

]]>Comment Posted by Rajskahttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderWed, 07 May 2008 17:43:30 GMT00000000-0000-0000-00000000297Same problem with Musafiir. How to data bind the selectedvalue to the database?  Will this work?  Add DataTextField="Make" SelectedValue='<%#Bind("Make") %>'  to the asp:DropDownList.

Or can SelectedValue='<%Bind("Make")%>' be added in the code-behind?

]]>Comment Posted by charnatahttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderMon, 12 May 2008 14:39:19 GMT00000000-0000-0000-00000000298Joe,

I have been able to get the example to work.  Now I am attempting to use this example with my data.  I have been able to get the first two boxed to work however on the third dropdown box I get the dreaded 500 error.  Can you give me an idea of where to look in my code.  I have three datasets dsAllSite, dsServiceUnits and dsSelectedSites.

My appologies if I have been to vague or not given you enough information to assist me.

//default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" EnableEventValidation="false" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "<a rel="nofollow" target="_new" href="http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">">www.w3.org/.../xhtml11.dtd"></a>

<html xmlns="<a rel="nofollow" target="_new" href="http://www.w3.org/1999/xhtml">">www.w3.org/.../xhtml"></a>

<head runat="server">

<link href="returnSiteService.css" rel="stylesheet" type="text/css" />

   <title>Untitled Page</title>

</head>

<body style="text-align: center">

   <form id="form1" runat="server">

       <asp:ScriptManager ID="ScriptManager1" runat="server" />

       <br />

       &nbsp;<div style="text-align: center">

           <table>

               <tr>

                   <td class="tblLabel">ATO:</td>

                   <td class="tblSpacer"></td>

                   <td class="tblDropDown">

                       <asp:DropDownList ID="ddlAto" runat="server" CssClass="dropdown" />

                   </td>

               </tr>

               <tr>

                   <td class="tblLabel">Service Unit:</td>

                   <td class="tblSpacer"></td>

                   <td class="tblDropDown">

                       <asp:DropDownList ID="ddlSu" runat="server" CssClass="dropdown" />

                   </td>

               </tr>

           </table>

       </div>

       <br />

       <br />

       <cc1:CascadingDropDown ID="ccdAto"

                              runat="server"

                              TargetControlID="ddlAto"

                              Category="Symbol"

                              PromptText="Please begin here..."

                              LoadingText="Please wait..."

                              ServicePath="ReturnSiteService.asmx"

                              ServiceMethod="GetAto">

       </cc1:CascadingDropDown>

       <cc1:CascadingDropDown ID="ccdSU"

                              runat="server"

                              TargetControlID="ddlSu"

                              ParentControlID="ddlAto"

                              Category="Symbol"

                              PromptText="Select a Service Unit..."

                              LoadingText="Please wait..."

                              ServicePath="ReturnSiteService.asmx"

                              ServiceMethod="GetSUData">

       </cc1:CascadingDropDown>

       <cc1:CascadingDropDown ID="ccdOffice"

                              runat="server"

                              TargetControlID="ddlOffice"

                              ParentControlID="ddlSu"

                              Category="Symbol"

                              PromptText="Select an Office..."

                              LoadingText="Please wait..."

                              ServicePath="ReturnSiteService.asmx"

                              ServiceMethod="GetOfficeSites">

       </cc1:CascadingDropDown>

    </form>

</body>

</html>

//returnSiteService.cs

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 System.Data;

using System.Data.SqlClient;

using AjaxControlToolkit;

/// <summary>

/// Summary description for ReturnSiteService

/// </summary>

[WebService(Namespace = "<a rel="nofollow" target="_new" href="http://tempuri.org/"">http://tempuri.org/"</a>)]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

[System.Web.Script.Services.ScriptService]

public class ReturnSiteService : System.Web.Services.WebService {

   public ReturnSiteService () {

       //Uncomment the following line if using designed components

       //InitializeComponent();

   }

   [WebMethod]

   public CascadingDropDownNameValue[] GetAto(string knownCategoryValues, string category)

   {

       dsAllSitesTableAdapters.atostructureTableAdapter siteAdapter = new dsAllSitesTableAdapters.atostructureTableAdapter();

       dsAllSites.atostructureDataTable makes = siteAdapter.GetAllSiteData();

       List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();

       foreach (DataRow dr in makes)

       {

           string Symbol = (string)dr["Symbol"];

           int siteIdx = (int)dr["Idx"];

           values.Add(new CascadingDropDownNameValue(Symbol, siteIdx.ToString()));

       }

       return values.ToArray();

   }

   [WebMethod]//This method selectcts the Service Units

   public CascadingDropDownNameValue[] GetSUData(string knownCategoryValues, string category)

   {

       StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCateg oryValues);

       int siteIdx;  //clear after testing

       if (!kv.ContainsKey("Symbol") || !Int32.TryParse(kv["Symbol"], out siteIdx))

       {

           return null;

       }

       dsServiceUnitTableAdapters.atostructureTableAdapter serviceUnitAdapter = new dsServiceUnitTableAdapters.atostructureTableAdapter();

       dsServiceUnit.atostructureDataTable su = serviceUnitAdapter.GetSUAllData(siteIdx);

       List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();

       foreach (DataRow dr in su)

       {

           values.Add(new CascadingDropDownNameValue((string)dr["Symbol"], dr["Idx"].ToString()));

       }

       return values.ToArray();

   }

   [WebMethod]// This method selesct the children of the service unit

   public CascadingDropDownNameValue[] GetOfficeSites(string knownCategoryValues, string category)

   {

       StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCateg oryValues);

       int siteIdx;  //clear after testing

      if (!kv.ContainsKey("Symbol") || !Int32.TryParse(kv["Symbol"], out siteIdx))

       {

           return null;

       }

       dsSelectedSitesTableAdapters.atostructureTableAdapter selectedSitesAdapter = new dsSelectedSitesTableAdapters.atostructureTableAdapter();

       dsSelectedSites.atostructureDataTable ss = selectedSitesAdapter.GetSelectedSites(siteIdx);

       List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();

       foreach (DataRow dr in ss)

       {

           values.Add(new CascadingDropDownNameValue((string)dr["Symbol"], dr["Idx"].ToString()));

       }

       return values.ToArray();

   }

}

]]>Comment Posted by the_N_Channelhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderWed, 14 May 2008 08:02:23 GMT00000000-0000-0000-00000000299Ok, so the 500 error is a Server error...now I'm getting a 405 error. I went into the Toolkit code to try to find the dictionary that has the relationship between these numbers and what they mean, but it didn't seem to be in the CascadingDropDown...where can one find the information to decode these numbers? Generic numeric error messages is very Therac-25!

]]>Comment Posted by charnatahttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderThu, 15 May 2008 13:00:06 GMT00000000-0000-0000-00000000300OK, I narrow down the issue I beleive but I do not know how to fix it or where to start.  In my third dropdown box the ParentControlID will not recongnize the dropdown box ID.  If I switch the third box to the first box it fill its box with selections based on the first dropdown box.  Can anyone give me an idea of where to look to correct this?

Thanks

]]>Comment Posted by stapeshttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderFri, 16 May 2008 12:05:49 GMT00000000-0000-0000-00000000301Hi

The downloaded C# code has a bad zip header. Is it corrupt?

Also, where is the C# code for GetDropDownContentsPageMethod - its not on the video or in the downloaded code. i.e. this stuff:

<script runat="server">

       <System.Web.Services.WebMethod()>

       <System.Web.Script.Services.ScriptMethod()>

       public Shared function GetDropDownContentsPageMethod(ByVal knownCategoryValues as string, ByVal Category as string) As AjaxControlToolkit.CascadingDropDownNameValue()

           return new CarsService().GetDropDownContents(knownCategoryValues, category)

       end function

       </script>

]]>Comment Posted by charnatahttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderFri, 16 May 2008 13:18:29 GMT00000000-0000-0000-00000000302Yea... I found my issue other than myself, Duh!  Since I was using a single table that had a hierarchal data set I was referencing the same column name in each of my [WebMethod] coding blocks.  Since I needed to use this data I gave the column an alias in each of the data set calls change .cs and .aspx pages accordingly and bingo it works!  A user to have up to 8 dropdown boxes and they all are working off the parent dropdown.

]]>Comment Posted by sachinmanathhttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderWed, 21 May 2008 04:45:20 GMT00000000-0000-0000-00000000303sir i am usring you control in my website but some time i am getting this error Sys.WebForms.PageRequestManagerParserErrorException

Can you tell me how can i solve this problem and where it is existing?

Please reply me

Thanks

]]>Comment Posted by sul125http://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderThu, 22 May 2008 17:08:51 GMT00000000-0000-0000-00000000304why everything has to be in ajax section in visual basic anguage?!!

why not any c# one

]]>Comment Posted by Lorettahttp://asp.net/web-forms/videos/ajax-control-toolkit/how-do-i-use-the-aspnet-ajax-cascadingdropdown-control-extenderTue, 27 May 2008 11:21:37 GMT00000000-0000-0000-00000000305When I try to download this video the ZIP file comes back corrupt.  When I try to save target as on the wmv file, I get the first 5 minutes of the video and then it just stops.  Is there something wrong with the WMV version of the video, or is it just me?

Thanks.

]]>