最近用asp.net ajax过程中遇到的一些问题
一、'Sys' 未定义问题
原因:在页面的CodeFile中定义了下面的方法
Code
1 protected override void OnPreRender(EventArgs e)
2 {
3
4 base.OnPreRender(e);
5 }
6
1 protected override void OnPreRender(EventArgs e)
2 {
3
4 base.OnPreRender(e);
5 }
6
二、用ajaxToolkit:CascadingDropDown控件时出现的[Method error 500]错误和[Method error 12031]错误
原因:在调用webservice方法前面都要加[WebMethod]
Code
1using System;
2using System.Collections;
3using System.Web;
4using System.Web.Services;
5using System.Web.Services.Protocols;
6using System.Collections.Generic;
7using System.Collections.Specialized;
8using System.Data;
9using System.Data.SqlClient;
10using MRAPS.Common;
11using AjaxControlToolkit;
12
13/**//// <summary>
14///SNWebService 的摘要说明
15/// </summary>
16[WebService(Namespace = "http://tempuri.org/")]
17[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
18[System.Web.Script.Services.ScriptService]
19[Microsoft.Web.Script.Services.ScriptService()]
20public class SNWebService : System.Web.Services.WebService
21{
22
23 public SNWebService()
24 {
25
26 //如果使用设计的组件,请取消注释以下行
27 //InitializeComponent();
28 }
29 /**//// <summary>
30 /// 获取省份数据
31 /// </summary>
32 /// <param name="knownCategoryValues"></param>
33 /// <param name="category"></param>
34 /// <returns></returns>
35 [WebMethod]
36 public CascadingDropDownNameValue[] GetProvinceContents(string knownCategoryValues, string category)
37 {
38 List<CascadingDropDownNameValue> provinceList = new List<CascadingDropDownNameValue>();
39 string sqlString = "select * from Province where State=1";
40 SqlDataReader sdrProvince = SqlHelper.ExecuteReader(SqlHelper.conn, CommandType.Text, sqlString);
41 while (sdrProvince.Read()) {
42 provinceList.Add(new CascadingDropDownNameValue(sdrProvince["Name"].ToString(), sdrProvince["Code"].ToString()));
43 }
44 return provinceList.ToArray();
45 }
46 /**//// <summary>
47 /// 获取城市信息
48 /// </summary>
49 /// <param name="knownCategoryValues"></param>
50 /// <param name="category"></param>
51 /// <returns></returns>
52 [WebMethod]
53 public CascadingDropDownNameValue[] GetCityContents(string knownCategoryValues, string category)
54 {
55 StringDictionary provinceList = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
56 List<CascadingDropDownNameValue> cityList = new List<CascadingDropDownNameValue>();
57 string sqlString = "select * from City where ProvinceID='" + provinceList["Province"] + "' and State=1";
58 SqlDataReader sdrCity = SqlHelper.ExecuteReader(SqlHelper.conn, CommandType.Text, sqlString);
59 while (sdrCity.Read()) {
60 cityList.Add(new CascadingDropDownNameValue(sdrCity["Name"].ToString(), sdrCity["Code"].ToString()));
61 }
62 return cityList.ToArray();
63 }
64 /**//// <summary>
65 /// 获取县区信息
66 /// </summary>
67 /// <param name="knownCategoryValues"></param>
68 /// <param name="category"></param>
69 /// <returns></returns>
70 [WebMethod]
71 public CascadingDropDownNameValue[] GetZoneContents(string knownCategoryValues, string category)
72 {
73 StringDictionary cityList = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
74 List<CascadingDropDownNameValue> zoneList = new List<CascadingDropDownNameValue>();
75 string sqlString = "select * from Zone where CityID='" + cityList["City"] + "' and state=1";
76 SqlDataReader sdrZone = SqlHelper.ExecuteReader(SqlHelper.conn, CommandType.Text, sqlString);
77 while (sdrZone.Read()) {
78 zoneList.Add(new CascadingDropDownNameValue(sdrZone["Name"].ToString(), sdrZone["Code"].ToString()));
79 }
80 return zoneList.ToArray();
81 }
82}
1using System;
2using System.Collections;
3using System.Web;
4using System.Web.Services;
5using System.Web.Services.Protocols;
6using System.Collections.Generic;
7using System.Collections.Specialized;
8using System.Data;
9using System.Data.SqlClient;
10using MRAPS.Common;
11using AjaxControlToolkit;
12
13/**//// <summary>
14///SNWebService 的摘要说明
15/// </summary>
16[WebService(Namespace = "http://tempuri.org/")]
17[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
18[System.Web.Script.Services.ScriptService]
19[Microsoft.Web.Script.Services.ScriptService()]
20public class SNWebService : System.Web.Services.WebService
21{
22
23 public SNWebService()
24 {
25
26 //如果使用设计的组件,请取消注释以下行
27 //InitializeComponent();
28 }
29 /**//// <summary>
30 /// 获取省份数据
31 /// </summary>
32 /// <param name="knownCategoryValues"></param>
33 /// <param name="category"></param>
34 /// <returns></returns>
35 [WebMethod]
36 public CascadingDropDownNameValue[] GetProvinceContents(string knownCategoryValues, string category)
37 {
38 List<CascadingDropDownNameValue> provinceList = new List<CascadingDropDownNameValue>();
39 string sqlString = "select * from Province where State=1";
40 SqlDataReader sdrProvince = SqlHelper.ExecuteReader(SqlHelper.conn, CommandType.Text, sqlString);
41 while (sdrProvince.Read()) {
42 provinceList.Add(new CascadingDropDownNameValue(sdrProvince["Name"].ToString(), sdrProvince["Code"].ToString()));
43 }
44 return provinceList.ToArray();
45 }
46 /**//// <summary>
47 /// 获取城市信息
48 /// </summary>
49 /// <param name="knownCategoryValues"></param>
50 /// <param name="category"></param>
51 /// <returns></returns>
52 [WebMethod]
53 public CascadingDropDownNameValue[] GetCityContents(string knownCategoryValues, string category)
54 {
55 StringDictionary provinceList = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
56 List<CascadingDropDownNameValue> cityList = new List<CascadingDropDownNameValue>();
57 string sqlString = "select * from City where ProvinceID='" + provinceList["Province"] + "' and State=1";
58 SqlDataReader sdrCity = SqlHelper.ExecuteReader(SqlHelper.conn, CommandType.Text, sqlString);
59 while (sdrCity.Read()) {
60 cityList.Add(new CascadingDropDownNameValue(sdrCity["Name"].ToString(), sdrCity["Code"].ToString()));
61 }
62 return cityList.ToArray();
63 }
64 /**//// <summary>
65 /// 获取县区信息
66 /// </summary>
67 /// <param name="knownCategoryValues"></param>
68 /// <param name="category"></param>
69 /// <returns></returns>
70 [WebMethod]
71 public CascadingDropDownNameValue[] GetZoneContents(string knownCategoryValues, string category)
72 {
73 StringDictionary cityList = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
74 List<CascadingDropDownNameValue> zoneList = new List<CascadingDropDownNameValue>();
75 string sqlString = "select * from Zone where CityID='" + cityList["City"] + "' and state=1";
76 SqlDataReader sdrZone = SqlHelper.ExecuteReader(SqlHelper.conn, CommandType.Text, sqlString);
77 while (sdrZone.Read()) {
78 zoneList.Add(new CascadingDropDownNameValue(sdrZone["Name"].ToString(), sdrZone["Code"].ToString()));
79 }
80 return zoneList.ToArray();
81 }
82}