->
Udemy - SQL in C# Series: Multi User App by Login Form in C# & SQL
Udemy - SQL in C# Series: Multi User App by Login Form in C# & SQL

Hi There!


Description

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

So

If you try you will learn Create Multi User App by login form in SQL and C#!

If you are beginners or student looking for a tutorial to create a Multi User App by login form in SQL Server and create a application for that in C# in simplest way!

I started from beginning and show you how to start working with SQL Server and create Login Users database.

Then started to talk about :

- SQL ADO.Net and it's concept and parts and ...

- Create Multi User App by login form project in C#.

- Connect your C# application to SQL Database.

- Create a C# App for login user and show data in Data Grid View.

- Add Textboxes and Labels to show data!

- Add New record,Delete and save changes in SQL Database!

- Create login user form

- Create main form for C# project

- Show login form at Application startup

- Authenticate users to login in to App

Don't hesitate to start learning Multi User App by login form in SQL and C#!

Every thing will be discussed with sample project and you will have pro tips and tricks within my course.

Say Hi Multi User App by login form by SQL & C# world and let's go !!!

Who this course is for:
  • C# programmers who want to work with SQL Server database in C# code!
  • C# programmers who want to create professional login form in SQL & C#
  • C# programmers who want to make more money by creating amazing login form in C#

Course content

  • Introduction
    • Introduction
    • About Me!
    • How to increase sound volume of tutorials?
  • 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?
    • How to detach SQL database?
    • How to attach SQL database?
    • Attach SQL database without LDF file
    • Make SQL database offline and online
  • Create Users Login Database in SQL
    • Create SQL Database for Users Login
    • CREATE TABLE IF NOT EXISTS for Users Login in SQL Database
    • Add Users Login sample data in SQL Database
  • Create Project for Users Login in C#
    • Create Users Login project in C#
    • Add main form for project
    • Add top & bottom panels with buttons
    • Add image & text to toolbar buttons
  • Use SQL Database in C#
    • Introduction to SQL ADO.Net in C#
    • Add Dataset to C# project
    • Connect C# project to SQL Server
    • Add Select query to Table adapter
    • Finish adding Datatable to Dataset and Tips
    • Connection String in depth and configuring Tableadapter query
  • Design Login List Main Form
    • Add main login users list form to C# project
    • Add Datagrid view to login users list form
    • Write the code to load user list data by TableAdapter
    • Customize DataGrid View (DGV)
  • Design User Register Form
    • Add user register form
    • Design User Register Form
    • Add items to user register form
    • Write the code to disable & enable data entry buttons
    • Write the code to disable & enable items inside groupbox
  • Coding User Register Form in C#
    • Write "Add New User " button code in C#
    • Write "Save Changes" button code in C#
    • Show message box after saving data to SQL
    • Transfer selected ID from main form to the child form
    • Add the SQL query to load data by ID in TableAdapter
    • Write the code to load user data by selected ID
    • Write "Edit" & "Delete" button code in C#
    • Write "Cancel" button code in C#
  • User Register Form Advance Coding
    • Add empty record guard to "Edit" & "Delete" Buttons
    • Fill the data by last "ID" after saving in database
    • Refresh the records after closing user register form
  • Saving User Image in SQL Database
    • Section intro for saving user image
    • Load the user image in picturebox
    • Add the guard for empty user image
    • Add filter for selecting user image
    • Saving User Image in SQL Database
  • Designing User Login Form
    • Add login form to project
    • Design login form and adding controls to it
    • Bind user name combobox to data table
    • Add login info labels to login form
    • Bind user image picturebox to user image column
    • Write the code to verify user entered password
    • Limit password textbox chars and add guard to ...
  • Using Login Form by Main Form
    • Section intro for using login form
    • Show users list form within main form
    • Show login form at App startup
    • Write the "Exit Button" code in login form
    • Saving user login info in App settings
    • Show login user image & name in main form
    • Finalize login form coding!
  • Advance Topics: Product List Data Entry Form
    • Section intro
    • Create "Product List" database in SQL Server
    • Add sample data in SQL for Product List table
    • Add "Product List" table to dataset in our Project
    • Add Product List data entry form
    • Design the Product List form
    • Write the code for Product List form to save data
    • Add value to the "User Name" & "User Id" labels
    • Add value to the "System Date" & "System Time" labels
    • Connect Product List form to the main form
  • Finalizing the Project
    • Add guard & protection to codes by "Try" Structure
    • Add the background image to the main form
  • Bonus Section: Get My Other Courses with Discount
    • Bonus Lecture: Get Amazing Discount for My Other Courses


 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.


 Coktum   |  

Information
Members of Guests cannot leave comments.




rss