Ajax WebService provincial Linkage

Ajaxcontroltoolkit Control

Create a service WebService

WebService. CS

Using system; using system. web; using system. collections; using system. web. services; using system. web. services. protocols; using system. web. script. services; using system. collections. generic; using system. collections. specialized; using ajaxcontroltoolkit; using system. data. sqlclient; using system. data; // <summary> // Summary of snwebservice // </Summary> [WebService (namespace = "http://tempuri.org/")] [webservicebinding (conformsto = wsiprofiles. basicprofile1_1)] [scriptservice] public class snwebservice: system. web. services. webService {public snwebservice () {// If the designed component is used, uncomment the following line // initializecomponent ();} /// <summary> /// obtain province data /// </Summary> /// <Param name = "knowncategoryvalues"> </param> /// <Param name = "category"> </param> // <returns> </returns> [webmethod] public cascadingdropdownnamevalue [] getprovincecontents (string knowncategoryvalues, string category) {list <cascadingdropdownnamevalue> provincelist = new list <cascadingdropdownnamevalue> (); string connectionstring = system. configuration. configurationmanager. appsettings ["connectionstring"]; sqlconnection sqlconn = new sqlconnection (connectionstring); sqlconn. open (); string strsql = "select * From Province"; sqlcommand sqlcmd = new sqlcommand (strsql, sqlconn); sqldatareader dtrprovince = sqlcmd. executereader (); While (dtrprovince. read () {provincelist. add (New cascadingdropdownnamevalue (dtrprovince ["name"]. tostring (), dtrprovince ["code"]. tostring ();} dtrprovince. close (); sqlconn. close (); Return provincelist. toarray ();} /// <summary> /// obtain City Data /// </Summary> /// <Param name = "knowncategoryvalues"> </param> /// <Param name = "category"> </param> // <returns> </returns> [webmethod] public cascadingdropdownnamevalue [] getcitycontents (string knowncategoryvalues, string category) {stringdictionary provincelist = cascadingdropdown. parseknowncategoryvaluesstring (knowncategoryvalues); string connectionstring = system. configuration. configurationmanager. appsettings ["connectionstring"]; sqlconnection sqlconn = new sqlconnection (connectionstring); sqlconn. open (); string strsql = "select * from city where provinceid = '" + provincelist ["Province"] + "'"; sqlcommand sqlcmd = new sqlcommand (strsql, sqlconn ); sqldatareader dtrcity = sqlcmd. executereader (); List <cascadingdropdownnamevalue> citylist = new list <cascadingdropdownnamevalue> (); While (dtrcity. read () {citylist. add (New cascadingdropdownnamevalue (dtrcity ["name"]. tostring (), dtrcity ["code"]. tostring ();} dtrcity. close (); Return citylist. toarray ();} /// <summary> /// obtain township data /// </Summary> /// <Param name = "knowncategoryvalues"> </param> /// <Param name = "category"> </param> // <returns> </returns> [webmethod] public cascadingdropdownnamevalue [] getviliagecontents (string knowncategoryvalues, string category) {stringdictionary citylist = cascadingdropdown. parseknowncategoryvaluesstring (knowncategoryvalues); string connectionstring = system. configuration. configurationmanager. appsettings ["connectionstring"]; sqlconnection sqlconn = new sqlconnection (connectionstring); sqlconn. open (); string strsql = "select * from area where cityid = '" + citylist ["city"] + "'"; sqlcommand sqlcmd = new sqlcommand (strsql, sqlconn ); sqldatareader dtrviliage = sqlcmd. executereader (); List <cascadingdropdownnamevalue> viliagelist = new list <cascadingdropdownnamevalue> (); While (dtrviliage. read () {viliagelist. add (New cascadingdropdownnamevalue (dtrviliage ["name"]. tostring (), dtrviliage ["ID"]. tostring ();} dtrviliage. close (); Return viliagelist. toarray ();}}