Click here to Skip to main content
15,505,126 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
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.
Posted
Updated 30-Nov-17 10:50am
v2

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).
 
Share this answer
 
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[^].
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900