A. Welcome to Course 1 : SQL ADO.Net in C#
•Introduction to : SQL ADO.Net in C#
•About Me!
•Download projects and files of this course
•How to increase sound volume of tutorials?
•A.a. Visual Studio 2019 Update
•Visual Studio 2019 Section Intro
•Visual Studio 2019 requirements
•How to Install Visual Studio 2019?
•Working with Visual Studio 2019 and C#
•Compare Visual Studio 2019 & Visual Studio 2017
•A.b. Quick Review of SQL Server
•Who should watch this section!
•Download SQL Server 2014 express & requirements
•Install SQL 2014 express in Windows 7
•Install SQL 2014 express in Windows 10
•What is SQL Server & its structure?
•Common parts of SQL Server
•What is SQL Server Management Studio (SSMS) ?
•Customize SQL Server Environment
•What is SQL Server database?
•Create SQL Database
•Different parts of the SQL database
•Rename and delete SQL Database
•Default location of the SQL Database files
•Different type of SQL datbase files
•Using SQL Server configuration manager
•What is SQL table?
•Add table to the SQL Database
•Add data to the SQL table
•Load data in to the SQL table
•Change the design of table & save it
•Rename and delete the SQL table
•What is the prefix “dbo” in SQL table name?
•What is SQL Numeric data type?
•Int data type in SQL
•Bit data type in SQL
•Tinyint data type in SQL
•Smallint data type in SQL
•Bigint data type in SQL
•Float data type in SQL
•Decimal data type in SQL
•Char data type in SQL
•Varchar data type in SQL
•Varchar(max) data type in SQL
•Text data type in SQL
•nchar data type in SQL
•nvarchar data type in SQL
•nvarchar Max data type in SQL
•ntext data type in SQL
•What is GUID in SQL?
•Using GUID in SQL Server
•How to detach SQL database?
•How to attach SQL database?
•Attach SQL database without LDF file
•Make SQL database offline and online
•Create sample database to set identity column
•Add identity and auto increment column and test it
•Identity column count in each table
•SQL Date data type
•SQL Smalldatetime data type
•SQL Datetime data type
•SQL Datetime2 data type
•SQL Datetimeoffset data type
•SQL Time data type
•A.c. Create “Phone Book” Database in SQL
•Quick review and road map of this course
•Create “Phone Book” database in SQL
•Add “Phone Book” table to SQL database
•Add personal & contact columns to “Phone Book” table
•Add Address columns to “Phone Book” table
•Add identity and auto increment column
•Add sample data in SQL for “Phone Book” table
•A.d. Select Data by SQL Select Query
•What is Select Query in SQL?
•Writing our first Select query
•Use Select query with (*) to show all columns
•Sort the records with Select query
•Show specific number of top rows with Select Query
•Show specific number of bottom rows with Select Query
•Reorder the columns in Select Query
•A.e. SQL ADO.Net in C#
•Section Introduction for SQL ADO.Net
•SQL ADO.Net Introduction
•Create C# Phone Book Project for SQL Server
•Add Dataset to C# project
•Add Table Adapter to Dataset
•SQL Server Connection String in Depth
•A.f. Dataset and Table Adapter
•Using Manual Query editor in C#
•Using Diagram & Criteria to Create SQL Select Query
•Finish Adding Table Adapter to Dataset
•What is Dataset and Data table in C#
•What is Table Adapter in C#
•How to configure SQL Query in Table Adapter
•A.g. Creating Phone Book Data Form
•Add Datagrid view to Phone Book form
•Resolve errors and create form again
•What is Binding Source?
•Add All Textboxes & Labels to Phone Book Form
•Adding Textbox & Label one by one to Form
•Configure New , Delete and Save Buttons in Form
•Add Records to Dataset and save in SQL Server Database
•A.h. Data Entry Form Toolbar
•Upgrade to Visual Studio 2019 my Phone Book project
•Add toolbar to data entry form
•Add image to toolbar buttons
•EnableDisable toolbar buttons by C# code
•Create method for EnableDisable buttons
•EnableDisable Datagridview & Groupbox by C# code
•A.i. Data Entry Buttons C# Coding
•Write “Add New ” button code in C#
•Write “Save Changes” button code in C#
•Show message box after saving data to SQL
•Write “Delete” button code in C#
•Write “Edit” & “Cancel” buttons code in C#
•Add empty record guard to “Edit” & “Delete” Buttons
•Disable groupbox Items when click the “Delete” button
•A.j. Using TableAdapter & BindingNavigator
•TableAdapter section intro
•Use default Fill method of TableAdapter
•Add new Fill method for TableAdapter and use it
•Add new BindingNavigator and using it
•Customize default BindingNavigator
•A.k. Working with DataGridView
•Disable DGV edit,delete,column reorder,new row and …
•Disable DGV column & row resize
•Add and remove DGV columns
•Change the width and visibility of columns in DGV
•Change the text of Columns in DGV
•A.l. Advance Topics of DataTable & BindingSource
•Get the Row count by using DataTable
•Get the Row count after deleting some records by using DataTable
•Sort the records inside DataTable using Select query
•Get the Row count by using BindingSource
•Get the current record position using BindingSource
•Sort the records inside DataTable using BindingSource
•A.m. Create Custom BindingNavigator
•Design custom BindingNavigator by normal buttons
•Write the code to navigate between records
•Adding “Current Record” & “Total Records” labels to custom Navigator
•Disable “First” & “Previous” buttons in first record
•Disable “Last” & “Next” buttons in last record
•A.n. Adding Protection to C# Codes
•Using “Try” structure to protect C# codes against errors
•A.o. Save Customer Image in SQL Database
•Section intro for saving customer image in SQL DB
•Steps to save customer image in SQL database
•Add customer image picturebox and browse button
•Write the code to load customer image in C#
•Add empty image guard to customer image
•Add filter for selecting customer image
•Add “No Image” picture for new customer image
•Add customer image column to SQL Server database
•Add customer image column to C# project by Configuring TableAdapter
•Save Image in SQL DataBase
•Configure TableAdpter to load saved image in form
•B. Welcome to Course 2 : Beginners Search SQL in C#
•What you’ll learn in : Beginners course to Search SQL Server data in C#
•B.a. Review: Create “Phone Book” Database in SQL
•Introduction to Phone Book Database in SQL
•Create phone book project database in SQL Server
•Add personal columns to phone book table
•Add contacts columns to phone book table
•Add address columns to phone book table
•Add sample data and test our SQL table
•B.b. Phone Book Project in C# to Search the Data
•Introduction to Phone Book in C#
•Add Dataset & TableAdapter to Phone Book app
•Bind datatable to Datagrid View on form
•Load data in to form from the SQL database
•B.c. Where Clause for Searching Data in SQL
•Introduction to Where Clause in SQL
•Using Where clause to find English characters
•Using Where clause to find Unicode characters
•Using Where clause to find Numbers
•Different operators with Where clause
•Use Not equal operator(<>) with Were clause
•B.d. Searching SQL Data in C# Form
•Introduction to Searching data in C#
•Write query to search fix last name in C#
•Write query to search last name from textbox
•Write query to search numeric columns
•Search Unicode text in SQL table by C#
•Use Not equal operator(<>) for searching in C# and SQL
•Use other operators for search in SQL numeric columns in C#
•B.e. SQL Like Operator for Searching
•Introduction to LIKE Operator in SQL
•LIKE operator simple usage for searching data
•LIKE operator with Wildcard ‘%’ at the en