Login System in c# with sql database

Question

0.00/5 (No votes)

See more:

i make a login sytem which is included 2 form 1st form have 2text box username and password and 2nd from have 2 labels .... its is connected with database which included 2 tables 1 for username and password and 2table have name and phone# and both table are in relationship with forgein key...........i want that user give his user name and password and its name and phone# see in another form in those label which are there ...................plz help me plz

Posted 24-Nov-12 0:47am

Arbaz Ali

Add a Solution

Comments

Rahul Rajat Singh 24-Nov-12 7:13am

Web forms or windows application?

Arbaz Ali 24-Nov-12 13:02pm

windows application

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Vishal.Shimpi144 · Answer 1 · 2012-11-24T01:04:00

when user is login and he is valid user then store there user_id in sesstion. then redirect to next page and on page_load of page 2 write the following code

C#

Protected void Page_Load()
{
   If(Session["YourSessionName"] != null && Session["YourSessionName"] != "")
   {
      int userID = Convert.ToInt32(Session["YourSessionName"]);
      If(!IsPostBack)
        {
           // fetch the data from database and set the Text property of your label here
        }
   }
}

EDIT: Code formatting added.

vishal jodh · Answer 2 · 2012-11-24T01:10:00

You need to pass Username and Password from 1Form to 2Form
Ex. In Form 1
Create object of 2Form and pass UserName and Password

C#

Form2 f = new Form(Username,Password);
     f.show();

In Form 2 create Constructor that have two parameter ie Username and Password

C#

string UserName="";
   string Password="";
   Public Form2(string UserName, string Password)
   {
        this.UseName = UserName;
        this.Password = Password;
        InitializeComponent();
   }

Also, In Form2 Load Event Run Following Query BUT MUST HAVE ONE UNIQUE CLOUMN IN BOTH TABLE

SQL

SELECT T1.USERNAME,T1.PASSWORD ,T2.NAME, T2.PHONE FROM TABLE1 T1 INNERJOIN TABLE2 T2 ON T1.ID = T2.ID WHERE T1.USERNAME="" AND T1.PASSWORD="";

Update above Query as per u r requirement

I hope this will be help for u

EDIT: code formatting added.

Login System in c# with sql database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0