How To Create Login Form with Visual Studio and SQL Server

What you'll learn

Design a form in Visual Studio
Add controls to form
Modify form and control properties
Create a new database in SQL Server
Create a table
Populate table
Add database to visual studio project
Write code to connect form to database


Requirements

Basic knowledge of visual studio
Basic knowledge of C#
Basic knowledge of SQL Server
Basic knowledge of SQL
Basic knowledge of T-SQL

Description

The best way to acquire technical skills is by building various types of projects.

We are going to create a database driven user login form using Microsoft visual studio,Microsoft SQL Server,SQL | T-SQL and C#


Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft.

It is used to develop computer programs, as well as websites, web apps, web services and mobile apps.


Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It's primary function is storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network or the internet.


SQL (Structured Query Language) is a standard language for accessing and manipulating databases. It can be used to create databases,tables ,insert records into tables,update records,delete records etc.

Transact-SQL (T-SQL) is Microsoft's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases


C# is a programming language developed by Microsoft. It enables developers to build a variety of applications

and can interact with databases.


What You will Learn includes:


Designing a form with controls

Create a database

Create a table

Populate table

Add database to visual studio project

Interact with database using C# and SQL|T-SQL


Who this course is for:

Beginners with some knowledge of SQL Server | C# | Visual studio| SQL and T-SQL