检查用户名和密码是否区分大小写 [英] check case sensitive in username and password

问题描述

我有一个使用vb.net的程序，其中有一个登录表单，用户可以在其中输入用户名和密码.在程序中可以连接到ms访问.
用户名和密码必须区分大小写.但是我的查询不起作用.
提出一些建议.谢谢U ........

Hi, I have a program using vb.net wherein there a log in form where user can enter username and password. In the program can connect to ms access.
The username and password must be a case sensitive. But my query doesn''t work.
Give some suggestions. Thank U........

st1 = "select empname,password from empdetails1 where empname = '" + TextBox1.Text + "'AND password = '" + TextBox2.Text + "'"
                cmd = New OleDbCommand(st1, con)
                dr = cmd.ExecuteReader                
                    If dr.Read = False Then
                        MessageBox.Show("INVALID USER NAME OR PASSWORD")
                    Else
                        Me.Hide()
                        fm.Show()
                    End If

推荐答案

使用like代替=.

或

使用sql LOWER()方法:

Use like instead of =.

or

Use the sql LOWER() method:

...where LOWER(empname) = LOWER(some var)...

这篇关于检查用户名和密码是否区分大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！