connection visual studio and sql server on seperate drives

Then 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. In Data Binding click the text area and it will look like: To connect with a SQL Server database right-click on the form and click on properties then go to the upper second option (Data Binding). Now the final design looks like this type. Look at the following:Īll 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. Then right-click each tool one by one and set the properties for font and color. Now drag all text boxes and labels and buttons and arrange all the tools. See the image button1 to show the Log In and button2 show Cancel for style. where & is used for a small Underline only one first text look up.

Then 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. If you wish you can set the form1 name my form1 name is “Log in Form”.Ĭlick the Toolbox and drag and drop two buttons and two labels and two TextBoxes as in the following: Set the Windows Forms form name and show text in the specified properties. 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. In your Windows Forms form set the size as needed. You can change the name as you wish or as per program creation you can mention and click and OK.Īfter clicking OK a simple Windows Forms form will look like: In the following see the Name label and already show the default name WindowFormsApplication7. In Installed Templates the first option is Visual C# language and then select Windows Forms application. When open it will look like this:Ĭlick on the middle tab of new project. Open any version of Visual Studio you have installed in your machine I have Visual Studio 10.

The following procedure shows how to create a login form in Visual Studio and connect with SQL Server in 10 steps.

Connection visual studio and sql server on seperate drives