BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
var db = Database.Open("BITool");
var myChart = new Chart(width: 835, height: 200, themePath: "chartThemeYellow.xml")
.AddTitle("Account Medical Orders")
.AddSeries("Default",
xValue: data, xField: "Segment",
yValues: data, yFields: "Orders")
.Write();
ASP.NET MVC:
Stored procedure:
CREATE PROCEDURE [dbo].[ChartData]
AS
BEGIN
SET NOCOUNT ON;
SELECT * FROM Orders
END
RETURN 0
View page:
@(Html.EJ().Chart("container")
.Load("chartLoad")
)
function chartLoad(sender) {
$.ajax({
type: "POST",
url: '@Url.Action("DataSource", "Home")',
async: false,
success: function (data) {
sender.model.series = [];
sender.model.series.push({ dataSource: data.result, xName: "OrderID", yName: "EmployeeID", type: "line" });
}
});
}
Controller:
public ActionResult DataSource(DataManager dm)
{
DataOperations operation = new DataOperations();
DataTable dt = new DataTable("Order");
string constring = ConfigurationManager.ConnectionStrings["NORTHWNDConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("ChartData", con))
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
// Load into the dataTable
dt.Load(dr);
dr.Close();
con.Close();
}
}
//Convert the dataTable into list
List<EditableOrder> resList = new List<EditableOrder>();
//...
return Json(new { result = resList }, JsonRequestBehavior.AllowGet);
}
|