VS2022,VB.NET,SQL SERVER, ADO AND RDLC REPORTS: Using Microsoft OLE DB Provider for SQL Server Compiled using 64-bit

by Richard Edwards

This book covers connecting to SQL Server using VB.Net, ADO and the Microsoft Provider for SQL Server.Once the connection is made, the next step is acquiring a list of tables and views, try complex queries such as inner and outer joins or filter the columns for custom queries. The end create RDLC Reports with or without gridlines.Discussions include the use of the SQL.SMO, a discovered real time issue and how to get around it and what the book settled for as the vehicle for creating reports from Stored Procedures.Additional discussions on downloading the Report Viewer, what connection strings are, how to use ADO in a variety of ways and how the code works interactively to produce RDLC Reports.This is not a beginners book and expects you to know how to program and have some familiarity with SQL Server.

Kindle Edition

Published July 1, 2021