mehfa27
چهارشنبه 07 خرداد 1393, 16:28 عصر
سلام. من هنوز نتونستم به نتیجه ای برسم. دوستان لطفا کمک کنید.اینم ک برنامه ام هست:
کد وب سرویس
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using AjaxControlToolkit;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Configuration;
using System.Data;
using System.Data.SqlClient
[System.Web.Script.Services.ScriptService]
public class Car : System.Web.Services.WebService {
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrin gs["ConnectionString"].ConnectionString);
//Web method for bind Make
[WebMethod]
public CascadingDropDownNameValue[] BindMake(string knownCategoryValues, string category)
{
DataSet ds = new DataSet();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from Make", conn);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
adp.Fill(ds);
conn.Close();
List<CascadingDropDownNameValue> MakeDetails = new List<CascadingDropDownNameValue>();
foreach (DataRow DR in ds.Tables[0].Rows)
{
string CARID = DR["CarId"].ToString();
string CARNAME = DR["CarName"].ToString();
MakeDetails.Add(new CascadingDropDownNameValue(CARNAME, CARID));
}
return MakeDetails.ToArray();
}
//Web method for bind Model
[WebMethod]
public CascadingDropDownNameValue[] BindModel(string knownCategoryValues, string category)
{
DataSet ds = new DataSet();
int CarID;
StringDictionary kv = AjaxControlToolkit.CascadingDropDown.ParseKnownCat egoryValuesString(knownCategoryValues);
CarID = Convert.ToInt32(kv["CarName"]);
conn.Open();
SqlCommand cmd = new SqlCommand("select * from Model where CarId=@CarId", conn);
cmd.Parameters.AddWithValue("@CarId", CarID);
cmd.ExecuteNonQuery();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(ds);
conn.Close();
List<CascadingDropDownNameValue> ModelDetails = new List<CascadingDropDownNameValue>();
foreach (DataRow DR in ds.Tables[0].Rows)
{
string MODELID = DR["ModelId"].ToString();
string MODELNAME = DR["ModelName"].ToString();
ModelDetails.Add(new CascadingDropDownNameValue(MODELNAME, MODELID));
}
return ModelDetails.ToArray();
}
};
اینم کد صفحه <form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
<div>
<asp:DropDownList ID="ddlMake" runat="server" Width="200px" >
</asp:DropDownList>
<asp:CascadingDropDown ID="ddlMake_CascadingDropDown" runat="server" TargetControlID="ddlMake" Category="Make"
LoadingText="لطفا صبر کنید..." PromptText="انتخاب خودرو"
ServiceMethod="BindMake" ServicePath="~/Car.asmx" >
</asp:CascadingDropDown>
<asp:Label ID="Label1" runat="server" Text="نوع خودرو"></asp:Label>
</div>
<asp:DropDownList ID="ddlModel" runat="server" Width="200px">
</asp:DropDownList>
<asp:CascadingDropDown ID="ddlModel_CascadingDropDown" runat="server" TargetControlID="ddlModel" Category="Model"
ParentControlID="ddlMake" LoadingText="لطفا صبر کنید..." PromptText="انتخاب مدل خودرو"
ServiceMethod="BindModel" ServicePath="~/Car.asmx">
</asp:CascadingDropDown>
<asp:Label ID="Label2" runat="server" Text="مدل خودرو"></asp:Label>
</form>