protected void Page_Load(object sender, EventArgs e) { List <Continents> listcountinent = new List <Continents>(); string CS = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { con.Open(); SqlCommand cmd = new SqlCommand("Select Continent, Roadways, CountriesNO from Continents", con); using (SqlDataReader rdr = cmd.ExecuteReader()) { if (rdr != null) { while (rdr.Read()) { Continents continents = new Continents(); continents.Continent = rdr["Continent"].ToString(); continents.Roadways = Convert.ToInt32(rdr["Roadways"]); continents.CountriesNO = Convert.ToInt32(rdr["CountriesNO"]); listcountinent.Add(continents); } } } JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); string jsonString = javaScriptSerializer.Serialize(listcountinent); Response.Write(jsonString); System.IO.File.WriteAllText(@"D:\documents\C# Programs\ContinentPieChart\Continentes.json", jsonString); } }
protected void Page_Load(object sender, EventArgs e) { string CS = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string query = "Select CountryName, Capital, Continent from Country inner join Continents on Country.ContinentID= Continents.ID"; List <Country> listcountinent = new List <Country>(); using (SqlConnection con = new SqlConnection(CS)) { con.Open(); using (SqlCommand cmd = new SqlCommand(query, con)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { sda.SelectCommand = cmd; using (DataSet ds = new DataSet()) { sda.Fill(ds); int count = ds.Tables.Count; for (int i = 0; i < count; i++) { foreach (DataRow dr in ds.Tables[i].Rows) { var dict = new Dictionary <string, object>(); Country country = new Country(); Continents continents = new Continents(); string jsonname = Convert.ToString(ds); foreach (DataColumn col in ds.Tables[i].Columns) { country.CountryName = dr["CountryName"].ToString(); country.Capital = dr["Capital"].ToString(); country.Continent = dr["Continent"].ToString(); } //Response.Write(jsonname); listcountinent.Add(country); } } } } } } JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); string jsonString = javaScriptSerializer.Serialize(listcountinent); Response.Write(jsonString); System.IO.File.WriteAllText(@"D:\documents\C# Programs\ContinentPieChart\Count.json", jsonString); }