Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        'Login
        Dim login As String = ""
        Dim conn As New SqlConnection("Data Source=IPdelSERVER;" & _
                          "Integrated Security=false;" & _
                          "Initial Catalog=NOMEdb;" & _
                          "User id=USER;" & _
                          "password=PSW;")

        Dim cmd As New SqlClient.SqlCommand
        Dim reader As SqlClient.SqlDataReader
        Dim sql As String = "SELECT * FROM utenti " & _
                            "WHERE user_id = '" & Request.Form("TextBoxUtente") & "' AND " & _
                                  "pass = '" & Request.Form("TextboxPass") & "'"
        Try
            conn.Open()
            cmd = New SqlClient.SqlCommand(sql, conn)
            reader = cmd.ExecuteReader()
            If reader.Read Then
                Session("login") = reader.Item("tipo")
                Try
                    Response.Redirect("clienti.aspx", False)
                Catch ex As Exception
                    Me.TextBoxMessage.Text = ex.ToString
                End Try
            Else
                Me.TextBoxMessage.Text = "Utente non riconosciuto"
            End If
        Catch ex As Exception
            Me.TextBoxMessage.Text = ex.ToString()
        Finally
            conn.Close()
        End Try
    End Sub