• 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

Create a login form step by step in Visual Studio and connect to SQL Server using C#

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