Vb登录.... [英] Vb Login ....
问题描述
嗨..
我有一张表，其中包含用户记录和其他一些用户详细信息。表名是userdetails。
程序运行时的第一页是登录。如果用户输入正确的用户名...即现有用户名及其有效密码，则ctrl移至下一页执行。 Orelse它表示用户/密码不存在。只有现有用户才能登录。
我的前端是vb6，后端是oracle。
我有两个txt盒子和2 cmds。 text1用于用户名，text2用于密码。以及用于登录和取消的命令。
请帮帮我。紧急..
提前致谢。
Hi ..
I have a table which has user records and some other user details..table name is userdetails.
My first page when the program runs is login. If the user enters right username..i.e existing username and its valid password ctrl moves to next page of execution. Orelse it shoud indicate that user/password isnt existing. only existing users can login.
My frontend is vb6 and backend is oracle.
I have two txt boxes and 2 cmds. text1 is for username and text2 for password. and commands for login and cancel.
please help me out people. its urgent..
Thanks in advance.
推荐答案
检查数据库中是否存在用户名和相应的密码或不计算数。尝试使用SQL来达到目的。
如果是1然后继续。
Check if the user name and corresponding passsword exists in your database or notusing count. Try to use SQL for the purpose.
if it is 1 then proceed.
抱歉我无法得到你...我有用户名那个表user.dtails。我需要验证用户是否输入了userdetails表中的用户名。多数民众赞成我的意思是existign用户。用户名和密码以及用户的其他详细信息存在于userdetails中。
loginname shoudl是该表的现有用户名。每个用户都有一个密码，该密码与该表一样。
sorry i couldnt get u.. i have the username in that table userdetails. i need to verify whether the user has entered the username which is in userdetails table. thats wat i meant by existign user. userid and password and other detials of user is present in userdetails.
loginname shoudl be existing username of that table.and each user has a password which is aslo in that table.
尝试此查询。
try this Query.
这篇关于Vb登录....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
