Lcase,ucase In Vb.NET

[knychtell]

Hi there!, i got a problem with classes, can somebody help me with it?
i have created a login form(basic login form) with 2 txtboxes and a pair of buttons, how can i use the LCASE or UCASE, the narative says, that whenever the user inputs a correct PWD and USername,he?she can get access, the username"USER1" is not case sensitive,

i have a sample code here,

dim a,b as string
a= "USER1"
B=LCASE(A)



CAN SOMEONE PLS, HELP ME FIGURE OUT WHY DOES EVERYTIME I TRY TO INPUT A bold letters it actually gives me an error message "wrong username", even if the word user is correct.

thanks a lot,

[hariharanmca]

Hi there!, i got a problem with classes, can somebody help me with it?
i have created a login form(basic login form) with 2 txtboxes and a pair of buttons, how can i use the LCASE or UCASE, the narative says, that whenever the user inputs a correct PWD and USername,he?she can get access, the username"USER1" is not case sensitive,

i have a sample code here,

dim a,b as string
a= "USER1"
B=LCASE(A)



CAN SOMEONE PLS, HELP ME FIGURE OUT WHY DOES EVERYTIME I TRY TO INPUT A bold letters it actually gives me an error message "wrong username", even if the word user is correct.

thanks a lot,

which Database you are using (MsAccess or SQL Server)

[hariharanmca]

Hi there!, i got a problem with classes, can somebody help me with it?
i have created a login form(basic login form) with 2 txtboxes and a pair of buttons, how can i use the LCASE or UCASE, the narative says, that whenever the user inputs a correct PWD and USername,he?she can get access, the username"USER1" is not case sensitive,

i have a sample code here,

dim a,b as string
a= "USER1"
B=LCASE(A)



CAN SOMEONE PLS, HELP ME FIGURE OUT WHY DOES EVERYTIME I TRY TO INPUT A bold letters it actually gives me an error message "wrong username", even if the word user is correct.

thanks a lot,

If SQL Server then

===================== Qry===================
SQL Server
----------------
select * from tblUser where UPPER(UserName) like '" & ucase(txtUserName.text) & "' and UPPER(Passward) like '" & ucase(txtPassword.text) & "'

MS Access
------------------

select * from tblUser where UCase(UserName) like '" & ucase(txtUserName.text) & "' and UCase(Passward) like '" & ucase(txtPassword.text) & "'

[knychtell]

Thanks, but, maam, its in vb.net, it is just a simple program, all i have to do is just to display a list of names and their equivalent value, i dont use database, just a mere code for a button, a loop.
thanks again for your kindness......

[Killer42]

Thanks, but, maam, its in vb.net, it is just a simple program, all i have to do is just to display a list of names and their equivalent value, i dont use database, just a mere code for a button, a loop.
thanks again for your kindness......

I think we need to see more of your code. Specifically, the code which decides the user ID is not correct.

[knychtell]

im, so sorry, but its not with me right now, im at school, its on my pc,
but, i know the code..
WHAT I DID WAS, I declared several variables as string
for the possible combinations of smmall and big letters fo the word "USER"
it i think its a-n ,might sound really funny but i did it and my prof, lough at.
except "e" you know what i mean,


dim a, b as string
dim z as new frm2
a= "USER1"
b="USEr1"
c="USer1"
d="User1"
f="uSER1"
g="usER1"
h="useR1'
j="user1"
k="UseR1"
l="UsEr1'



i combined these letters to P@ssw0rd
just like the code below,
do
if txtbox1.text =a and txtbox2.text="P@ssw0rd"
then messagebox.show("Welcome User1")
z.show
me.hide
end if
exit do


i wish this could help, if you'l figure it out , you will surely laugh at me......:)
thanks a lot for your responce maa'm......

[Killer42]

I don't think you need to worry about people laughing at you. We all had to start somewhere, and have probably done very similar things at some time.

I think what you need to do is to use the Lcase or Ucase functions to ensure that both strings are in the same state (UPPERCASE/lowercase) before comparing them. For example...

If Ucase(Text1.Text) = Ucase(a) Then ...

[knychtell]

WHew.... Thanks maa'm it really did help me a lot in my problem, tommorow's the big day for me, thanks again...