AJAX :: Populate RGraph From Database Using JQuery
May 7, 2015
I am drawing the line graph from the following array
var abc=[20,30];
var line = new RGraph.Line('cvs', abc)
.set('spline', true)
.set('numxticks', 11)
.set('numyticks', 5)
.set('background.grid.autofit.numvlines', 11)
[Code] .....
and storing the same value in jquery session
$.session("abc",abc);
And retrieving the same value on button click and re drawing the graph but I am unable to draw it
I want to Bind div From the Parent Table and Get All Child item also in a div But I am not get that properly...
Jquery Code with html.
Testing.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Testing.aspx.cs" Inherits="WebApplication14.Testing" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[Code] ....
Web method For Retriving Data From the Database.
Getdata.asmx:-
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Services; using System.Configuration;
[Code] ....
Parent class
allclass.cs:-
using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebApplication14
[Code] ....
In this code how can we get data proper format like parent table data show and this data parent id in child table this child table data also show with parent table.
I am trying to implement google charts using sql database. I can not get the code to display charts on the client-side, as its currently blank page. I tried changing the str.append string but I still can not get the data to display on the client-side.
I want when user click one of item from menubar it go to Furniture.aspx and when it go to that page in furniture.aspx show my product related to that item i have Product table in my DB
Id Code Name Description H_name
1 1112 Iron This is test Electric 2 1113 Pot This is test Kitchen 3 1114 Chair This is test Furniture 4 1115 Laundry This is test Electric 5 1116 Container This is test Kitchen 6 1117 Sofa This is test Furniture
I want when user click on Kitchen from menubar in furniture.aspx show product that have H_name=Kitchen or if they click on Electric item from menubarin furniture.aspx show my product that have H_name=Electric
protected void Page_Load(object sender, EventArgs e) { Session["ID"] = "2"; string strConnString = ConfigurationManager.ConnectionStrings["BSDConnectionString"].ConnectionString; var con = new SqlConnection(strConnString); using (var sda = new SqlDataAdapter()) { SqlCommand cmd = new SqlCommand();
[Code] .....
That was my code , now lets see what my problem is :
I am getting only two dates in a single row from sql to my asp.net webform and then bindng those dates in jQuery UI Datepicker. Now if i set session to 1 then date picker works well but if i put session = 2 , it shows the end date till 2020 which is wrong.
Below are the dates which are fetched from database and i have copied here....
When Session["ID"] = "1";
Start Date : 01/07/2014 00:00:00 End Date : 05/02/2015 00:00:00
When Session["ID"] = "2";
Start Date : 07/04/2015 00:00:00 End Date : 27/08/2016 00:00:00
I have set my mindate to startdate and maxdate to end date....
Also point of interest is that if i don't fetch values from database and use only List<string> in my web method then every thing works well. Like this :
[WebMethod] public static List<string> GetDates() { List<string> arr = new List<string>(); arr.Add("2014-07-01"); arr.Add("2015-02-05"); return arr; }
i have a drop down list tied to a database called location.
what i hope to achieve is once a location is selected, my other drop down list will auto-populate a list of department in that location. how do i go about on connecting the two drop down list together so when location is changed, it connects to the appropriate row in the database?
I've tried Populate ASP.Net DataList by binding DataSet Client Side using jQuery AJAX posted in [URL] .... while binding records in datalist using JQuery there is no problem, i want to bind image inside of the datalist. There is a field imgpath which stores image path. Now i want to bind the image which path is stored in the database using JQuery.
I have dynamically popute the data in Dropdownlist(Countries) and the On selected index event of Dropdownlist there is noeed to bind /populate the Checkbox list from database depending on the selections made from the Dropdownlist.
For example If I select Gujrata then all the cities of Gujrat should be visible and bounded to the check box list.
2) Once the checkbox list is bounded with data from the database, We need to select the checkbox from the checkboxlist and pass tyhe selected text of all the selected checkboxes fro the checkbox list as comma seperated values to database and then I need to Display in the Grid.
Below is my code for Dynamically populated/Bind DropDown list and get the States:
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"
