We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Databse Connectivity in Live chart

Thread ID:

Created:

Updated:

Platform:

Replies:

117720 Dec 3,2014 04:29 AM UTC Dec 9,2014 03:22 AM UTC ASP.NET Web Forms 3
loading
Tags: Chart
Ramesh
Asked On December 3, 2014 04:29 AM UTC

Hi

I am exploring your Live Chart tool and I want to bind my data in live chart through the database, please help me how to achieve this.

Thanks

Jayavigneshwaran [Syncfusion]
Replied On December 5, 2014 09:38 AM UTC

Hi

I am exploring your Live Chart tool and I want to bind my data in live chart through the database, please help me how to achieve this.

Thanks

Hi Ramesh,

Thanks for using Syncfusion product.

We have analyzed your query.

And we made a sample which is updating lively with the data from the data source.

Find the sample from the below specified link.

Link: http://www.syncfusion.com/downloads/support/directtrac/132770/WebApplication1754256877.zip

 

Please let us know if you have any concern.

 

Thanks,

Jayavigneshwaran


Ramesh
Replied On December 8, 2014 12:41 PM UTC

Hi

As I mentioned before my requirements, but your sample is not retrieve data from database, its selecting data randomly. Please provide a sample as per requirements

Thanks

Jayavigneshwaran [Syncfusion]
Replied On December 9, 2014 03:22 AM UTC

Hi

As I mentioned before my requirements, but your sample is not retrieve data from database, its selecting data randomly. Please provide a sample as per requirements

Thanks

Hi Ramesh,

Sorry for the inconvenience caused.

 

We have modified the sample to take data from SQL data source and to render chart.

Hereby I have listed the steps to achieve this.


1.       Keep the mdf data source file locally in project. I have kept northwind.mdb file in app data folder.

2.       Create SQL data source element in ASP

[ASPX]

<asp:SqlDataSource ID="SqlData" runat="server" ConnectionString="<%$ ConnectionStrings:SQLConnectionString %>"

            SelectCommand="SELECT * FROM [Products] WHERE UnitPrice < 10"></asp:SqlDataSource>

 

3.       Add connection string in web.config file

[web.config]

        <add name="SQLConnectionString" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True"

   providerName="System.Data.SqlClient" />

4.       Code required to get the data of the data source and convert it to serialize string

[CS]

            var dv = new DataView();

            var dt = new DataTable();

            dv = SqlData.Select(DataSourceSelectArguments.Empty) as DataView;

            dt = dv.ToTable();  // data is get as data table

           

            foreach (DataRow dr in dt.Rows)

            {

                row = new Dictionary<string, object>();

                foreach (DataColumn col in dt.Columns)

                {

                    row.Add(col.ColumnName, dr[col]);

                }

                rows.Add(row); // converted to data column

            }

            a = serializer.Serialize(rows); // serialized to string

            Page.DataBind();

 

5.       Define a hidden element in aspx page and page the string to this elements text

[ASPX]

                       <%--a hidden field to get the value from code behind--%>

            <asp:Label ID="Label1" Text='<%#a%>' runat="server"/>

 

6.       Get the text value in aspx page and parse it to JSON object.

[JS]

           var a = $("#MainContent_Label1").text(); // get the value from the element

                var chartdata = JSON.parse(a);  // parse it to json values

7.       Bind it to chart and make require coding to render a live chart.

 

We have also made a sample to illustrate this. Find it from the below link.

Link: http://www.syncfusion.com/downloads/support/directtrac/132020/WebApplication12126491657.zip

 

Sample is coded in chart.aspx page. Kindly set chart.aspx as start page.

 

Please let us know if you have any concern.

 

Thanks,

Jayavigneshwaran


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;