Using Excel in C# - Export Excel Data to SQL Database in C#
4.2 (18 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,259 students enrolled

Using Excel in C# - Export Excel Data to SQL Database in C#

Learn how to import excel data in C# and convert data from excel to SQL Server Database in C#
4.2 (18 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
10,259 students enrolled
Created by Musavi Abdullah
Last updated 5/2020
English
English [Auto-generated]
Current price: $126.99 Original price: $194.99 Discount: 35% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 2 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
  • Download and use Excel free component in C#
  • 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
Course content
Expand all 92 lectures 09:44:22
+ Introduction
4 lectures 09:33
Download projects and files of this course
00:16
How to increase sound volume of tutorials?
02:01
+ Preparing the Requirements
6 lectures 31:20
Start working with Google Docs
06:21
Start working with Microsoft One Drive
06:46
Download Excel free component in C#
05:10
Download OpenXml.dll ver 2.0 component
05:01
+ Quick Review to Visual Studio
9 lectures 01:15:22
Visual Studio requirements
02:04
My First C# App ,Visual Studio Windows...
12:36
Properties window in Visual Studio
03:49
Toolbox window,adding controls to form
05:36
What are C# projects files?
03:59
Common properties of C# form
12:21
Advance properties of C# form
12:34
Common properties of Controls
13:01
+ Visual Studio 2019 Update
5 lectures 30:55
Visual Studio 2019 Section Intro
01:09
Visual Studio 2019 requirements
04:18
How to Install Visual Studio 2019?
13:53
Working with Visual Studio 2019 and C#
06:07
Compare Visual Studio 2019 & Visual Studio 2017
05:28
+ Excel Project in C#
3 lectures 19:35
Add Excel DLL to our project
06:58
Add Excel sample file to project
08:25
+ Working with Excel DLL in C#
4 lectures 36:51
Define and use Excel DLL object in C#
09:04
Load Excel file from app folder
09:55
Get the Excel cell value and show in C#
11:56
Edit Excel file via on Google Docs and reflect it in project
05:56
+ Quick Review of SQL Server
33 lectures 02:42:09
Who should watch this section!
00:54
Install SQL 2014 express in Windows 7
11:47
Install SQL 2014 express in Windows 10
10:17
What is SQL Server & its structure?
03:10
Common parts of SQL Server
02:13
Customize SQL Server Environment
05:53
What is SQL Server database?
03:45
Create SQL Database
03:29
Different parts of the SQL database
03:33
Rename and delete SQL Database
03:17
Default location of the SQL Database files
03:09
Different type of SQL datbase files
05:05
Using SQL Server configuration manager
06:24
What is SQL table?
03:03
Add table to the SQL Database
12:31
Load data in to the SQL table
05:00
Change the design of table & save it
04:17
Rename and delete the SQL table
02:17
What is the prefix "dbo" in SQL table name?
02:50
What is SQL Numeric data type?
03:50
Int data type in SQL
08:23
Tinyint data type in SQL
03:40
Smallint data type in SQL
04:19
Bigint data type in SQL
02:55
Float data type in SQL
04:09
nvarchar data type in SQL
04:45
How to detach SQL database?
04:53
How to attach SQL database?
03:30
Attach SQL database without LDF file
04:31
Make SQL database offline and online
03:27
+ SQL Server ADO.Net in C#
4 lectures 38:14
Create our project database in SQL Server
08:42
Create our table in SQL Server
16:22
Add sample data to SQL Server Table
09:18
+ Working with SQL Database in C#
3 lectures 26:28
Connect our project to SQL Database
10:12
Write Select query to load data from SQL
14:38
Edit our Select query with table-adapter
01:38
+ Design Data Form in C#
6 lectures 49:15
Add Datagridview to form
06:57
Add text boxes and labels to form
07:46
Add the button to load data from SQL
06:41
Add button to insert new row to datatable
06:17
Save new row in the datatable
07:44
Add new record with data to datatable in C# code
13:50
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!