MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch

Genre: eLearning | Language: English + .VTT | Duration: 9 hour | Size: 6.1 GB

Learn how to import excel data in C# and convert data from excel to SQL Server Database in C#

What you'll learn

Install SQL Server 2014 in Win 7, Win 10

Load data from Excel file in C#

Save Excel data file in SQL Server Database

Create SQL Server Data base and Table

Create Excel data to SQL Converter

Add Pro progress bar for loading Excel data

Add progress bar while saving data to SQL

Requirements

General Knowledge of C# Programming

General Knowledge of SQL Server

Visual Studio 2017 Community edition or other versions

Motivation to use Excel in C# and SQL Server

Description

Hi There!

With my 20 years programming skills i'm with you to share my knowledge with you.

So

If you try you will learn Import data from Excel and save in SQL Server Database!

If you are beginners or student looking for a tutorial to create a converter to convert data from Excel and save in SQL Server in simplest way!

I started from beginning and show you how to install SQL Server 2014 and Visual Studio 2017.

Then started to create first data base in SQL Server and ...

Then I talked about table and how to create,delete,rename and ...

Then i'll talk about downloading Excel sample data file.

Then i'll talk about free Excel component in C#.

Then i'll talk about create a C# App to load the Excel data and show it in Data Grid View.

Then i'll show how save data in SQL Server Database!

Then i'll show how to add progress bar while loading Excel data and saving in SQL Server Database!

Don't hesitate to start learning Excel in C# and SQL Server!

Every thing will be discussed with sample project and you will have lot of fun within my course.

Say Hi Excel and SQL world and let's go !!!

Who this course is for:

C# programmers who want to work with Excel data in C# code!

C# programmers who want to create Excel to SQL Server Converter in C# code!

C# programmers who want to make more money by importing the Excel data in C# and saving it in SQL Server Database!