Quick SQL in VB .Net : Database Apps in Visual Basic & SQL

Course Curriculum

Chapter 1: Intro

Lecture 1: Course Intro

Lecture 2: Download projects and files of this course

Chapter 2: SQL Serverfor Beginners

Lecture 1: Who should watch this section!

Lecture 2: Download & install SQL 2014 on Windows 10 and Windows 7

Lecture 3: Start using SQL server and SSMS

Lecture 4: Working with SQL database

Lecture 5: Using SQL Server configuration manager

Lecture 6: Using SQL Server Table

Lecture 7: SQL Numeric Data types

Lecture 8: SQL English Text Data types

Lecture 9: SQL Unicode Text Data types

Lecture 10: GUID datatype in SQL

Lecture 11: How to Attach, Detach and offline the SQL database

Lecture 12: Identity and Auto Increment Column in SQL Server

Lecture 13: SQL Date Time Data types

Chapter 3: Basics – "Phone Book" Db in SQL

Lecture 1: Section intro

Lecture 2: Intro -Road map of Phone Book Db in SQL

Lecture 3: Create "Phone Book" database in SQL

Lecture 4: Select Query In SQL

Chapter 4: Basics – Using SQL Database in VB

Lecture 1: Intro – Using SQL ADO.Net in VB

Lecture 2: SQL ADO.Net Introduction

Lecture 3: Adding and debt and income columns to database

Lecture 4: Create VB.Net Phone Book Project for SQL Server

Lecture 5: Add Dataset to VB.Net project

Lecture 6: Make a back up of our project

Lecture 7: Add Table Adapter to Dataset

Lecture 8: SQL Server Connection String in Depth

Lecture 9: Using Manual Query editor in VB.Net

Lecture 10: Using Diagram & Criteria to Create SQL Select Query

Lecture 11: Finish Adding Table Adapter to Dataset

Lecture 12: What is Dataset and Data table in VB.Net

Lecture 13: What is Table Adapter in VB.Net

Lecture 14: How to configure SQL Query in Table Adapter

Chapter 5: Basics – Data Entry Form in VB

Lecture 1: #### Section intro 1 ### – Add DataGridView

Lecture 2: Add Datagrid view to Phone Book form

Lecture 3: Resolve errors and create form again

Lecture 4: What is Binding Source?

Lecture 5: Add All Textboxes & Labels to Phone Book Form

Lecture 6: Adding Textbox & Label one by one to Form

Lecture 7: Configure New , Delete and Save Buttons in Form

Lecture 8: Add Records to Dataset and save in SQL Server Database

Lecture 9: #### Section intro 2 ### – Add Toolbar to data entry form

Lecture 10: Upgrade to Visual Studio 2019 my Phone Book project

Lecture 11: Add toolbar to data entry form

Lecture 12: Add image to toolbar buttons

Lecture 13: Enable|Disable toolbar buttons by VB.Net code

Lecture 14: Create method for Enable|Disable buttons

Lecture 15: Enable|Disable Datagridview & Groupbox by VB.Net code

Lecture 16: #### Section intro 3 ### – VB.Net codes for data entry buttons

Lecture 17: Write "Add New " button code in VB.Net

Lecture 18: Write "Save Changes" button code in VB.Net

Lecture 19: Show message box after saving data to SQL

Lecture 20: Write "Delete User" button code in VB.Net

Lecture 21: Write "Edit" & "Cancel" buttons code in VB.Net

Lecture 22: Add empty record guard to "Edit" & "Delete" Buttons

Lecture 23: Disable groupbox Items when click the "Delete" button

Chapter 6: Basics – Loading Data & DataGridView

Lecture 1: TableAdapter section intro

Lecture 2: Use default Fill method of TableAdapter

Lecture 3: Add new Fill method for TableAdapter and use it

Lecture 4: Add new BindingNavigator and using it

Lecture 5: Customize default BindingNavigator

Lecture 6: #### Section intro 1 ### – Working with DataGridView

Lecture 7: Disable DGV edit,delete,column reorder,new row and …

Lecture 8: Disable DGV column & row resize

Lecture 9: Add and remove DGV columns

Lecture 10: Change the width and visibility of columns in DGV

Lecture 11: Change the text of Columns in DGV

Chapter 7: Basics – Advance ADO.Net

Lecture 1: #### Section intro 1 ### – Advance Topics of ADO.Net

Lecture 2: Get the Row count by using DataTable

Lecture 3: Get the Row count after deleting some records by using DataTable

Lecture 4: Sort the records inside DataTable using Select query

Lecture 5: Get the Row count by using BindingSource

Lecture 6: Get the current record position using BindingSource

Lecture 7: Using BindingSource to Sort the records inside DataTable

Lecture 8: #### Section intro 2 ### – Create Custom BindingNavigator

Lecture 9: Design custom BindingNavigator by normal buttons

Lecture 10: Write the code to navigate between records

Lecture 11: Adding "Current Record" & "Total Records" labels to custom Navigator

Lecture 12: Disable "First" & "Previous" buttons in first record

Lecture 13: Disable "Last" & "Next" buttons in last record

Lecture 14: Using "Try" structure to protect VB.Net codes against errors

Chapter 8: Basics – Saving Image to SQL

Lecture 1: Intro – Saving Image to SQL

Lecture 2: Steps to save customer image in SQL database

Lecture 3: Add customer image picturebox and browse button

Lecture 4: Write the code to load customer image in VB.Net

Lecture 5: Add empty image guard to customer image

Lecture 6: Add filter for selecting customer image

Lecture 7: Add "No Image" picture for new customer image

Lecture 8: Add customer image column to SQL Server database

Lecture 9: Add customer image column to VB.Net project by Configuring TableAdapter

Lecture 10: Save Image in SQL DataBase

Lecture 11: Configure TableAdpter to load saved image in form