MySQL in C# : Design SQL Pro Database Apps in C# & MySQL

 | Details:

Duration: About 18:30 Hours

Publish Date: 27/01/2020

MySQL in C# Tutorials

| Tutorial Contents of this course :

5 in 1: Data Entry App ,ADO.Net ,Search SQL Data in C# ,MySQL Database For Beginners ,Image in MySQL ,Dictionary Project


| Tutorial Overview:

Hi There!

With my 20 years programming skills i'm with you to share my knowledge with you.


If you try you will learn using MySQL Server Database in C# Application!

If you are beginners or student looking for a tutorial to create a Phone Book database in MySQL Server and create a application for that in C# in simplest way!

I started from beginning and show you how to:

5 Courses in one Course!

Start working with MySQL Server and create phone book database.

SELECT Query in MySQL Server and ...

MySQL ADO.Net and it's concept and parts and ...

Creating Phone Book as data entry project in C#

Connect you Visual Basic application to MySQL Database.

Create a C# App for phone book and show data in Data Grid View.

Add Textboxes and Labels to show data!

Add New record,Delete and save changes in MySQL Database!

Search the MySQL data in C# App

Save Image in MySQL Database

Pro English Dictionary in C# and MySQL

And ...

Don't hesitate to start learning MySQL Server in C#!

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

Say Hi MySQL & C# world and let's go !!!

Who this course is for:

C# programmers who want to work with Oracle MySQL Server in C# code!
C# programmers who want to Learn Quickly MySQL Server in C# code!
C# programmers who want to make more money by Using MySQL Server in C# !


| Table of Contents:

 Show AllDurationDownload

Section 1 . A. Welcome to this Course : Complete MySQL in C#

 What you'll learn in Complete Database Apps in C# & MySQL08:22
 About Me!01:57
 How to increase sound volume of tutorials?02:01

Section 2 . A.a. Quick Review of MySQL

 Who should watch this section!01:59
 Download the Oracle MySQL06:10
 Install MySQL on Windows 10-64 Bit12:35
 Install .Net framework 4.5.2 on Windows 7-64 Bit05:05
 Install MySQL on Windows 7- 64 Bit12:29
 Various features of MySQL04:05
 Create the MySQL Connection for connecting to it06:48
 Using main parts on MySQL Workbench06:46
 What is MySQL Database?03:10
 Create the Database in MySQL09:31
 Edit- delete and configure My SQL database?07:35
 What is Charset in My SQL Database?06:24
 What is the Collation in My SQL Database?05:33
 Utf8mb4 Charset and Collation in MySQL Database06:55
 introduction to My SQL Table05:17
 Add Simple table to the MySQL Database07:54
 Create Multi-Column table in MySQL08:38
 How to edit and configure the table in MySQL?07:00
 Add sample data to MySQL table07:31
 What is MySQL data types?02:37
 What is MySQL Numeric data types?04:24
 Various Decimal Data Types in MySQL05:24
 Various Date Time Data types in MySQL03:39
 Various Text & Char data types in MySQL05:07
 What is Auto-Increment column in MySQL?04:05
 Add Auto-Increment column in MySQL03:57
 Reset Auto Increment value in MySQL05:53

Section 3 . B. Welcome to : MySQL ADO.Net & Data Entry in C#

 What you'll learn in: C# & MySQL and Data Entry in MySQL03:29

Section 4 . B.a. Create "Phone Book" Database in MySQL

 Create Phone Book Database in MySQL04:24
 Add Personal columns to "Customer List" table09:26
 Add Contact columns to "Customer List" table05:39
 Add auto increment to "ID" column02:17
 Add sample data and test our MySQL table09:58

Section 5 . B.b. Install MySQL for Visual Studio

 Download MySQL tools & connector for Visual Studio04:02
 Install MySQL tools & connector for Visual Studio03:25
 Check MySQL tools in Visual Studio after installing03:17

Section 6 . B.c. MySQL ADO.Net

 Introduction to MySQL ADO.Net technology05:29
 Create C# Phone Book Project for MySQL05:19
 Set the default properties of form02:38
 Add Dataset to C# project07:30
 Add Table Adapter to Dataset & connect it to MySQL database09:37

Section 7 . B.d. Query Editor in Table Adapter

 Simple Using Query editor in C#05:42
 Advance Using Query editor in C#06:42
 Sort the records in Query Builder05:55
 Finish Adding Table Adapter to Dataset07:16

Section 8 . B.e. Dataset and Table Adapter

 What is Dataset and Data table in C#05:55
 What is Table Adapter in C#05:16
 Make a back up copy of our project04:14
 How to configure SQL Query in Table Adapter05:12
 MySQL Connection String in Depth04:23

Section 9 . B.f. Add Datagrid View to "Phone Book" Form

 Add Datagrid view to Phone Book form07:51
 Change the .net framework version of C# project to 4.5.203:32
 Using binding navigator to Add, Delete & save the changes to MySQL database07:56
 Auto calculate last inserted id in MySQL database & show on form08:54

Section 10 . B.g. Add Data Entry Items to "Phone Book" Form

 What is Binding Source?05:46
 Add Group of Textboxs & Labels to "Phone Book" Form05:27
 Add manually the Textboxs & Labels to "Phone Book" Form06:18
 Bind the TextBox manually to the DataTable05:55
 Customize Binding Navigators default buttons06:34

Section 11 . B.h. Data Entry Form Toolbar

 Section intro00:46
 Add toolbar to data entry form04:38
 Add image to toolbar buttons04:54
 Enable|Disable toolbar buttons by C# code08:12
 Create method for Enable|Disable buttons05:41
 Enable|Disable DGV & Groupbox & BindingNavigator by C# code08:15

Section 12 . B.i. Data Entry Buttons C# Coding

 Section intro00:53
 Write "Add New " button code in C#04:53
 Write "Save Changes" button code in C#07:27
 Test save button code for saving data to MySQL DB06:02
 Show message box after saving data to SQL04:48
 Write "Delete" button code in C#05:03
 Write "Edit" & "Cancel" buttons code in C#07:49
 Add empty record guard to "Edit" & "Delete" Buttons08:10
 Disable groupbox Items when click the "Delete" button06:31

Section 13 . B.j. Using the TableAdapter & BindingNavigator

 TableAdapter section intro00:48
 Use default Fill method of TableAdapter06:13
 Add new Fill method for TableAdapter and use it08:47
 Add new BindingNavigator and using it06:39
 Customize default BindingNavigator05:33

Section 14 . B.k. Working with DataGridView

 Disable DGV edit,delete,column reorder,new row and ...05:48
 Disable DGV column & row resize01:34
 Add and remove DGV columns06:04
 Change the width and visibility of columns in DGV03:32
 Change the text of Columns in DGV04:34

Section 15 . C. Welcome to: Save Image in MySQL Database

 What you'll learn in: Saving image in MySQL DataBase00:36

Section 16 . C.a. Add Customer Image to Form

 Steps to save customer image in MySQL database03:39
 Blob Data type to save image in MySQL02:39
 Add customer image column to MySQL datatbase05:52
 Add customer image picturebox and browse button06:31
 Write the code to load customer image in C#08:01
 Add empty image guard to customer image03:30
 Add filter for selecting customer image05:38
 Add "No Image" picture for new customer image03:27

Section 17 . C.b. Save Image in MySQL Database

 Add Image column to datatable by TableAdapter06:44
 Save customer image in MySQL database07:47
 Add image column to datagridview05:27
 Exclude image column from loading05:54

Section 18 . D. Welcome to : Search MySQL Data in C#

 What you'll learn in Search MySQL Data in C# code00:35

Section 19 . D.a. Create Search Project in C#

 Create C# Search Project for MySQL05:34
 Set the default properties of form04:54

Section 20 . D.b. Create Sample Database in MySQL

 Section Intro for Sample MySQL Database Preview00:51
 Create sample Database in MySQL for this course04:24
 Add Personal columns to "Customer List" table09:26
 Add Contact columns to MySQL table05:39
 Add auto increment to "ID" column02:17
 Add sample data and check our MySQL table09:58

Section 21 . D.c. Add MySQL to the Visual Studio

 Section intro00:51
 Download MySQL tools & connector for Visual Studio04:01
 Install MySQL tools & connector for Visual Studio03:25
 Check MySQL tools in Visual Studio after installing03:17

Section 22 . D.d. Using MySQL ADO.Net in C# Project

 Section Intro for C# MySQL01:57
 What is MySQL ADO.Net in C#?05:29
 Add Dataset to C# project06:44
 Add Table Adapter and connect dataset to MySQL09:37
 Using query builder and add data table to dataset07:49
 Connection String in depth and configuring Tableadapter query06:41
 Bind datatable to Datagrid View on form07:00
 Change the .net framework version of C# project to 4.5.203:09
 Load data in to form from the MySQL database08:36

Section 23 . D.e. Where Clause for Searching Data in MySQL

 Overview of Where clause in MySQL01:35
 Using Where clause to find English & Unicode characters08:42
 Make where clause , case sensitive while searching05:49
 Using Where clause to find Numbers06:13
 Use Not equal operator(<>) with Were clause02:15

Section 24 . D.f. Searching MySQL Data in C# Form

 Introduction to Searching MySQL Data in C#01:47
 Write query to search fix last name in C#08:27
 Write query to search last name from textbox05:57
 Search Unicode text in MySQL table by C#05:03
 Write query to search numeric columns09:50
 Use Not equal operator(<>) for searching in C# and MySQL05:05
 Use other operators for search in MySQL numeric columns in C#03:59

Section 25 . D.g. MySQL Like Operator for Searching

 Introduction to LIKE Operator in MySQL01:50
 LIKE operator simple usage for searching data06:36
 LIKE operator with Wildcard '%' to search similar values07:02
 LIKE operator with Wildcard '%' to search similar Unicode values03:01
 Using other Wildcards with LIKE operator05:41
 Using NOT operator with LIKE operator02:52

Section 26 . D.h. Searching Data in C# by MySQL LIKE operator

 Section intro for searching data in C# by like operator01:16
 LIKE operator in table adapter for searching fix "Last Name"06:21
 Search exact values in C# form by Using like operator03:32
 Using "%" wildcard in Textbox to search similar values07:10
 Using "%" wildcard in C# code to search similar values04:20
 Search Unicode text in MySQL by C# and Like operator05:16

Section 27 . D.i. Between Operator for Searching Data in MySQL

 Introduction to Between operator03:44
 Between operator for Numeric column searching04:51
 Between operator for Text column searching03:32
 Between operator for Date column searching03:57
 Using NOT operator with Between operator05:25

Section 28 . D.j. Between Operator in C# Project

 Section intro to between operator in C#01:06
 Add Between operator to table adapter to search a rage of dates09:32
 Design form to use Between operator03:04
 Working with DateTimePicker control07:30
 C# code to search between dates07:42

Section 29 . D.k. Final Project: Create Pro Search Form

 Section intro of final course project01:39
 Add search form and set it's default properties05:44
 Design search form and add controls to it10:59
 Show hide controls on search form by C# code08:34
 Add Datagrid view to search form to show search results03:36
 Write the code to search by date of birth05:19
 Search last name by like operator09:55
 Search last name by between and not equal operator10:10

Section 30 . E. Welcome to : Pro English Dictionary in C# and MySQL

 Section intro: Create Pro English Dictionary with 176,000 words in C# and MySQL00:35

Section 31 . E.a. Dictionary Database in MySQL

 Section intro to Dictionary database in MySQL00:48
 Download Dictionary Database in MySQL03:19
 Import and attach Dictionary in MySQL workbench04:11
 Rename dictionary table and change it's Engine to InnoDB03:59
 Load data & Add "id" column and auto increment to dictionary table04:20

Section 32 . E.b. Dictionary Project in C#

 Section intro: Creating the C# app for dictionary01:00
 Create Dictionary Project in C#05:25
 Set the default properties of form in C#02:26
 Design search controls on form09:38

Section 33 . E.c. Using MySQL ADO.Net in C# Project

 Section Introduction for MySQL ADO.Net00:56
 What is MySQL ADO.Net in C#?05:29
 Add Dataset to dictionary project in C#04:49
 Add connection to MySQL in Visual Studio04:56
 Add Table Adapter to Dataset and connect it to MySQL04:35
 Create Select query with query builder in table adapter09:55
 Finish Adding Table Adapter & datatable to Dataset05:13
 How to configure SQL Query in Table Adapter08:46
 Connection String in depth03:41

Section 34 . E.d. Load all of the Dictionary Data

 Section intro: Start to Create Dictionary01:49
 How to add Datagrid view to Dictionary form05:51
 Change the .net framework version of C# project to 4.5.205:07
 Add a button & show all of the dictionary records in C# code09:39
 Add new query to Table Adapter to load sorted data07:21
 Show progress panel while loading data05:17
 Add Textbox to show definition of selected word09:13

Section 35 . E.e. DataGrid View settings

 Disable DGV edit,delete,column reorder,new row and ...05:23
 Add or remove DGV columns,Change text & width of columns07:01
 Change DGV row column default settings04:04
 Change the DGV cell to Multi line03:39
 Change the DGV odd and even records backcolor04:14

Section 36 . E.f. Searching the Word in Dictionary

 C# code to search exact word in dictionary06:35
 C# code to search similar words in dictionary08:14
 Sort the records after searching the word in dictionary06:03
 Change the default search type02:24

Section 37 . E.g. Auto Search Words in Dictionary

 Automatically search the words while typing06:28
 Save last searched word by user09:25
 Auto search the last searched world in form load07:22
 Show progress panel while searching the words06:33
 Use the Try structure to protect C# codes11:19, 2003-2020