script type="text/javascript">
$(function() {
$("#names").autocomplete({
source:function(requestresponse){
$.ajax(){
url:"Default.aspx/getAreas",
data:"{'name':' + request.term + '"city' :' +$(#dd span:first).text() +"}",
datatype:"json",
ContentType:"application/json;charset=utf-8;",
dataFilter:function(data) {
return data;}
success: function(data) {
(response ($.map,data.d,function(item)
{
return
label:item,
value:item
))
}
)}
},
error:Function(XmlHttpRequest,textstatus,errorthrown)
alert(textstatus);
})
minlength:0
}).click(function() {
$(this).autocomplete("search");
});
});
});
</script>
/* Code-Behind */Default.aspx.cs
[WebMethod(EnableSession = true)]
public static List<string> getAreas(string name, string city)
{
return DataManager.getAllAreas(city , name);
}
/* Code-Behind */DataManager.cs
public static string getConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["RFConnectionString"].ConnectionString;
}
public static List<string> getAllAreas(string city, string area)
{
DataSet ds = new DataSet();
try
{
SqlConnection conn = new SqlConnection(getConnectionString());
SqlCommand cmd = new SqlCommand("[GetAreas]", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cityname", SqlDbType.VarChar);
cmd.Parameters.Add("@areaname", SqlDbType.VarChar);
cmd.Parameters["@cityname"].Value = city;
cmd.Parameters["@areaname"].Value = area;
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
List<string> s = ds.Tables[0].AsEnumerable().Select(x => x[0].ToString()).ToList();
return s;
}
catch
{
return null;
}
}
Ramu.R
Laghaterohan, if this helps please login to Mark As Answer. | Alert Moderator