title: Create a Case Sensitive Login Form in VB 10
body: <p>I want to Create a Login Form that the fields in password are case sensitive example if my passwords is "PassWord" it will only accepts the keyword "PassWord" and not accepts "password" Or "PASSWORD" keyword etc. I want it a character sensitive thanks Please Help me Im a new Programmer using DATABASE MS ACCESS Thanks Here is my code</p>
  
  <pre><code> Private Sub btnLog_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLog.Click
      Try
          Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\NIASecurity.accdb")
          Dim cmd As OleDbCommand = New OleDbCommand("SELECT [Username] FROM [Security] WHERE [Username] = @User and Password =@Pass ", con)
          cmd.Parameters.AddWithValue("@User", txtUser.Text)
          cmd.Parameters.AddWithValue("@Pass", txtPass.Text)
          con.Open()
          Dim sdr As OleDbDataReader = cmd.ExecuteReader()
          If sdr.Read Then
              If txtPass.Text = sdr(0) Then
                  MessageBox.Show("Welcome")
                  Dim win As New frmAdd
                  win.MdiParent = frmMDI
                  win.Show()
                  Me.Close()
              Else
                  MsgBox("Invalid name or password!")
  
              End If
          End If
  
  
      Catch ex As Exception
          MessageBox.Show("Invalid name or password!")
      End Try
  End Sub
  </code></pre>