用于创建登录和用户的SQL代码然后将其设计到我的数据库。 [英] A SQL code for create login and user then design it to my database.

问题描述

hi

$ c $ b in c＃我想通过SQL执行创建登录的代码，然后用户将其设计到我的

数据库。

我该怎么办？



非常感谢



我是什么尝试过：



a用于创建登录的SQL代码，用户然后将其设计到我的数据库。

hi
in c# i want to execute a code by SQL for create login and user then design it to my
database.
how can i do this?

thanks very much

What I have tried:

a SQL code for create login and user then design it to my database.

推荐答案

首先设计数据库以保存它：您需要哈希密码，这会对存储产生影响。请参阅此处：密码存储：如何操作。 [ ^ ]

之后，您只需设计登录页面并处理条目以检查用户是否应该登录。



我们可以帮助你：C＃没有提供有关应用程序运行的环境的任何信息，这会影响一大堆事情。例如，Winforms应用程序将与控制台应用程序不同，后者将与WPF应用程序不同。一个网站将完全不同，需要非常特殊的处理（以及使用内置的访问控制功能使其可靠）。

Start by designing the DB to hold it: you need to hash your passwords, and that has an effect on storage. See here: Password Storage: How to do it.[^]
After that, all you need to do it design a login page and process the entries to check if the user should be logged in.

We can't help you with that: "C#" doesn't give any information on the environmnet the app is to run under, and that affects a whole load of things. For example, a Winforms app will be different to a console app, which will be different from a WPF app. A website will be totally different and need very special handling (and the use of built in access control features to make it reliable).

您可以找到许多SQL教程，它们将显示你如何管理你的数据库。创建登录屏幕只是设计表单的问题。您还应该阅读简单解释安全密码验证 [ ^ ]。

There are many SQL tutorials that you can find which will show you how to manage your database. Creating a login screen is just a matter of designing a form. You should also read Secure Password Authentication Explained Simply[^].

这篇关于用于创建登录和用户的SQL代码然后将其设计到我的数据库。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！