AJAX :: Populate Control Toolkit Line Chart Using SQL Server Database
Feb 20, 2013
I work with a charline (ajax control toolkit) and I want to manipulate from code behind but I do not really know how! I have an example but the data are in the aspx code.
<ajaxToolkit:LineChart ID="LineChart1" runat="server"
ChartWidth="450" ChartHeight="300" ChartType="Basic"
ChartTitle="United States versus European Widget Production"
CategoriesAxis="2007,2008,2009,2010,2011,2012"
ChartTitleColor="#0E426C" CategoryAxisLineColor="#D08AD9"
[code]....
View 1 Replies
Similar Messages:
Feb 1, 2014
I am currently making a line chart of Ajax control toolkit referring to an article [URL] .....
It works fines as described. My question is how to reverse Y axis of the line chart.
I need to place 1 (not 0) at the top of Y axis and biggest number near the bottom with some margin from axis X. The described chart is biggest number neat the top and 0 at the bottom.
View 1 Replies
Feb 22, 2013
how to work with multiple series! for example: with 2 series and display the name of each series in the graph! like this example: URL...
View 1 Replies
Dec 10, 2013
I followed the article found in below link. When i run the page, only one line gets generated according to the values retireved last. URL....
C#
string query = string.Format("SELECT CHAR(CDATE, ISO),CSCUNITPRICE FROM UNITZ.DAILYLOG where fundcode = 'BAL'");
DataTable dt = GetData(query);
string[] x = new string[dt.Rows.Count];
decimal[] y = new decimal[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
[code].....
View 1 Replies
May 7, 2015
I have downloaded the ajax toolkit control i been using it for a couple of months now. But I cannot see Ajax toolkit pie chart control..
Why will I get it ? Do I have to download seperately?
View 1 Replies
May 7, 2015
This is my aspx code :
<asp:Chart ID="ChartAlertes" runat="server" Width="500px">
<Titles>
<asp:Title Text="Nombre d'alertes et leurs status en fonction des filtres renseignés"
BorderColor="Black" Alignment="TopCenter">
</asp:Title>
</Titles>
[code]...
I display 2 Points (2 columns) in the Chart Control and I change the color of the each Points with :
ChartAlertes.Series[0].Points[0].Color = System. Drawing. Color.Red;ChartAlertes.Series[0].Points[1].Color = System.Drawing.Color.DarkOrange;
But sometimes, I have only 1 Point to display or nothing at all on the Chart. So I'd like to check If there are some Points before to put the color of each Point.
For example :
if (ChartAlertes.Series[0].Empty == false)
{
//...
}
View 1 Replies
Mar 6, 2013
I work with a tank of visual studio when I click to display the graph he shows not all points on the X axis
for example the table nbr_num_semaine_av contains values in order
(18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,1,2,3,4)
but the graph shows on the X axis only that 18, 38, 41
for (int k = 0; k < semaine.Count(); k++) {
Chart4.Series["Nombre de points terminés"].Points.AddXY(nbr_num_semaine_av[k], nbr_points_Termin[k]);
Chart4.Series["Nombre Total d'element"].Points.AddXY(nbr_num_semaine_av[k], nbr_element.Count());
}
Chart4.Series["Nombre de points terminés"].ChartType = SeriesChartType.Line;
Chart4.Series["Nombre Total d'element"].ChartType = SeriesChartType.Line;
Chart4.Series["Nombre de points terminés"].IsXValueIndexed = true;
Chart4.Visible = true;
View 1 Replies
Jan 21, 2014
I need to display the data as pie chart,bar charts(2D,3D) here data is JSON data. any nice articles using jquery or java script free plugins ?
View 1 Replies
Jul 15, 2010
I have data in data table like below.
I am trying to make graph like below using asp.net chart control (made graph in excel with some test data)
points are X and Y values. lines are linear, exponential, logarithmic and power values.
how can I make this chart in asp.net (vb.net or c#)? I am newbie to chart control.
View 1 Replies
May 7, 2015
C#:
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
LineGraphFunction();
}
}
//code for line graph
protected void LineGraphFunction()
[code]....
HTML:
<cc1:LineChart ID="LineChart1" Width="500px" runat="server" ChartHeight="300" ChartWidth = "450" TooltipBorderColor="#D8D8D8" TooltipFontColor="blue"
ChartType="Basic" ChartTitleColor="#0E426C" Visible = "false" BorderColor="Blue" BorderWidth="1px"
CategoryAxisLineColor="#D08AD9" ValueAxisLineColor="#D08AD9" BaseLineColor="#A156AB">
</cc1:LineChart>
Problem is:
In the "LineChart", everytime last "y-axis" point is going out of graph (i.e., somewhere in the footer of x-axis)
X-axis Y-axis
3.4 5.2
5.3 7
2 8.7
1) like in above table, all the point will plot except the last x-axis and y-axis points. Also, y-axis value = 8.7 goes away from graph and comes in the footer of x-axis line.
2) like if x-axis = 3, y-axis=6, then 6 goes out of the graph and comes in footer of x-axis line.
But this problem occurs only when Im using SELECT query for a "particular Id" i.e.,
SELECT x,y from Table1 where Id='Gaug9' and DeletionDate is null
If I will remove where Id=' ' then it will work fine. But I need to plot graph based on particular Id's.
View 1 Replies
Dec 8, 2010
I am Getting the following error using the Numeric UpDown Control from Ajax Control Toolkit.
Assembly 'AjaxControlToolkit, Version=3.0.30512.20315, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e' contains a Web resource with name 'AjaxControlToolkit.NumericUpDown.NumericUpDownBehavior.debug.js', but does not contain an embedded resource with name 'AjaxControlToolkit.NumericUpDown.NumericUpDownBehavior.debug.js'.
View 2 Replies
Apr 13, 2010
I have created an application in Microsoft Visual studio 2005. And I have used Ajax control tool kit version
3.031106.0. It works fine in my local system. When I hosted this on the server,I am getting this following error.
"Could not load file or assembly 'AjaxControlToolkit, Version=1.0.10606.0, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e' or one of its dependencies"
The server is Windows server 2008.
View 1 Replies
Jul 6, 2010
I have used AJAX toolkit control extender in my site(ASP.net with C#).
When i uploaded my site to the production server it gives the error for ajax toolkit extender.
When i replaced the toolkit script manager with regular script manager the site is working fine but the extended control are not working.
I have contacted to the production server team they are saying we have already provided the facility for ajax toolkit.
View 2 Replies
Oct 26, 2013
how o create menue and sub menue from data base?
View 1 Replies
Oct 19, 2013
How to bind TreeView Control in asp.net using C# code?
View 1 Replies
May 7, 2015
URL....i want to change color of each point in this chart control
View 1 Replies
May 7, 2015
I use a LineChart control in asp.net and C# but I have a problem because my linechart in my page is black..
This is a screenshot (i did Ctrl + A to show you there are data on this chart) ....
View 1 Replies
Jan 24, 2011
I am using following server side code to save the data from ASP.NET Control toolkit Editor to the database It follows with the HTML Code The problem is that, data is saved successfully. But it is saved twice. Main problem is this server side event is fired twice. How can i prevent it from firing twice?
Server side code
Imports System.Data.SqlClient
Partial Class Administrator_Calendar
Inherits System.Web.UI.Page
Protected Sub BtnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnAdd.Click
Try
Dim dbobj As New db
Dim i As Integer = 0
Dim rdr As SqlDataReader = dbobj.selectQuery("select max(srno) from calendar")
If rdr.HasRows = True Then
rdr.Read()
i = rdr.Item(0)
End If
rdr.Close()
dbobj.insertQuery("insert into calendar values (" & i + 1 & " , '" & Me.Txt_dt.Text & "' , '" & Me.Editor1.Content & "')")
dbobj = Nothing
Catch ex As Exception
End Try
End Sub
End Class
HTML CODE
<%@ Page Language="VB" MasterPageFile="~/MasterPages/Admin_AftrLogin.master" AutoEventWireup="false"
CodeFile="Calendar.aspx.vb" Inherits="Administrator_Calendar" Title="Excel Crop Care Ltd. / Administration Section / Manage Calendar..." %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit.HTMLEditor"
TagPrefix="cc2" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" runat="Server">
<div>
<cc1:TabContainer ID="TabContainer1" runat="server" ActiveTabIndex="0">
<cc1:TabPanel runat="server" HeaderText="Selected Dates" ID="TabPanel1">
<ContentTemplate>
<asp:GridView ID="Gridview1" runat="server" AutoGenerateColumns="False" DataKeyNames="srno"
DataSourceID="SqlDataSource1">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True">
<ItemStyle Width="20%" />
</asp:CommandField>
<asp:BoundField DataField="srno" HeaderText="No." ReadOnly="True" SortExpression="srno">
<ItemStyle Width="10%" />
</asp:BoundField>
<asp:BoundField DataField="date" HeaderText="Date" SortExpression="date">
<ItemStyle Width="30%" />
</asp:BoundField>
<asp:BoundField DataField="description" HeaderText="Description" SortExpression="description" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DataConnectionString %>"
SelectCommand="SELECT * FROM [calendar]" UpdateCommand="Update calendar set date=@date,description=@description where srno=@srno"
DeleteCommand="Delete from calendar where srno=@srno"></asp:SqlDataSource>
</ContentTemplate>
</cc1:TabPanel>
<cc1:TabPanel ID="TabPanel2" runat="server" HeaderText="Add New">
<ContentTemplate>
<table>
<tr>
<td width="30%">
Date :
</td>
<td>
<asp:TextBox ID="Txt_dt" runat="server" Height="16px" Width="170px" CausesValidation="True"
Font-Names="Verdana" ForeColor="#666666"></asp:TextBox>
<asp:ImageButton runat="Server" ID="Image1" ImageUrl="../Images/Calendar_scheduleHS.png"
AlternateText="Click to show calendar" /><br />
<cc1:CalendarExtender ID="Txt_dt_CalendarExtender" runat="server" DaysModeTitleFormat="dd/MM/yy"
Enabled="True" Format="dd/MM/yy" TargetControlID="Txt_dt" PopupButtonID="Image1">
</cc1:CalendarExtender>
<cc1:TextBoxWatermarkExtender ID="Txt_dt_TextBoxWatermarkExtender" runat="server"
Enabled="True" TargetControlID="Txt_dt" WatermarkText="DD/MM/YY">
</cc1:TextBoxWatermarkExtender>
<cc1:MaskedEditExtender ID="Txt_dt_MaskedEditExtender" runat="server" MaskType="Date"
CultureDateFormat="dd/MM/yy" Enabled="True" TargetControlID="Txt_dt" Century="2000"
UserDateFormat="DayMonthYear" Mask="99/99/99">
</cc1:MaskedEditExtender>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Label ID="Lbl_msg" runat="server" Text="Enter description in the editor below :"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2">
<cc2:Editor ID="Editor1" runat="server" Height="350px" />
</td>
</tr>
<tr>
<td colspan="2" align="center">
<asp:Button ID="BtnAdd" runat="server" Text="Add" OnClick="BtnAdd_Click" Width="75px"
CssClass="btn" />
<asp:Button ID="Btn_Rem" runat="server" Text="Remove" OnClick="BtnAdd_Click" Width="75px"
CssClass="btn" />
</td>
</tr>
</table>
</ContentTemplate>
</cc1:TabPanel>
</cc1:TabContainer>
</div>
</asp:Content>
View 1 Replies
Jan 14, 2011
I just installed Ajax Toolkit. The controls are available in my Toolbox, but when I insert them in a page, Visual Studio underlines them with the error message "unknown server tag".
I googled the problem and found several ideas :
check if the DLL is in Bin folder check if ajaxToolKit tags prefix is registered in web.config and make sure I'm not using a different prefix in my pages check if the DLL is registered in the pages with <% @ Register ... %>
Unfortunately all of this is fine, but I still can't get the controls to work. Is something else missing ?
EDIT : My environment is ASP.Net 2.0, Ajax Extensions 1.0, Ajax Toolkit 1.0.20229, Visual Studio 2005
View 1 Replies
Jun 7, 2010
On my X Axis, I have months. The chart shows up to 11 points, i.e. Jan - Nov of the same year, but when I add 12 points (Jan - Dec), it will do an auto label thing and change the interval for every 4 months.
How can I change the graph so that it shows 12 months before it does the auto labels?
Here is the server control code I am currently using.
[code]....
View 1 Replies
May 7, 2015
I am using most of the Ajax Control, but when I deployed it in IIS. It is not working.
View 1 Replies
Feb 21, 2011
am using VS 2010.I am new to this (AJAX RAD Controls/AJAX RAD Charts).I am having an xml file having 3 tables.Now my requirement is to plot a Stacked bar Chart dynamically retrieving values from different tables.
I have retrive values from different table into One Datatable named "ValuesToDisplay"
05:30 06:00 06:30 07:00 07:30 08:00 08:30 09:00 09:30 10:00 10:30
View 2 Replies
Jul 19, 2012
I am very new to .NET platform (from a PHP background) and I am developing a simple multi-step online form. The user can come back and edit the form after they have initially completed it.User clicks edit form. The information saved in the database is retrieved and populated in the form elements like textbox, dropdown box, image files. And this is all inside a wizard control.
I can do this in a gridview using datasource and databind but the datasource doesn't seem to work with wizard.
View 1 Replies
Jul 29, 2013
Populate Menu and SubMenu Dynamically from Database using Repeater control in ASP.Net.
View 1 Replies
May 7, 2015
How to bind chart in datalist dynamically in asp.net c#.
View 1 Replies
