代码如下:
using System;
using System.Web;
using System.Collections;
using System.Collections.Specialized;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.OleDb;
using System.Collections.Generic;
using AjaxControlToolkit;
/// <summary>
/// GetType 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class GetType : System.Web.Services.WebService {
public GetType () {
//如果使用设计的组件,请取消注释以下行
//InitializeComponent();
}
[WebMethod]
public CascadingDropDownNameValue[] GetClassList(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int modelId;
if (!kv.ContainsKey("ClassLeve") || !Int32.TryParse(kv["ClassLeve"], out modelId))
{
return null;
}
DataTable classdata = selectclassbygrade(0);
List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();
foreach(DataRow dr in classdata.Rows)
{
values.Add(new CascadingDropDownNameValue((string)dr["db_typename"], dr["db_id"].ToString()));
}
return values.ToArray();
}
public DataTable selectclassbygrade(int grade)
{
using (OleDbConnection conn = urlt.Base.Data.acdb())
{
string sql = "select typename,id from db_type where grade=" + grade.ToString();
OleDbDataAdapter adpt = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
adpt.Fill(ds);
return ds.Tables[0];
}
}
}
selectclassbygrade工作正常.数据库没问题.
这个是为cascadingdropdown控件使用的webservice,不能返回数据
using System;
using System.Web;
using System.Collections;
using System.Collections.Specialized;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.OleDb;
using System.Collections.Generic;
using AjaxControlToolkit;
/// <summary>
/// GetType 的摘要说明
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class GetType : System.Web.Services.WebService {
public GetType () {
//如果使用设计的组件,请取消注释以下行
//InitializeComponent();
}
[WebMethod]
public CascadingDropDownNameValue[] GetClassList(string knownCategoryValues, string category)
{
StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
int modelId;
if (!kv.ContainsKey("ClassLeve") || !Int32.TryParse(kv["ClassLeve"], out modelId))
{
return null;
}
DataTable classdata = selectclassbygrade(0);
List<CascadingDropDownNameValue> values = new List<CascadingDropDownNameValue>();
foreach(DataRow dr in classdata.Rows)
{
values.Add(new CascadingDropDownNameValue((string)dr["db_typename"], dr["db_id"].ToString()));
}
return values.ToArray();
}
public DataTable selectclassbygrade(int grade)
{
using (OleDbConnection conn = urlt.Base.Data.acdb())
{
string sql = "select typename,id from db_type where grade=" + grade.ToString();
OleDbDataAdapter adpt = new OleDbDataAdapter(sql, conn);
DataSet ds = new DataSet();
adpt.Fill(ds);
return ds.Tables[0];
}
}
}
selectclassbygrade工作正常.数据库没问题.
这个是为cascadingdropdown控件使用的webservice,不能返回数据
