This article explains how to create a login form in Visual Studio and connect with SQL Server.
The following procedure shows how to create a login form in Visual Studio and connect with SQL Server in 10 steps.Step 1Open any version of Visual Studio you have installed in your machine; I have Visual Studio 10. When open it will look like this: Step 2Click on the middle tab of new project. When you click it will look like this:Step 3In Installed Templates the first option is Visual C# language and then select Windows Forms application.In the following see the Name label and already show the default name WindowFormsApplication7.You can change the name as you wish or as per program creation you can mention and click and OK.Step 4After clicking OK a simple Windows Forms form will look like:Step 5In your Windows Forms form set the size as needed. You can set the size and if you want to set the size by properties then right-click on the Windows Forms form and in the last option of show properties click to see the Windows Forms form properties.Set the Windows Forms form name and show text in the specified properties. If you wish you can set the form1 name; my form1 name is “Log in Form”.Click the Toolbox and drag and drop two buttons and two labels and two TextBoxes as in the following:Step 6Then you need to change the lable1 name to User Name and label2 to Password then for the Buttons change the button1 right-click property to show text select button1 and type &Log In and button2 &Cancel. where & is used for a small Underline only one first text look up. See the image button1 to show the Log In and button2 show Cancel for style .Step 7Now drag all text boxes and labels and buttons and arrange all the tools.Then right-click each tool one by one and set the properties for font and color. Look at the following:All sets of fonts and font size and if you want to set the image background set and form icon also you can set and more things and tab index set serially for all tool of labels, TextBox and buttons.Now the final design looks like this type.Step 8To connect with a SQL Server database right-click on the form and click on properties then go to the upper second option (Data Binding). In Data Binding click the text area and it will look like:Now click on Add project data Source.Step 9Then open these windows select “Database” and click Next then select “Dataset” and click Next again select “Dataset” and click Next then click on New connection then click the Refresh Button then select your SQL Server name. For example my SQL name is KRISHNA-PC\SQLEXPRESS for the select radio button select or enter a database name for example my database name STUDENT then click Test Connection and click the OK Button.Click the connection string to show this type of connection string then select and copy then click on "Next" again click Next tick table and the finish button now see the window:This is SQL Server 2008 Database Details and show here the userid and Password. You use only these three passwords for this login form.Step 10This is the coding part of this application below: