Solved

User Login form

Posted on 2004-09-14
8
188 Views
Last Modified: 2010-04-15
I have a problem wher eI'm trying to create a user login form that connects to a SQL server DB backend and validates the user name and password... the username field on the form is a text box rather than a combo box to ensure added security hopefully...

Does anyone have an idea of how to go about this?
0
Comment
Question by:reclusive
  • 4
  • 4
8 Comments
 
LVL 5

Expert Comment

by:tzxie2000
ID: 12058805
how about

put user name and password in the form

write code in OK Click event

if (isOKConnection(username,password))
....
else
MessageBox.Show("error username or password");

private bool isOKConnection(string username,string password)
{
     
try
{
    string myConnectString = "Persist Security Info=False;Integrated  Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30;username="+username+";password="+password;
    SqlConnection myConnection = new SqlConnection(myConnectString);
    myConnection.Open();
    myConnection.Close();
    return true;
 }
catch
{
}
return false;
}
0
 
LVL 1

Author Comment

by:reclusive
ID: 12059093
The code seems rather vague... do you think you could elaborate a bit more please?
0
 
LVL 1

Author Comment

by:reclusive
ID: 12059173
ERK! Maybe I was being ague in my explination lol...

I want to create a login form for my application to allow users to access it, not to access the database. The user inputs their username and password on the login form, and click the ok button. The form then opens a connection to the database and checks to see if the username and password match. If they do then allow access.. if not then deny access and +1 to a counter

Is that more explanitory? *grin*
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 5

Expert Comment

by:tzxie2000
ID: 12059263
put a odbcconnection and odbccommand on your form

design odbcconnection's connectionstring to your database
set odbccommand.connection to odbcconnection

write code in OK click even

odbcconnection.open
odbccommand.commandtext="select count(*) from userdb where username='"+username.text+"' and password='"+password.text+"'";//username and password is the textbox you provide to enter relate information
Int32 count = (int32) ExecuteScalar();
switch(count)
{
   case 0:
     MessageBox.Show("error username or password!") ;
     break;
   case 1:
     //check username and password is ok,doing what you want
     break;
  default:
     MessageBox.Show("error for multi username and password");
     break;
}
0
 
LVL 1

Author Comment

by:reclusive
ID: 12059348
if I change the ODBC to a SQL the principle will work the same right? Sorry for being really dumb about this, but I'm still learning C# *bluish*
0
 
LVL 5

Accepted Solution

by:
tzxie2000 earned 250 total points
ID: 12059384
yes
0
 
LVL 1

Author Comment

by:reclusive
ID: 12069025
Shot! You helped with 2 of me problems so far *grin* Out of curiosity how do you change the amount of points for an open question?
0
 
LVL 5

Expert Comment

by:tzxie2000
ID: 12070592
sorry I do not know about how to change the points.
Maybe you can get help from administrator
but could I ask a little question about why you give me Grad B and what answer could let you give Grad A?
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question