Lattex

Untitled

Apr 21st, 2012
31
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 0.77 KB | None | 0 0
  1. Imports System.Windows.Forms
  2. Imports System.Data.SqlClient
  3. Imports System.Data.SqlClient.SqlConnection
  4. Public Class Form1
  5. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  6. Dim ConnString As String = "Data Source=MARCELLA-PC;Initial Catalog=superclean;User Id=sa;Password=fabio;"
  7. Dim sqlcon As New SqlConnection(ConnString)
  8. Dim sql As String = "SELECT USERNAME,PASSWORD FROM UTENTI WHERE USERNAME=@USERN AND PASSWORD=@PASSW"
  9. Dim cmd As New SqlCommand(sql, sqlcon)
  10. Dim user As String
  11. Dim pass As String
  12.  
  13. cmd.Parameters.Add("@USERN", SqlDbType.Text)
  14. cmd.Parameters("@USERN").Value = user
  15. cmd.Parameters.Add("@PASSW", SqlDbType.Text)
  16. cmd.Parameters("@PASSW").Value = pass
  17. sqlcon.Open()
  18. cmd.ExecuteReader()
  19. sqlcon.Close()
Advertisement
Add Comment
Please, Sign In to add comment