I am trying to build vb.net web app by using mongodb as database. App needs consuming web service and return JSON string. which is used as data source for Kendo UI chart.<\/p>\n
My web service:-<\/p>\n
Imports MongoDB.Bson\n Imports MongoDB.Driver\n Imports MongoDB.Driver.Builders\n Imports System.Web.Services\n Imports System.Web.Services.Protocols\n Imports System.Web.Script.Services\n 'Imports System.Web.Script.Serialization\n Imports System.ComponentModel\n Imports System.IO\n Imports AjaxControlToolkit\n\n ' To allow this Web Service to be called from script, using ASP.NET AJAX,'uncomment the following line.\n _\n _\n _\n _\nPublic Class WebService_BufferFile\n Inherits System.Web.Services.WebService\n Dim connectionString As String = \"mongodb:\/\/localhost\"\n Dim client = New MongoClient(connectionString)\n _\n Public Function BufferFile_Power(ByVal UserId As Integer, ByVal DataBaseName As String, ByVal Collection As String, ByVal FileDate As DateTime, ByVal FileName As String) As String\n ' _\n 'runner = Mongo2Go.MongoDbRunner.Start()\n 'runner.Import(strDatabase, strCollection, ImportFilePath, False)\n 'MongoImportExport.Import(\"C:\\MongoDB\\bin\\\", 27017, strDatabase, strCollection, ImportFilePath, False)\n\n Dim ImportFilePath As String = \"E:\\SCADA\\RAW\\\" & DataBaseName & \"\\\" & Collection & \"\\\" & Format(FileDate, \"yyyy\") & \"\\Buffer\\\" & FileName & \"\"\n If File.Exists(ImportFilePath) Then\n Dim ImportProcess As New Process()\n ImportProcess.StartInfo.UseShellExecute = True\n ImportProcess.StartInfo.CreateNoWindow = True\n ImportProcess.StartInfo.WorkingDirectory = \"C:\\MongoDB\\bin\"\n ImportProcess.StartInfo.FileName = \"mongoimport.exe\"\n ImportProcess.StartInfo.Arguments = \" --db \" & DataBaseName & \" --collection \" & Collection & \"_\" & Format(FileDate, \"yyMMdd\") & \"_\" & UserId & \" --type csv --file \" & ImportFilePath & \" --headerline\"\n ImportProcess.Start()\n ImportProcess.WaitForExit(1500)\n ImportProcess.Dispose()\n Else\n Return 0\n Exit Function\n End If\n Dim server = client.GetServer()\n Dim database = server.getDatabase(DataBaseName)\n Dim UserCollection = Collection & \"_\" & Format(FileDate, \"yyMMdd\") & \"_\" & UserId\n Dim Docs As MongoCursor = database.GetCollection(UserCollection).FindAll()\n Docs.SetSortOrder(SortBy.Ascending(\"timestamp\"))\n Docs.SetFields(Fields.Include(\"timestamp\", \"converter_UL1\", \"converter_UL2\", \"converter_UL3\", \"converter_I1\", \"converter_I2\", \"converter_I3\").Exclude(\"_id\"))\n Docs.SetLimit(3000)\n Dim JsonString = Docs.ToJson\n If Docs.Count > 0 Then\n Docs.Database.DropCollection(UserCollection)\n End If\n 'Dim jsonSearializer As New JavaScriptSerializer()\n 'Return jsonSearializer.Serialize(JsonString)\n 'Return 234\n Return JsonString\n\n End Function\nEnd Class\n<\/code><\/pre>\nHTML Page:-<\/p>\n
\n\n\n \n\n\n<\/code><\/pre>\n\n\nfunction createPowerChart() { $.ajax( { type: ‘POST’, url: ‘\/WebService_BufferFile.asmx\/BufferFile_Power’, contentType: ‘application\/json; charset=utf-8’, dataType: ‘json’, data: ‘{“UserId”:174,”DataBaseName”:”ChitraDurga”,”Collection”:”NSLHK-06″,”FileDate”:”05\/05\/2013″,”FileName”:”NSLHk-06_b130505_1819.txt”}’, async: false, success: OnSuccess, error: OnError }); function OnSuccess(PowerChartData) { alert(PowerChartData.d); var PowerChartDataSource = JSON.parse(PowerChartData.d); $(“#PowerChart”).kendoChart({ title: { text: “Power” }, legend: { visible: true, position: “bottom” }, dataSource: PowerChartDataSource, series: [{ type: “line”, field: “converter_UL1”, name: “converter_UL1” }, { type: “line”, field: “converter_UL2”, name: “converter_UL2” }, { type: “line”, field: “converter_UL3”, name: “converter_UL3” }, { type: “line”, field: “converter_I1”, name: “converter_I1” }, { type: “line”, field: “converter_I2”, name: “converter_I2” }, { type: “line”, field: “converter_I3”, name: “converter_I3” }], categoryAxis: { field: “timestamp”, labels: { rotation: -5 }, majorGridLines: { visible: true } }, valueAxis: { max: 1500, line: { visible: true }, majorUnit:100, minorGridLines: { visible: true } }, tooltip: { visible: true, template: “#= series.name #: #= value #” } }); } function OnError(msg) { alert(‘Error = ‘ + msg.d); } } $(document).ready(function () { \/\/debugger; setTimeout(function () { createPowerChart(); }, 500); }); .PowerChart-wrapper, .PowerChart-wrapper .k-chart { height: 520px; width:850px; }<\/td>\n<\/tr>\n<\/table>\nAny help would be appreciated.<\/p>\n
Originally posted 2013-11-09 22:52:19. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
I am trying to build vb.net web app by using mongodb as database. App needs consuming web service and return JSON string. which is used as data source for Kendo UI chart. My web service:- Imports MongoDB.Bson Imports MongoDB.Driver Imports MongoDB.Driver.Builders Imports System.Web.Services Imports System.Web.Services.Protocols Imports System.Web.Script.Services ‘Imports System.Web.Script.Serialization Imports System.ComponentModel Imports System.IO Imports AjaxControlToolkit […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-883","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=883"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/883\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}