gasraebay.blogg.se - Connect visual studio and sql server through web.config

#CONNECT VISUAL STUDIO AND SQL SERVER THROUGH WEB.CONFIG HOW TO#
#CONNECT VISUAL STUDIO AND SQL SERVER THROUGH WEB.CONFIG PASSWORD#
#CONNECT VISUAL STUDIO AND SQL SERVER THROUGH WEB.CONFIG WINDOWS#

#CONNECT VISUAL STUDIO AND SQL SERVER THROUGH WEB.CONFIG HOW TO#

Enjoy :).Summary: in this tutorial, you will learn how to connect to SQL Server from the SQL Server Management Studio and execute a query. The next time I will put some more interesting commands, thank you. So friends this article will help you to create a Login Form in Visual Studio and connect with SQL Server.

private void button2_Click( object sender, EventArgs e).

MessageBox.Show( "Invalid Login please check username and password" ).

MessageBox.Show( "Login sucess Welcome to Homepage " ).

SqlDataAdapter da = new SqlDataAdapter(cmd).

SqlCommand cmd = new SqlCommand( "select userid,password from login where userid='" + textBox1.Text + "'and password='" + text Box2.Text + "'" , con).

private void button1_Click( object sender, EventArgs e).

SqlConnection con = new SqlConnection( "Data Source=KRISHNA-PC\\SQLEXPRESS Initial Catalog=STUDENT Integrated Security=True" ).

// TODO: This line of code loads data into the 'sTUDENTDataSet.login' table. You can move, or remove it, as needed.

private void Form1_Load( object sender, EventArgs e).

con.ConnectionString = "Data Source=KRISHNA-PC\\SQLEXPRESS Initial Catalog=STUDENT Integrated Security=True".

SqlConnection con = new SqlConnection().

This is the coding part of this application below: You use only these three passwords for this login form. This is SQL Server 2008 Database Details and show here the userid and Password. 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.Ĭlick 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:

#CONNECT VISUAL STUDIO AND SQL SERVER THROUGH WEB.CONFIG WINDOWS#

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.

#CONNECT VISUAL STUDIO AND SQL SERVER THROUGH WEB.CONFIG PASSWORD#

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.