VS2022,VB.NET, SQL SERVER, ADO AND RDLC REPORTS: Using SQL Server Native Client RDA 11.0 complied using 64-bit

by Richard Edwards

Spoiler alert! Since I can only write this entire book basically the same for each OLEDB Provider and have 3 for 32-bit and 4 in 64-bit, I must apologize in advance for the use of the same book but with the code changes based on the chosen Provider.Please do not buy this book if it says VS2022,VB.Net, SQL Server, ADO AND RDLC Reports. Instead, please replace the connection strings used in the book you purchased and replace them with what I’m using in this book. For Windows "Provider= SQLNCLIRDA11; Data Source=WIN-U1D8NGFVABF; Integrated Security=SSPI;Initial Catalog=AdventureWorks2019;" There also is an entire website devoted to connection strings. It book covers connecting to SQL Server using VB.Net, ADO and the Microsoft Driver for SQL Server as a Driver.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 2, 2021