public string GetCities(string tag) { DataSet ds = new DataSet(); MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["cardleymerchantnewConnectionString"].ConnectionString.ToString()); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = new MySqlCommand("getcities", conn); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; adapter.SelectCommand.Parameters.AddWithValue("tag", tag); adapter.Fill(ds); List <cardleycity> cities = new List <cardleycity>(); foreach (DataRow dr in ds.Tables[0].Rows) { cardleycity city = new cardleycity(); city.id = dr["cityid"].ToString(); city.name = dr["name"].ToString(); city.statecode = dr["statecode"].ToString(); city.code = dr["citycode"].ToString(); cities.Add(city); } JavaScriptSerializer serializer = new JavaScriptSerializer(); string output = Newtonsoft.Json.JsonConvert.SerializeObject(cities);// serializer.Serialize(cities); return(output); }
public string GetCities(string tag) { DataSet ds = new DataSet(); MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["cardleymerchantnewConnectionString"].ConnectionString.ToString()); MySqlDataAdapter adapter = new MySqlDataAdapter(); adapter.SelectCommand = new MySqlCommand("getcities", conn); adapter.SelectCommand.CommandType = CommandType.StoredProcedure; adapter.SelectCommand.Parameters.AddWithValue("tag", tag); adapter.Fill(ds); List<cardleycity> cities = new List<cardleycity>(); foreach (DataRow dr in ds.Tables[0].Rows) { cardleycity city = new cardleycity(); city.id = dr["cityid"].ToString(); city.name = dr["name"].ToString(); city.statecode = dr["statecode"].ToString(); city.code = dr["citycode"].ToString(); cities.Add(city); } JavaScriptSerializer serializer = new JavaScriptSerializer(); string output = Newtonsoft.Json.JsonConvert.SerializeObject(cities);// serializer.Serialize(cities); return output; }