Code Snippet:
$.ajax({
type: "POST",
url: "../../web/WebForm1.aspx/LiveData",
data: JSON.stringify({ "date": dateVal, "val": rn }),
contentType: "application/json; charset=utf-8",
dataType: 'json',
success: function (data) {
console.log('success', data);
},
error: function (jqXHR, textStatus, errorThrown) {
alert('Exeption:' + errorThrown);
}
});
WebForm1.aspx.cs
[WebMethod]
public static DateTime LiveData(DateTime date, int val)
{
SqlConnection con = new SqlConnection();
// Date Source connection
con.ConnectionString = "Data Source=SYNCLAPN136;Initial Catalog=Testdata;Integrated Security=True;Connect Timeout=30";
con.Open();
cmd.Parameters.Add("@y", val);
cmd.ExecuteNonQuery();
con.Close();
return date;
} |
|
[JS]
function insertData()
{
var chartobj = $("#chartContainer").ejChart("instance");
var startDate = chartobj.model.series[0].points[chartobj.model.series[0].points.length - 1].x;
var addDate = new Date(startDate.setDate(startDate.getDate() + 1));
var random = parseInt(getRandomInt(20, 50));
$.ajax({
type: "POST",
url: "../../web/WebForm1.aspx/insertDatas",
data: JSON.stringify({ "date": addDate, "val": random }),
contentType: "application/json; charset=utf-8",
dataType: 'json',
success: function (data) {
length = data.d.length;
datas = data.d;
endxValue = new Date(data.d[length - 1].xvalue);
for (var i = 0; i < data.d.length; i++) {
data.d[i].xvalue = new Date(data.d[i].xvalue);
}
var chartobj = $("#chartContainer").ejChart("instance");
chartobj.model.series[0].dataSource = datas;
chartobj.model.series[0].xName = "xvalue";
chartobj.model.series[0].yName = "yvalue";
chartobj.model.series[0].fill = "#ff33cc";
chartobj.redraw();
},
error: function (jqXHR, textStatus, errorThrown) {
}
});
}
[ASPX.CS]
[WebMethod]
public static List<data1> insertDatas(DateTime date, int val)
{
List<data1> list1 = new List<data1>();
string connectionString = null;
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet dataset = new DataSet();
connectionString = @"Data Source=SYNCLAPN7425;Initial Catalog=TestData;Integrated Security=True";
SqlConnection con = new SqlConnection(connectionString);
con.Open();
cmd.Parameters.Add("@y", val);
cmd.ExecuteNonQuery();
string command2 = "select * from Table_1";
SqlCommand cmd1 = new SqlCommand(command2, con);
adapter.SelectCommand = cmd1;
adapter.Fill(dataset);
for (var i = 0; i < dataset.Tables[0].Rows.Count;i++ )
{
string x = (string)dataset.Tables[0].Rows[i].ItemArray[0].ToString();
int y = (int)dataset.Tables[0].Rows[i].ItemArray[1];
list1.Add(new data1(x, y));
}
con.Close();
return list1;
} |