如何从Access数据库中获取密码提示

huangapple go评论82阅读模式
英文:

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] = ?

huangapple
  • 本文由 发表于 2023年6月15日 19:57:27
  • 转载请务必保留本文链接:https://go.coder-hub.com/76482226.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定