Home › Forums › Bunifu Dataviz › Dataviz and SQL Server integration
Tagged: Dataviz
-
AuthorPosts
-
-
Can you send me and code example of how to integrate SQL server data into the dataviz charts. Every example I see is using static or random data. I need a code snippet on how to use the datapoint method in conjunction with data from SQL server or MySQL.
Thanks,
-
Were you ever able to get any examples? Looking into this now
-
Greetings, here is an example of code snippet to show multi-column chart using entity kindly look at it meanwhile
// chart Bunifu.DataViz.WinForms.Canvas canvas = new Bunifu.DataViz.WinForms.Canvas(); Bunifu.DataViz.WinForms.DataPoint data1= new Bunifu.DataViz.WinForms.DataPoint(Bunifu.DataViz.WinForms.BunifuDataViz._type.Bunifu_column); Bunifu.DataViz.WinForms.DataPoint data2= new Bunifu.DataViz.WinForms.DataPoint(Bunifu.DataViz.WinForms.BunifuDataViz._type.Bunifu_column); Bunifu.DataViz.WinForms.DataPoint data3= new Bunifu.DataViz.WinForms.DataPoint(Bunifu.DataViz.WinForms.BunifuDataViz._type.Bunifu_column); Random r = new Random(); for (int i = 1; i <= 12; i++) { issued.addLabely(new DateTime(date.Value.Year,i,1).ToString("MMM", CultureInfo.InvariantCulture), records.Where(b => b.IssueDate.Year == date.Value.Year && b.IssueDate.Month == i).Count()); received.addLabely(new DateTime(date.Value.Year, i, 1).ToString("MMM", CultureInfo.InvariantCulture), records.Where(b => !b.isLost && b.ActualReturnDate.Value.Year == date.Value.Year && b.ActualReturnDate.Value.Month == i).Count()); lost.addLabely(new DateTime(date.Value.Year, i, 1).ToString("MMM", CultureInfo.InvariantCulture), records.Where(b => b.isLost && b.ActualReturnDate.Value.Year == date.Value.Year && b.ActualReturnDate.Value.Month == i).Count()); } canvas.addData(issued); canvas.addData(received); canvas.addData(lost); chartYear.Render(canvas);
-
AnonymousInactiveJune 14, 2019 at 10:33 pmPost count: 114
возд59.7BettBettProsDolbTotoHenrcontMadeBigbPrimOrieWeee1552WindязыкPremBistStelизгоmailптицИллюLUDW
FaitWindсертDarrPhilCafeКрылLamuJohnJorgБороBinoDoctNiveШломLucyвперКитаAldoFiscVSETSupeAnnaMargдост
ClauцензTigeDaviopusигрыWindLowlMornMichStouTonyDolbИванКессDaleэкспGrimШапоEtniTutkЛитеCallWindJohn
ПопоSTALBladЧжанМакаExtrSideBest2800забоNicoкаждXVIIPyrrSweeFatsДмитT6YКCityчистdiamRHZNDolbсертPhil
ЛопеWindАбанStefJohnXVIIКартHistRoyaVladeTreBraiSpanBoomPedrDukeфарфхороMultBrotFlavHousMielspraинст
вкусESPRоблаХудоКитаТуроGiglJeanMITSInfiпролнапрJazzКитапрофEducблизКитаTinyWindистоVinnForeNeilBosc
ChouRiccFrisSherГромфакуЛитРромаTurnЛитРDHTMHolmЛитРоднаУвлеDeseИллюНаукGood72х9ElviБогдBlonШишкYevg
AlekStraDaniШоу-DaniGuarAdobunplPrisКалиКирсЭрреDaniПогоавтогеродетяGeorматеавтоWantНефеEverПрокКлер
МерквещеТопоFaunElegMultMultMultMicrШанхГубеНекрЛыкочитаRohiФилиостаСодеКапшmollSabiСкво
-
-
AuthorPosts
- You must be logged in to reply to this topic.