如何使用sqlserver通过angularjs检索数据 [英] How to retrive data through angularjs with sqlserver

查看：139 发布时间：2019/6/22 17:40:31 C# ASP.NET C#4.0

本文介绍了如何使用sqlserver通过angularjs检索数据的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

大家好，
我正在尝试使用Sqlserver，Angular Js和下面的sql server数据库显示图表.是静态图表，但我想动态创建，您是否可以指导如何通过json格式的angular js从数据库中检索数据并绑定到d3js报告.

<！DOCTYPE html>
< meta charset ="utf-8">
< html>
< head>
< title> Angular.js nvd3.js折线图指令</title>
< meta http-equiv ="content-type" content ="text/html; charset = UTF8">
< script src ="js/angular.js"></script>
< script src ="js/d3.js"></script>
< script src ="js/nv.d3.js"></script>
< script src ="js/moment.js"></script>
< script src ="../dist/angularjs-nvd3-directives.js"></script>
< link rel ="stylesheet" href ="stylesheets/nv.d3.css"/>
< script>
var app = angular.module("nvd3TestApp"，["nvd3ChartDirectives"]);

函数示例Ctrl($ scope){
$ scope.exampleData = [
{
"key":系列1"，
值":[[1025409600000，0]，[1028088000000，-6.3382185140371]，[1030766400000，-5.9507873460847]，[1033358400000，-11.569146943813]，[1036040400000，-5.4767332317425]，[1038632400000，0.50794682203014]，[104131080000000000，-5.5310285460542 ]，[1043989200000，-5.7838296963382]，[1046408400000，-7.3249341615649]，[1049086800000，-6.7078630712489]，[1051675200000，0.44227126150934]，[1054353600000，7.2481659343222]，[1056945600000，9.2512381306992]，[1059624000000000000，11.341210982 14.734820409020]，[1064894400000、12.387148007542]，[1067576400000、18.436471461827]，[1070168400000、19.830742266977]，[1072846800000、22.643205829887]，[1075525200000、26.743156781239]，[1078030800000、29.597478802832]，[1080709200000、28.831 ，[1085976000000，29.294079423832]，[1088568000000，30.269264061274]，[1091246400000，24.934526898906]，[1093924800000，24.265982759 406]，[1096516800000、27.217794897473]，[1099195200000、30.802601992077]，[1101790800000、36.331003758254]，[1104469200000、43.142498700060]，[1107147600000、40.558263931958]，[1109566800000、42

Hi All,
I am trying to display chart using Sqlserver, Angular Js with sql server data base below. is static chart but i want to create dynamically can you guide how to retrive data through angular js in json format from database and bind to d3js reports.

<!DOCTYPE html>
<meta charset="utf-8">
<html>
<head>
<title>Angular.js nvd3.js Line Chart Directive</title>
<meta http-equiv="content-type" content="text/html; charset=UTF8">
<script src="js/angular.js"></script>
<script src="js/d3.js"></script>
<script src="js/nv.d3.js"></script>
<script src="js/moment.js"></script>
<script src="../dist/angularjs-nvd3-directives.js"></script>
<link rel="stylesheet" href="stylesheets/nv.d3.css"/>
<script>
var app = angular.module("nvd3TestApp", [''nvd3ChartDirectives'']);

function ExampleCtrl($scope){
$scope.exampleData = [
{
"key": "Series 1",
"values": [ [ 1025409600000 , 0] , [ 1028088000000 , -6.3382185140371] , [ 1030766400000 , -5.9507873460847] , [ 1033358400000 , -11.569146943813] , [ 1036040400000 , -5.4767332317425] , [ 1038632400000 , 0.50794682203014] , [ 1041310800000 , -5.5310285460542] , [ 1043989200000 , -5.7838296963382] , [ 1046408400000 , -7.3249341615649] , [ 1049086800000 , -6.7078630712489] , [ 1051675200000 , 0.44227126150934] , [ 1054353600000 , 7.2481659343222] , [ 1056945600000 , 9.2512381306992] , [ 1059624000000 , 11.341210982529] , [ 1062302400000 , 14.734820409020] , [ 1064894400000 , 12.387148007542] , [ 1067576400000 , 18.436471461827] , [ 1070168400000 , 19.830742266977] , [ 1072846800000 , 22.643205829887] , [ 1075525200000 , 26.743156781239] , [ 1078030800000 , 29.597478802228] , [ 1080709200000 , 30.831697585341] , [ 1083297600000 , 28.054068024708] , [ 1085976000000 , 29.294079423832] , [ 1088568000000 , 30.269264061274] , [ 1091246400000 , 24.934526898906] , [ 1093924800000 , 24.265982759406] , [ 1096516800000 , 27.217794897473] , [ 1099195200000 , 30.802601992077] , [ 1101790800000 , 36.331003758254] , [ 1104469200000 , 43.142498700060] , [ 1107147600000 , 40.558263931958] , [ 1109566800000 , 42

.543622385800]，[1112245200000、41.683584710331]，[1114833600000、36.375367302328]，[1117512000000、40.719688980730]，[1120104000000、43.897963036919]，[1122782400000、49.797033975368]，[1125460800000、47.085993528989]，[1 [1130734800000，41.567784572762]，[1133326800000，47.296923737245]，[1136005200000，47.642969612080]，[1138683600000，50.781515820954]，[1141102800000，52.600229204305]，[1143781200000，55.599684490628]，[1146369600000，57.920388436633] ，53.522973979964]，[1154318400000，49.846822298548]，[1156996800000，54.721341614650]，[1159588800000，58.186236223191]，[1162270800000，63.908065540997]，[1164862800000，69.767285129367]，[116754120000000000，72.534013373584592，[11702196819726 ]，[1175313600000，83.702398665233]，[1177905600000，91.140859312418]，[1180584000000 ，98.590960607028]，[1183176000000，96.245634754228]，[1185854400000，92.326364432615]，[1188532800000，97.068765332230]，[1191124800000，105.81025556260]，[1193803200000，114.38348777791]，[119639880000000000，103.596049201729809)，[11990776724884 ]，[1204261200000，86.963597532664]，[1206936000000，84.075505208491]，[1209528000000，93.170105645831]，[1212206400000，103.62838083121]，[1214798400000，87.458241365091]，[1217476800000，85.808374141319]，[1220155200000193，93.158973469 [1225425600000，44.580686638224]，[1228021200000，36.418977140128]，[1230699600000，38.727678144761]，[1233378000000，36.692674173387]，[1235797200000，30.033022809480]，[1238472000000，36.707532162718]，[1241064000000，52.191457688424] ，57.629002180305]，[1249012800000，66.650985790166]，[1251691200000 ，70.839243432186]，[1254283200000，78.731998491499]，[1256961600000，72.375528540349]，[1259557200000，81.738387881630]，[1262235600000，87.539792394232]，[1264914000000，84.320762662273]，[1267333200000，90.621278391000000889]，[12700047272 ]，[1275278400000，90.529736050479]，[1277870400000，76.580859994531]，[1280548800000，86.548979376972]，[1283227200000，81.879653334089]，[1285819200000，101.72550015956]，[1288497600000，107.97964852260]，[129109320000000000，106.16240842 [1296450000000，121.60793322282]，[1298869200000，133.41437346605]，[1301544000000，125.46646042904]，[1304136000000，129.76784954301]，[1306814400000，128.15798861044]，[1309406400000，121.92388706072]，[1312084800000，，13.70036147837632 ，59.159665765725]，[1320033600000，79.793568139753]，[1322629200000， 75.903834028417]，[1325307600000，72.704218209157]，[1327986000000，84.936990804097]，[1330491600000，93.388148670744]]
}，
{
"key":"CinemaAAA 2"，
"area":正确，
值":[[1025409600000，4]，[1028088000000，8]，[1030766400000，10]，[1033358400000，14]，[1036040400000，3]，[1038632400000，9]，[1041310800000，-5.5310285460542]，[1043989200000 ，，-5.7838296963382]，[1046408400000，-7.3249341615649]，[1049086800000，-6.7078630712489]，[1051675200000，0.44227126150934]，[1054353600000，7.2481659343222]，[1056945600000，9.2512381306992]，[1059624000000，11.341210982529]，14. [73423024 1064894400000，12.387148007542]，[1067576400000，18.436471461827]，[1070168400000，19.830742266977]，[1072846800000，22.643205829887]，[1075525200000，26.743156781239]，[1078030800000，29.597478802228]，[108070997600000000，30.83169758500000341]，28(10832054685024)，. 29.294079423832]，[1088568000000，30.269264061274]，[1091246400000，24.934526898906]，[1093924800000，24.265982759406]，[1096516800000，27.217794897473]，[1099195200000，30.80260199 2077]，[1101790800000、36.331003758254]，[1104469200000、43.142498700060]，[1107147600000、40.558263931958]，[1109566800000、42.543622385800]，[1112245200000、41.683584710331]，[1114833600000、36.375367302328]，[1117520100000004、40.719 ，[1122782400000，49.797033975368]，[1125460800000，47.085993935989]，[1128052800000，46.601972859745]，[1130734800000，41.567784572762]，[1133326800000，47.296923737245]，[1136005200000，47.642969612080]，[1138683600000，50,781.600515954954 1143781200000、55.599684490628]，[1146369600000、57.920388436633]，[1149048000000、53.503593218971]，[1151640000000、53.522973979964]，[1154318400000、49.846822298548]，[1156996800000、54.721341614650]，[1159588800000、58.186236228191] 69.767285129367]，[1167541200000，72.534013373592]，[1170219600000，77.991819436 573]，[1172638800000、78.143584404990]，[1175313600000、83.702398665233]，[1177905600000、91.140859312418]，[1180584000000、98.590960607028]，[1183176000000、96.245634754228]，[1185854400000、92.326364432615]，[1188532800000、97. ，[1193803200000，114.38348777791]，[1196398800000，103.59604949810]，[1199077200000，101.72488429307]，[1201755600000，89.840147735028]，[1204261200000，86.963597532664]，[1206936000000，84.075505208491]，[1209528000000，103 .1806.538031 1214798400000，87.458241365091]，[1217476800000，85.808374141319]，[1220155200000，93.158054469193]，[1222747200000，65.973252382360]，[1225425600000，44.580686638224]，[1228021200000，36.418977140128]，[1230699600000，38.727678144761] 30.033022809480]，[1238472000000，36.707532162718]，[1241064000000，52.1914576883 89]，[1243742400000，56.357883979735]，[1246334400000，57.629002180305]，[1249012800000，66.650985790166]，[1251691200000，70.839243432186]，[1254283200000，78.731998491499]，[1256961600000，72.375528540349]，[125955720000000000，87.738 ，[1264914000000，84.320762662273]，[1267333200000，90.621278391889]，[1270008000000，102.47144881651]，[1272600000000，102.79320353429]，[1275278400000，90.529736050479]，[1277870400000，76.580859994531]，[1280548800000，81.265 1285819200000，101.72550015956]，[1288497600000，107.97964852260]，[1291093200000，106.16240630785]，[1293771600000，114.84268599533]，[1296450000000，121.60793322282]，[1298869200000，133.41437346605]，[1301544000000，，12 128.15798861044]，[1309406400000、87.92388706072]，[1312084800000、35.70036100870] ，[1314763200000，78.367701837033]，[1317355200000，29.159665765725]，[1320033600000，39.793568139753]，[1322629200000，75.903834028417]，[1325307600000，72.704218209157]，[1327986000000，84.936990804097]，[1330491600000，93.br148 }];
$ scope.legendColorFunction = function(){
返回函数(d){
返回''#E01B5D'';
}
};
}
</script>

</head>
< body ng-app =''nvd3TestApp''>

.543622385800] , [ 1112245200000 , 41.683584710331] , [ 1114833600000 , 36.375367302328] , [ 1117512000000 , 40.719688980730] , [ 1120104000000 , 43.897963036919] , [ 1122782400000 , 49.797033975368] , [ 1125460800000 , 47.085993935989] , [ 1128052800000 , 46.601972859745] , [ 1130734800000 , 41.567784572762] , [ 1133326800000 , 47.296923737245] , [ 1136005200000 , 47.642969612080] , [ 1138683600000 , 50.781515820954] , [ 1141102800000 , 52.600229204305] , [ 1143781200000 , 55.599684490628] , [ 1146369600000 , 57.920388436633] , [ 1149048000000 , 53.503593218971] , [ 1151640000000 , 53.522973979964] , [ 1154318400000 , 49.846822298548] , [ 1156996800000 , 54.721341614650] , [ 1159588800000 , 58.186236223191] , [ 1162270800000 , 63.908065540997] , [ 1164862800000 , 69.767285129367] , [ 1167541200000 , 72.534013373592] , [ 1170219600000 , 77.991819436573] , [ 1172638800000 , 78.143584404990] , [ 1175313600000 , 83.702398665233] , [ 1177905600000 , 91.140859312418] , [ 1180584000000 , 98.590960607028] , [ 1183176000000 , 96.245634754228] , [ 1185854400000 , 92.326364432615] , [ 1188532800000 , 97.068765332230] , [ 1191124800000 , 105.81025556260] , [ 1193803200000 , 114.38348777791] , [ 1196398800000 , 103.59604949810] , [ 1199077200000 , 101.72488429307] , [ 1201755600000 , 89.840147735028] , [ 1204261200000 , 86.963597532664] , [ 1206936000000 , 84.075505208491] , [ 1209528000000 , 93.170105645831] , [ 1212206400000 , 103.62838083121] , [ 1214798400000 , 87.458241365091] , [ 1217476800000 , 85.808374141319] , [ 1220155200000 , 93.158054469193] , [ 1222747200000 , 65.973252382360] , [ 1225425600000 , 44.580686638224] , [ 1228021200000 , 36.418977140128] , [ 1230699600000 , 38.727678144761] , [ 1233378000000 , 36.692674173387] , [ 1235797200000 , 30.033022809480] , [ 1238472000000 , 36.707532162718] , [ 1241064000000 , 52.191457688389] , [ 1243742400000 , 56.357883979735] , [ 1246334400000 , 57.629002180305] , [ 1249012800000 , 66.650985790166] , [ 1251691200000 , 70.839243432186] , [ 1254283200000 , 78.731998491499] , [ 1256961600000 , 72.375528540349] , [ 1259557200000 , 81.738387881630] , [ 1262235600000 , 87.539792394232] , [ 1264914000000 , 84.320762662273] , [ 1267333200000 , 90.621278391889] , [ 1270008000000 , 102.47144881651] , [ 1272600000000 , 102.79320353429] , [ 1275278400000 , 90.529736050479] , [ 1277870400000 , 76.580859994531] , [ 1280548800000 , 86.548979376972] , [ 1283227200000 , 81.879653334089] , [ 1285819200000 , 101.72550015956] , [ 1288497600000 , 107.97964852260] , [ 1291093200000 , 106.16240630785] , [ 1293771600000 , 114.84268599533] , [ 1296450000000 , 121.60793322282] , [ 1298869200000 , 133.41437346605] , [ 1301544000000 , 125.46646042904] , [ 1304136000000 , 129.76784954301] , [ 1306814400000 , 128.15798861044] , [ 1309406400000 , 121.92388706072] , [ 1312084800000 , 116.70036100870] , [ 1314763200000 , 88.367701837033] , [ 1317355200000 , 59.159665765725] , [ 1320033600000 , 79.793568139753] , [ 1322629200000 , 75.903834028417] , [ 1325307600000 , 72.704218209157] , [ 1327986000000 , 84.936990804097] , [ 1330491600000 , 93.388148670744]]
},
{
"key": "CinemaAAA 2",
"area": true,
"values": [ [ 1025409600000 , 4] , [ 1028088000000 , 8] , [ 1030766400000 , 10] , [ 1033358400000 , 14] , [ 1036040400000 , 3] , [ 1038632400000 , 9] , [ 1041310800000 , -5.5310285460542] , [ 1043989200000 , -5.7838296963382] , [ 1046408400000 , -7.3249341615649] , [ 1049086800000 , -6.7078630712489] , [ 1051675200000 , 0.44227126150934] , [ 1054353600000 , 7.2481659343222] , [ 1056945600000 , 9.2512381306992] , [ 1059624000000 , 11.341210982529] , [ 1062302400000 , 14.734820409020] , [ 1064894400000 , 12.387148007542] , [ 1067576400000 , 18.436471461827] , [ 1070168400000 , 19.830742266977] , [ 1072846800000 , 22.643205829887] , [ 1075525200000 , 26.743156781239] , [ 1078030800000 , 29.597478802228] , [ 1080709200000 , 30.831697585341] , [ 1083297600000 , 28.054068024708] , [ 1085976000000 , 29.294079423832] , [ 1088568000000 , 30.269264061274] , [ 1091246400000 , 24.934526898906] , [ 1093924800000 , 24.265982759406] , [ 1096516800000 , 27.217794897473] , [ 1099195200000 , 30.802601992077] , [ 1101790800000 , 36.331003758254] , [ 1104469200000 , 43.142498700060] , [ 1107147600000 , 40.558263931958] , [ 1109566800000 , 42.543622385800] , [ 1112245200000 , 41.683584710331] , [ 1114833600000 , 36.375367302328] , [ 1117512000000 , 40.719688980730] , [ 1120104000000 , 43.897963036919] , [ 1122782400000 , 49.797033975368] , [ 1125460800000 , 47.085993935989] , [ 1128052800000 , 46.601972859745] , [ 1130734800000 , 41.567784572762] , [ 1133326800000 , 47.296923737245] , [ 1136005200000 , 47.642969612080] , [ 1138683600000 , 50.781515820954] , [ 1141102800000 , 52.600229204305] , [ 1143781200000 , 55.599684490628] , [ 1146369600000 , 57.920388436633] , [ 1149048000000 , 53.503593218971] , [ 1151640000000 , 53.522973979964] , [ 1154318400000 , 49.846822298548] , [ 1156996800000 , 54.721341614650] , [ 1159588800000 , 58.186236223191] , [ 1162270800000 , 63.908065540997] , [ 1164862800000 , 69.767285129367] , [ 1167541200000 , 72.534013373592] , [ 1170219600000 , 77.991819436573] , [ 1172638800000 , 78.143584404990] , [ 1175313600000 , 83.702398665233] , [ 1177905600000 , 91.140859312418] , [ 1180584000000 , 98.590960607028] , [ 1183176000000 , 96.245634754228] , [ 1185854400000 , 92.326364432615] , [ 1188532800000 , 97.068765332230] , [ 1191124800000 , 105.81025556260] , [ 1193803200000 , 114.38348777791] , [ 1196398800000 , 103.59604949810] , [ 1199077200000 , 101.72488429307] , [ 1201755600000 , 89.840147735028] , [ 1204261200000 , 86.963597532664] , [ 1206936000000 , 84.075505208491] , [ 1209528000000 , 93.170105645831] , [ 1212206400000 , 103.62838083121] , [ 1214798400000 , 87.458241365091] , [ 1217476800000 , 85.808374141319] , [ 1220155200000 , 93.158054469193] , [ 1222747200000 , 65.973252382360] , [ 1225425600000 , 44.580686638224] , [ 1228021200000 , 36.418977140128] , [ 1230699600000 , 38.727678144761] , [ 1233378000000 , 36.692674173387] , [ 1235797200000 , 30.033022809480] , [ 1238472000000 , 36.707532162718] , [ 1241064000000 , 52.191457688389] , [ 1243742400000 , 56.357883979735] , [ 1246334400000 , 57.629002180305] , [ 1249012800000 , 66.650985790166] , [ 1251691200000 , 70.839243432186] , [ 1254283200000 , 78.731998491499] , [ 1256961600000 , 72.375528540349] , [ 1259557200000 , 81.738387881630] , [ 1262235600000 , 87.539792394232] , [ 1264914000000 , 84.320762662273] , [ 1267333200000 , 90.621278391889] , [ 1270008000000 , 102.47144881651] , [ 1272600000000 , 102.79320353429] , [ 1275278400000 , 90.529736050479] , [ 1277870400000 , 76.580859994531] , [ 1280548800000 , 86.548979376972] , [ 1283227200000 , 81.879653334089] , [ 1285819200000 , 101.72550015956] , [ 1288497600000 , 107.97964852260] , [ 1291093200000 , 106.16240630785] , [ 1293771600000 , 114.84268599533] , [ 1296450000000 , 121.60793322282] , [ 1298869200000 , 133.41437346605] , [ 1301544000000 , 125.46646042904] , [ 1304136000000 , 129.76784954301] , [ 1306814400000 , 128.15798861044] , [ 1309406400000 , 87.92388706072] , [ 1312084800000 , 35.70036100870] , [ 1314763200000 , 78.367701837033] , [ 1317355200000 , 29.159665765725] , [ 1320033600000 , 39.793568139753] , [ 1322629200000 , 75.903834028417] , [ 1325307600000 , 72.704218209157] , [ 1327986000000 , 84.936990804097] , [ 1330491600000 , 93.388148670744]]
}];
$scope.legendColorFunction = function(){
return function(d){
return ''#E01B5D'';
}
};
}
</script>

</head>
<body ng-app=''nvd3TestApp''>

< nvd3-line-chart>
data ="exampleData"
showXAxis ="true"
showYAxis ="true"
宽度="600"
高度="400"
tooltips ="true"
useInteractiveGuideline ="true"
showLegend ="true"
legendColor ="legendColorFunction()">

<nvd3-line-chart>
data="exampleData"
showXAxis="true"
showYAxis="true"
width="600"
height="400"
tooltips="true"
useInteractiveGuideline="true"
showLegend="true"
legendColor="legendColorFunction()">

</body>
</html>

如何使用sqlserver通过angularjs检索数据 [英] How to retrive data through angularjs with sqlserver

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

如何使用sqlserver通过angularjs检索数据 [英] How to retrive data through angularjs with sqlserver

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭