Using Barcode Scanner in VB.Net and SQL, SQL Server Database
4.6 (9 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.
7,278 students enrolled

Using Barcode Scanner in VB.Net and SQL, SQL Server Database

Build Barcode Scanning App in VB .Net 2 Search items barcode in SQL-Build visual basic. net|vb|Barcode Reader app by SQL
4.6 (9 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.
7,278 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
  • 8.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
  • Using Barcode Scanner in Visual Basic. Net
  • Auto Search Barcode by Barcode Scanner
  • Create Sample Barcode List in SQL
  • Learn Quickly to Use SQL Database in VB. Net
  • Learn to Search Something in SQL by Using VB .Net
  • Working with SQL ADO. Net
Course content
Expand all 104 lectures 08:24:58
+ Introduction
4 lectures 07:58
Download projects and files of this course
00:53
How to increase sound volume of tutorials?
02:01
+ Quick Review of SQL Server
76 lectures 06:15:44
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
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 datbase 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
Identity 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 Were clause
04:45
+ Working with SQL ADO.Net
8 lectures 41:06
SQL ADO.Net Introduction
03:52
Add Dataset to Visual Basic project
05:17
Connect our project to SQL Database
07:03
SQL Server Connection String in Depth
03:00
Create Select query with Vb.Net query editor
08:07
Finish Adding Table Adapter to Dataset
04:49
Edit our Select query with table-adapter
05:40
Location for saving connection string
03:18
+ Connect form to SQL ADO.Net
2 lectures 12:15
Add Datagrid view to Barcode Search form
07:39
Customize default BindingNavigator
04:36
+ Loading Data with TableAdapter
2 lectures 14:41
Using fill method of TableAdapter in Visual Basic
08:32
Adding new select query for loading data by TableAdapter
06:09
+ Searching Barcode By Barcode Scanner
5 lectures 22:54
Add simple search query to form
05:47
Search user input Barcode
05:43
Manual Search Barcode by Barcode Scanner
02:19
Auto search Barcode by Barcode Scanner
05:24
Search Multiple Barcode by Barcode Scanner
03:41
+ Bonus Section: Get My Other Courses with Discount
1 lecture 00:29
Bonus Lecture: Get Amazing Discount for My Other Courses
00:29
Requirements
  • General Knowledge of VB. Net Programming
  • General Knowledge of SQL Server
  • Visual Studio 2017 or 2019 Community edition or other versions
  • Motivation to use Barcode Scanner in VB .Net 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 VB. Net!

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 visual basic dot net 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 VB .NET application!

Then i'll show how to add query to search data in SQL by vb .net code!

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

Don't hesitate to start learning barcode scanner in vb. net!

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

Say Hi visual basic. net and Barcode Scanner world and let's go !!!

Who this course is for:
  • VB .Net programmers who want to work with Barcode Scanner in vb .net code!
  • VB. Net programmers who want to Search products in VB. Net by using Barcode Scanner!
  • Visual Basic programmers who want to Learn quickly SQL in VB. Net!