Export Excel Data to SQL in C#-Barcode Scanner in C# and SQL
4.4 (19 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.
6,222 students enrolled

Export Excel Data to SQL in C#-Barcode Scanner in C# and SQL

Build Barcode Scanning App in C# to Search items barcode in SQL,Export Excel Data ,Using Excel,Barcode Reader app by SQL
4.4 (19 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.
6,222 students enrolled
Created by Musavi Abdullah
Last updated 7/2020
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 15.5 hours on-demand video
  • 3 articles
  • 2 downloadable resources
  • 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
  • Quick Learning on SQL Server
  • Read Excel Data in C#
  • Using Barcode Scanner in C#
  • Auto Search Barcode by Barcode Scanner
  • Create Sample Barcode List in SQL
  • Learn Quickly to Use SQL Database in C#
  • Search Something in SQL by Using C#
  • Save Excel data file in SQL Server Database
  • Export Excel Data to SQL by C#
  • Working with SQL ADO. Net
Course content
Expand all 160 lectures 15:19:21
+ A.b. Create Barcode Project in C#
2 lectures 07:47
Create C# project for working with Barcode
03:45
Design the Barcode form
04:02
+ A.c. Quick Review of SQL Server
76 lectures 06:15:44
Who should watch this section!
00:54
Download SQL Server 2014 express & requirements
08:07
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
What is SQL Server Management Studio (SSMS) ?
07:22
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 database files
05:05
Using SQL Server configuration manager
06:24
SQL table intro
00:45
What is SQL table?
03:03
Add table to the SQL Database
12:31
Add data to the SQL table
05:24
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
Bit data type in SQL
05:28
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
Decimal data type in SQL
10:27
Section Introduction
00:45
Char data type in SQL
07:00
Varchar data type in SQL
05:29
Varchar(max) data type in SQL
06:13
Text data type in SQL
03:28
Section Intro
00:45
nchar data type in SQL
07:21
nvarchar data type in SQL
04:45
nvarchar(max) data type in SQL
04:09
ntext data type in SQL
04:15
What is GUID in SQL?
03:04
Using GUID in SQL Server
08:21
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
Create sample database to set identity column
05:03
Add identity and auto increment column and test it
07:33
dentity column count in each table
03:35
Date Time Data type intro
00:50
SQL Date data type
06:19
SQ Smalldatetime data type
03:58
SQ Datetime data type
02:54
SQ Datetime2 data type
03:39
SQ Datetimeoffset data type
03:01
SQ Time data type
05:34
Create phone book project database in SQL Server
07:56
Add personal columns to phone book table
07:21
Add contacts columns to phone book table
06:54
Add address columns to phone book table
08:18
Add identity and auto increment column
06:43
Add sample data and test our SQL table
06:19
What is Select Query in SQL?
04:40
Writing our first Select query
11:42
Use Select query with (*) to show all columns
02:02
Sort the records with Select query
09:47
Show specific number of top rows with Select Query
04:12
Show specific number of bottom rows with Select Query
03:51
Reorder the columns in Select Query
02:53
Overview of Where clause for searching data
02:09
Using Where clause to find English characters
05:25
Using Where clause to find Unicode characters
02:57
Using Where clause to find Numbers
03:52
Different operators with Where clause
01:53
Use Not equal operator(<>) with Where clause
04:45
+ A.e. Working with SQL ADO.Net
8 lectures 39:49
SQL ADO.Net Introduction
03:52
Add Dataset to C# project
04:54
Connect our project to SQL Database
07:03
SQL Server Connection String in Depth
03:00
Create Select query with C# query editor
08:07
Finish Adding Table Adapter to Dataset
04:49
Edit our Select query with table-adapter
05:40
+ A.f. Connect form to SQL ADO.Net
2 lectures 12:42
Add Datagrid view to Barcode Search form
06:32
Customize default BindingNavigator
06:10
+ A.g. Loading Data with TableAdapter
2 lectures 13:38
Using fill method of TableAdapter in C#
06:42
Adding new select query for loading data by TableAdapter
06:56
+ A.h. Searching Barcode By Barcode Scanner
5 lectures 24:22
Add simple search query to form
05:23
Search user input Barcode
06:01
Manual Search Barcode by Barcode Scanner
02:19
Auto search Barcode by Barcode Scanner
07:06
Search Multiple Barcode by Barcode Scanner
03:33
Requirements
  • General Knowledge of C# Programming
  • General Knowledge of SQL Server
  • Visual Studio 2017 or 2019 Community edition or other versions
  • Motivation to use Barcode Scanner in C# and SQL Server
  • 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 working with Barcode Scanner for searching  products in SQL database with C#!

If you are beginners or student looking for a tutorial to searching products with Barcode Scanner in simplest way!

 

I started from beginning and show you how generate the sample Barcode and print it.

Then started to read the printed barcodes by barcode scanner.

Then I talked about how to create C# application to work with barcode reader.

Then i'll talk about how to install SQL Server 2014 and start working with it.

Then i'll talk about how to create a sample product list database in SQL.

Then i'll talk about how start working with SQL ADO.Net.

Then i'll show how to connect product list database to C# application!

Then i'll show how to add query to search data in SQL by C# code!

Then i'll show how to auto search products in SQL database by using barcode scanner.

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 barcode scanner and start learning Excel in C#!

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

Say Hi C# and Barcode Scanner world and let's go !!!

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

Who this course is for:
  • C# programmers who want to work with Barcode Scanner in C# code!
  • C# programmers who want to Search products in C# by using Barcode Scanner!
  • C# programmers who want to Learn quickly SQL in C#!
  • 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!