Report by Dates and Periods, Layered, OOP, SQL, C#, WinForm, SSRS-RDLC/ Advanced Level
Vložit
- čas přidán 7. 09. 2024
- 🎬 [Create Detailed Sales Report and Summary by Date Range and Period (Current Date, Last 7 Days, Current month, Last 30 Days, Current year, Custom Dates), with C#, VB.NET, Layered Architecture, Full Object Oriented Programming, SQL Server , Windows Form, Microsoft Reporting - RDLC, Report Viewer, SQL Text Commands and Stored Procedure - Advanced Level]
⏭ NEXT
Best Selling Products Report with Layers, OOP, SQL, VB.NET, WinForm, RDLC-Report Viewer / Advanced Level
• Reporte Productos más ...
⏮ PREVIOUS:
Insert multiple rows (Mass data) Transact -SQL, Commit and Rollback, C #, WinForm, SQL, Bulk Copy, TVP
• Insertar múltiples fil...
▶ CURRENT VIDEO
TOPICS:
-Introduction
-Reports with Layered Architecture.
-Model and Architecture Changes in Layers
- SQL queries to make reports
-SQL Detailed Sales Query with Related Tables.
-Create Project and Application Layers (Presentation, Domain / Business and Data Access)
-Class Connection to SQL Server
-Object of Access to Sales Order Data
-Get Sales with SQL Text Command or Stored Procedure
-Create Object Sales report
-LINQ operations
-Create Object List - List of Sales by Dates (Day)
-Create Object List - Net sales by period
-Create Temporary Sales List of Anonymous type
-Grouping Net Sales List By DAY.
-Grouping Net Sales List By WEEKS.
-Grouping Net Sales List PER MONTHS.
-Grouping Net Sales List By YEARS.
- Add total net sales of the report.
-Create Report File .RDLC
-Add Data Set of Object type, List of Objects.
-Add statistical chart.
-Add data tables.
-Add report viewer (Microsoft Report Viewer)
-Load Data source to data set from the .rdlc report file
-Add buttons for the date range.
-Conclusions.
-Migrate to Stored Procedure
🔰 DOWNLOAD DATABASE
rjcodeadvance....
🔰 GET CODE IN C # AND VISUAL BASIC (VB.NET)
rjcodeadvance....
TRACKS //
Track: Venemy & Aznar ft. Doubletake - Reign [NCS Release]
Music provided by NoCopyrightSounds
Watch: https: // / watch V = uaQ2dtgCKKk