salut mes amis j'utilisa des CascadingDropDowns (depuis une base de données)
mais quand j'execute je trouve que ma liste est vide


voilà le .aspx
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
<%@ Page Language="C#" AutoEventWireup="true" EnableEventValidation="false"  CodeFile="ajax.aspx.cs" Inherits="ajax" %>
 
 <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!DOCTYPE html>
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
    <fieldset style="width:340px;">
    <legend>Fill Country,State and City DropDownList in asp.net</legend>
    <table>
    <tr>
        <td width="40%">Select Country:</td>
        <td>
        <asp:DropDownList ID="ddlCountry" runat="server" 
                 Width="187px" AutoPostBack="True"></asp:DropDownList>
 
                </td>
 
<ASP:CascadingDropDown ID="ccd2" runat="server"      
	ServicePath="AjaxCascadingDropDown.asmx" ServiceMethod="GetVendors"      
	TargetControlID="ddlCountry"     
	Category="utilisateur"      
	PromptText="Select Contact" ></asp:CascadingDropDown>
 
    </tr>
    <tr>
        <td>Select State:</td>
        <td>
        <asp:DropDownList ID="ddlState" runat="server"
                Width="187px"> </asp:DropDownList>
               <asp:CascadingDropDown ID="csdState" runat="server"
        ParentControlID="ddlCountry"
        Category="State"
        TargetControlID="ddlState"
         PromptText="-- Select State --"
         LoadingText="[Loading States...]"
         ServiceMethod="FetchStates"
         ServicePath="AjaxCascadingDropDown.asmx" />
 
                </td>
        </tr>
 
    <tr>
        <td>Select City:</td>
        <td>
        <asp:DropDownList ID="ddlCity" runat="server" Width="187px" AutoPostBack="True"
                ></asp:DropDownList>
        <asp:CascadingDropDown ID="csdCity" runat="server"
        ParentControlID="ddlState"
        Category="City"
        TargetControlID="ddlCity"
         PromptText="-- Select City --"
         LoadingText="[Loading Cities...]"
         ServiceMethod="FetchCities"
         ServicePath="AjaxCascadingDropDown.asmx">
        </asp:CascadingDropDown>
        </td>
    </tr>
    <tr>
        <td colspan="2">
            <asp:Label ID="lblStatus" runat="server" Text="" style="color: #006600"></asp:Label>
        </td>
    </tr>
    </table>
        </fieldset>
    </div>
    </form>
</body>
</html>


web service

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
 using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using AjaxControlToolkit;
using System.Collections.Specialized;
 
 
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
 [System.Web.Script.Services.ScriptService]
public class AjaxCascadingDropDown : System.Web.Services.WebService
{
    SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DatabaseConnectionString1"].ToString());
 
    public AjaxCascadingDropDown () {
 
        //Uncomment the following line if using designed components
        //InitializeComponent();
    }
 
    [WebMethod]
  public CascadingDropDownNameValue[] GetVendors(string knownCategoryValues, string category) 
{      
 
	con.Open();      
	SqlCommand comm = new SqlCommand("SELECT *  FROM UTILISATEUR",con);      
	SqlDataReader dr = comm.ExecuteReader();      
	List<CascadingDropDownNameValue> l = new List<CascadingDropDownNameValue>();      
	while (dr.Read())      
	{           
		l.Add(new CascadingDropDownNameValue(dr["NOM_COMPLET_UTILISATEUR"].ToString(),                     
		dr["ID_UTILISATEUR"].ToString()));      
	}      
	con.Close();      
	return l.ToArray(); 
}/*
 
    [WebMethod]
    public CascadingDropDownNameValue[] FetchStates(string knownCategoryValues, string category)
    {
        int countryId;      
        StringDictionary strCountries = AjaxControlToolkit.CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
        countryId = Convert.ToInt32(strCountries["Country"]);
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from Tbl_State where Country_ID_Fk=@CountryID", con);
        cmd.Parameters.AddWithValue("@CountryID", countryId);
        cmd.ExecuteNonQuery();
        SqlDataAdapter dastate = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dastate.Fill(ds);
        con.Close();      
        List<CascadingDropDownNameValue> states = new List<CascadingDropDownNameValue>();
        foreach (DataRow dtRow in ds.Tables[0].Rows)
        {
            string StateID = dtRow["State_Id_Pk"].ToString();
            string StateName = dtRow["State_Name"].ToString();
            states.Add(new CascadingDropDownNameValue(StateName, StateID));
        }
        return states.ToArray();
    }
  
    [WebMethod]
    public CascadingDropDownNameValue[] FetchCities(string knownCategoryValues, string category)
    {
        int stateId;     
        StringDictionary strStates = AjaxControlToolkit.CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
        stateId = Convert.ToInt32(strStates["State"]);
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from Tbl_City where State_ID_Fk=@StateID", con);
        cmd.Parameters.AddWithValue("@StateID", stateId);
        cmd.ExecuteNonQuery();
        SqlDataAdapter daregion = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        daregion.Fill(ds);
        con.Close();     
        List<CascadingDropDownNameValue> cities = new List<CascadingDropDownNameValue>();
        foreach (DataRow dtRow in ds.Tables[0].Rows)
        {
            string RegionID = dtRow["City_id_pk"].ToString();
            string RegionName = dtRow["City_Name"].ToString();
            cities.Add(new CascadingDropDownNameValue(RegionName, RegionID));
        }
        return cities.ToArray();
    }  */ 
}


merci d'avance