Excel File to DataGridView Import | C# | WinForms | Part Two
Learn How to Import Excel File to DataGridView using C# code. By using OLEDB tool we will easily copy your data between these platforms
Solutions -------
1. Using SQL command and OLEDB to import data
Note --------
Connection String:
@"Provider = Microsoft.ACE.OLEDB.12.0 ; Data Source = '" + [YOUR_PATH] + "' ; Extended Properties" + "= 'Excel 12.0; HDR = YES';";
Typo
Found some typo errors and mistake in my video caption
Related Or Similar Videos --------
Excel to DataGridView on C# | Part One
-- • Excel File to DataGridView Import | C... --
Related Or Similar Links --------
1. Microsoft Access Driver Engine 2016 Redistributable download link (Microsoft Official)
-- https://www.microsoft.com/en-us/downl... --
2. Full UI friendly application on GitHub
-- https://bit.ly/3kRdIVN --
Previous Videos --------
Import Excel to DataGridView | Part One
-- • Excel File to DataGridView Import | C... --
Youtube Call To Action -------
Don't forget to Like and Share my content and also Subscribe to my channel for more tips and tricks.This will help me grow
C# Development Episode 2 Chapters -------
00:00 - Excel File to DataGridView Import | C# | Part Two
00:16 - How to download Microsoft access driver engine
00:44 - How to install Microsoft access driver engine
00:56 - How to create a function in C#
01:40 - Adding data references in C#
01:45 - How to use try-catch block in C#
02:18 - Connection string for OLEDB in C#
02:53 - Creating object instances for OLEDB in C#
03:30 - SQL SELECT command for EXCEL FILE
04:28 - Datagridview datasource and dataset filling
05:49 - Connection close and run the application
06:12 - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on this machine
06:28 - Declare CPU type in Visual Studio 2019
07:04 - End screen
Learn More in About Section -------
About Microsoft Office:
Microsoft Office, or simply Office, is a discontinued family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas.
About Microsoft Excel:
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft 365 suite of software
About Microsoft Visual Studio:
Visual Studio is an integrated development environment from Microsoft. It is used to develop computer programs including websites, web apps, web services and mobile apps
About C#:
C# is a general-purpose high-level programming language supporting multiple paradigms. C# encompasses static typing, strong typing, lexically scoped, imperative, declarative, functional, generic, object-oriented, and component-oriented programming disciplines.