Torna al Thread

Private Sub ButtonAccedi_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonAccedi.Click 'Login Dim login As String = "" Dim conn As OleDb.OleDbConnection conn = New OleDb.OleDbConnection("Provider=sqloledb;" & _ "Data Source=IPdelSERVER;" & _ "Initial Catalog=NOMEdb;" & _ "User Id=USER;" & _ "Password=PSW;") Dim cmd As New OleDb.OleDbCommand Dim reader As OleDb.OleDbDataReader Dim sql As String = "SELECT * FROM utenti " & _ "WHERE user_id = '" & Request.Form("TextBoxUtente") & "' AND " & _ "pass = '" & Request.Form("TextboxPass") & "'" Try conn.Open() cmd = New OleDb.OleDbCommand(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
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5