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);
}
