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.
Unfortunately, activation email could not send to your email. Please try again.

How can i make chart and gird by using SqlDataSource

Thread ID:

Created:

Updated:

Platform:

Replies:

124787 Jun 30,2016 01:38 AM Jun 30,2016 08:53 AM ASP.NET Web Forms 1
loading
Tags: Chart
kyousuke
Asked On June 30, 2016 01:38 AM

I made a chart and a grid by using SqlDataSource . But it can't move on browser.

please look following my source cord. How can i make chart and grid by  using SqlDataSource.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="linechart2.aspx.cs" Inherits="SyncfusionASPNETApplication1.linechart2" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>&nbsp;<body><form id="form1" runat="server">
        
    <div>
    
    </div>


        <ej:WaitingPopup runat="server" ID="waitingpopup" ShowOnInit="false"></ej:WaitingPopup>
        <ej:Grid ID="Grid1" runat="server" DataMember="DefaultView" DataSourceCachingMode="None" DataSourceID="sample" MinWidth="0">
<ContextMenuSettings CustomContextMenuItem="(コレクション)" EnableContextMenu="True"></ContextMenuSettings>

            <Columns>
                <ej:Column DataType="number" Field="day" IsPrimaryKey="True">
                </ej:Column>
                <ej:Column DataType="number" Field="volume">
                </ej:Column>
            </Columns>

<PageSettings Template=""></PageSettings>

<RowDropSettings DropTargetID="" DropMapper=""></RowDropSettings>

<ScrollSettings EnableTouchScroll="False"></ScrollSettings>
    </ej:Grid>
        <ej:Chart ID="Chart1" runat="server" DataSourceID="sample" Width="900" Height="600" SeriesType="Column" Text="Product Details">
            <PrimaryXAxis  LabelIntersectAction="Trim"></PrimaryXAxis>
            <CommonSeriesOptions Tooltip-Visible="true" />
            <Series>
                <ej:Series Name="UnitPrice" XName="day" YName="volume" Type="Bar"></ej:Series>
            </Series>
            <Title Text="Product Details"></Title>
        </ej:Chart>
        <asp:SqlDataSource ID="sample" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Table]"></asp:SqlDataSource>
    <br />
    </form>
</body>
</html>

Thank you for your help
Regards
kyousuke

Dharanidharan Dharmasivam [Syncfusion]
Replied On June 30, 2016 08:53 AM

Hi Kyousuke, 
 
Thanks for using the Syncfusion product. 
 
Based on your requirement, we have created a sample with grid and chart using SqlDataSource. For your reference, we have attached the sample, kindly find the sample from the attachment. Please find the screenshot below. 
 
Screenshot: 
 
 
 

For more information about SqlDatsource with grid,  please refer to the below Help document. 
 

Online demo: 
 
 
 
Thanks,  
Dharani. 


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.

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.

;