Dim con As New Data.SqlClient.SqlConnection Dim cmd As New Data.SqlClient.SqlCommand Dim retValue As New Integer Dim conString As String = ConfigurationManager.ConnectionStrings ("LoginConnectionString").ConnectionString con.ConnectionString = conString Dim cmdString As String = "SELECT COUNT(*) FROM Logins WHERE Username = '" + txtUsername.Text + "' AND Password = '" + txtPassword.Text + "'" cmd.CommandText = cmdString cmd.Connection = con con.Open() retValue = cmd.ExecuteScalar() con.Close() If (retValue > 0) Then Label1.Text = "Welcome " + unameTxt.Text + " !!! You are successfully signed in." Else Label1.Text = "Incorrect login.. Check the username and password again." End If