using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Web.Services;
public partial class ColumnChart : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) {
}
public class ChartDetails
{
public string ProductName { get; set; }
public int Pu { get; set; }
}
[WebMethod]// public static List GetChartData() public static List GetChartData() {
using (SqlConnection con = new SqlConnection(@"Data Source=(local);Initial Catalog=Venda;Integrated Security=True"))
{
SqlCommand cmd = new SqlCommand("Select Sum (ProductName), Pu From Produto", con);
// cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
List<ChartDetails> dataList = new List<ChartDetails>();
// List<ColumnChart> dataList = new List<ColumnChart>();
foreach (DataRow dtrow in dt.Rows)
{
ChartDetails details = new ChartDetails();
// ColumnChart details = new global::ColumnChart();
details.ProductName = dtrow[0].ToString();
details.Pu = Convert.ToInt32(dtrow[1]);
dataList.Add(details);
}
return dataList;
}
}} ASP.NET
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ColumnChart.aspx.cs" Inherits="ColumnChart" %>
