英文:
How do I get a password hint from an Access Database
问题
我目前正在制作一个C# WinForms POS应用程序,使用Microsoft Access数据库(因为这是我唯一知道如何使用的数据库类型)。
我需要获取一个密码提示字段,只知道数据库中的用户名字段。基本上,如果用户忘记了他们的密码,他们可以输入他们的用户名,然后获取他们的提示。
我知道我需要使用某种SQL查询,但我不知道如何确切地构建它。我能够使用他们的密码登录用户。我尝试过这个SQL查询:SELECT Username, [Hint] FROM Users WHERE [Username] = ? AND [Hint] = ?
任何帮助将不胜感激,
EB。
英文:
I'm currently making a C# winforms POS application, using an Microsft Access database (since its the only type of database I know how to use)
I need to get a password hint field, only knowing the username field in the database. Basically, if the user forgets their password, they can enter their username, and get their hint.
I know I need to use some kind of SQL query, but I don't know exactly how to form it. I'm able to login the user with their password. I have tried this SQL query; SELECT Username, [Hint] FROM Users WHERE [Username] = ? AND [Hint] = ?
Any help would be greatly appreciated,
EB.
答案1
得分: 0
SELECT [提示] FROM 用户 WHERE [用户名] = ?
英文:
I guess you need only this:
SELECT [Hint] FROM Users WHERE [Username] = ?
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论