VS2022,VISUAL BASIC, OLEDB AND RDLC REPORTS: Using Microsoft OLE DB Provider for SQL Server Compiled using 64-bit

by Richard Edwards

Anyone who knows me really well knows I’m a big fan of trying out the latest, greatest release of Visual Studio. So, it shouldn’t come as much surprise that as soon as Visual Studio 2022 was announced as a pre-release, I would download it and take it for a test drive. All I can say is if this is their idea of a preview, I can’t imagine what surprises the RTM will have in store for us. The 2022 preview is already quite capable of being in par with Visual Studio 2019 and performs very well with respect to that.In fact, I dare say it is around 3 times faster than 2019 with respect to responsiveness inside the IDE.With that said, this book is about using Visual Studio, Visual Basic and OLEDB to produce RDLC Reports from SQL Server 2019 – from the AdventureWorks2019 database.This book is one of 4 books dealing with the same exact code, explanations and data collection patterns with the only difference between them being the Provider used in each book.At the time of this writing, these 4 Providers Microsoft OLE DB Driver for SQL Server Microsoft OLE DB Provider for SQL Server SQL Server Native Client 11.0SQL Server Native Client RDA 11.0This particular book will be using the Microsoft OLE DB Provider for SQL Server.These books are also identical in every way. So, if you have already purchased one of these books, please don’t purchase another. Instead, use the below information to change the connection strings – OLE DB Driver for SQL ServerProvider=MSOLEDBSQL;Data Source=WIN-U1D8NGFVABF;Integrated Security=SSPI;Initial Catalog=AdventureWorks2019;Microsoft OLE DB Provider for SQL ServerProvider=SQLOLEDB;Data Source=WIN-U1D8NGFVABF;Integrated Security=SSPI;Initial Catalog=AdventureWorks2019;SQL Server Native Client 11.0Provider=SQLNCLI11;Data Source=WIN-U1D8NGFVABF;Integrated Security=SSPI;Initial Catalog=AdventureWorks2019;SQL Server Native Client RDA 11.0Provider=SQLNCLIRDA11.1;Data Source=WIN-U1D8NGFVABF;Integrated Security=SSPI;Initial Catalog=AdventureWorks2019; I would love to believe you are reading this because you want to know how to create perfect RDLC Reports using Visual Studio 2019 and VB.Net using the Microsoft OLE DB Driver for SQL Server. What do I mean by “perfect”? Simple. If you have had to work with RDLC Reports in the past, you know you have to make changes to some columns because the Report Wizard decided you need a SUM instead of just leaving it alone as an Integer or the column widths were too short for the values being presented and you had to manually resize them until the report looks half-way decent. The code I have created in this book has addressed these issues. Meaning, when this code creates and shows your RDLC Report with all the data in it – as you will see – it is ready for production. Now I’m not big on 3 to 5 pages of introduction and I have a lot to cover. So, let’s get started, shall we?

129 pages, Kindle Edition

Published June 27, 2021