Pie chart using ASP.NET with AJAX Library

-
Step 1:

 Download latest  AjaxToolKit from  here . (Please download with compatible version of .net 3.5/4/4.5)

Step 2: 
 
  Add library to reference for solution.

Step 3:
 
  Default.aspx page code:

  <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
  
       <cc1:ToolkitScriptManager ID="scriptmanager1" runat ="server"></cc1:ToolkitScriptManager>
        <asp:DropDownList ID="ddlCountries" runat="server" OnSelectedIndexChanged="ddlCountries_SelectedIndexChanged"
            AutoPostBack="true">
        </asp:DropDownList>
        <hr />
        <cc1:piechart id="PieChart1" runat="server" chartheight="300"
        chartwidth="300" charttype="Column"
            charttitlecolor="#0E426C" visible="false">
        </cc1:piechart>
   
    </form>
</body>
</html>


Step 4:

  Default.aspx.cs page code:

    protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string query = "select distinct shipcountry from [Test].[dbo].[Ship_orders]";
                DataTable dt = GetData(query);
                ddlCountries.DataSource = dt;
                ddlCountries.DataTextField = "shipcountry";
                ddlCountries.DataValueField = "shipcountry";
                ddlCountries.DataBind();
                ddlCountries.Items.Insert(0, new ListItem("Select", ""));
            }
 
        }
        protected void ddlCountries_SelectedIndexChanged(object sender, EventArgs e)
        {
            string query = string.Format("SELECT  [shipCity],count([orderId]) TotalOrders FROM [Test].[dbo].[Ship_orders] where [shipCountry] ='{0}' group by shipcity", ddlCountries.SelectedItem.Value);
            DataTable dt = GetData(query);           
            PieChart PieChart1 = (PieChart)Page.FindControl("PieChart1");
            foreach (DataRow row in dt.Rows)
            {
               
                PieChart1.PieChartValues.Add(new AjaxControlToolkit.PieChartValue
                {
                    Category = row["ShipCity"].ToString(),
                    Data = Convert.ToDecimal(row["TotalOrders"])                  
                });
            }
            PieChart1.Visible = ddlCountries.SelectedItem.Value != "";          
        }
        private static DataTable GetData(string query)
        {
            DataTable dt = new DataTable();
            string constr = ConfigurationManager.ConnectionStrings["SQLServerConnectionString"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    using (SqlDataAdapter sda = new SqlDataAdapter())
                    {
                        cmd.CommandType = CommandType.Text;
                        cmd.Connection = con;
                        sda.SelectCommand = cmd;
                        sda.Fill(dt);
                    }
                }
                return dt;
            }
        }


Step 5: Make sql server connection with Table design as
         
           id                  int
           shipCity         nvarchar(50)
           orderId          int
           shipCountry    nvarchar(50)

Step 6: Note: [If you will get java runtime exception.then its browser issue]
           Above code only support IE 9 + , Firfox,Chrome .Does't support IE 8 Version
           So copy localhost url from IE 8 to any mention browsers

Step 7: Enjoy output




Comments

Post a Comment

Popular posts from this blog

Add Serial no in crystal report without coding

-
Image
Adding a serial number in grouping without any code. I have placed the step by step screenshots which will explain easily how to do it.   1) Add a new field in Running Total Fields in Field Explorer   Give a proper name to your Running total name. For example I have choosen here RTotal0. Now categorize based on which field in database you want to summarize it. Next is as we want serial number select count. If you want your serial number to start again from the start when the value in the group changes then select on change of group and specify the grouping name else keep the default value.   Smaple Preview of the Design View of Report where I Have added SRNo column at the start in grouping section.  
Read more

File operations in C# (.net)

-
Here we are performing some basic file operations which widely needed in applications. ASPX :     <div>         <asp:Button ID="Button1" runat="server" Text="CLick" onclick="Button1_Click" />         <asp:FileUpload ID="FileUpload1" runat="server" /><br /><br />          </div> C# :        using System.IO;        using System.Text;         protected void Button1_Click(object sender, EventArgs e)         {             string path = @"E:\MVC Application Demos\ABC.txt";            // File Path taken             string name = FileUpload1.FileName.ToString();                // Here we get File Name only             string path1 = FileUpload1.PostedFile.FileName.ToString();    // Here we get File Path only             if (File.Exists(path.ToString()))             {                      //     ClientScript.RegisterStartupScript(this.GetType(), "myalert"
Read more

SQL – Generate decimal numbers sequence for particular number range

-
Image
Friends, Sometimes we need mathematical assistance in SQL for such queries. Same here, it helps me to find challenging in all the way. Some of my friends helps me out to crack the records for my query, Here I am sharing simple solution for this, ;WITH cte      AS (SELECT Cast(-77 AS NUMERIC(22, 3)) AS num –Min value from your data          UNION ALL          SELECT Cast(num + 0.00001 AS NUMERIC(22, 5))          FROM   cte          WHERE  num < Cast(89 AS NUMERIC(22, 5))) — Max value from your data SELECT * FROM   cte OPTION (maxrecursion 0)  Try it 
Read more