Get Full name of User logged-in using login Details in C# windows form Application

Question

I am new to stack and c#. Here I created a c# windows form application. I am using SQL server with login and student tables. I store login details(UN,PW) in login table and general details of student(fname,lname,etc..) in student table.

What I want to get is First name of the student using his login details. ex- UN:- ravi, PW:- 123, fname:- Ravindu

But in my system, ALL the registered students are not users of the system and all the users are registered students

Should I link tables or any structured way to do this.

score 1 · Accepted Answer · answered Feb 24 '15 at 19:34

1

You can use an outer or left join to represent everything in one table and only the matched items in the other.

select 
     * 
FROM 
     TABLEALL 
LEFT JOIN 
     TABLESOME 
ON 
     TABLEALL.ID = TABLESOME.ID

answered Feb 24 '15 at 19:34

Anthony Horne

2,522
2
29
51

Also look at http://stackoverflow.com/q/38549/1662973 for a very complete and comprehensive explanation of joins. – Anthony Horne Feb 24 '15 at 19:37

score 1 · Answer 2 · answered Feb 24 '15 at 19:39

Yes, you need to link both tables via a ID. When all users are registered students, they should have data in Student table. If you login as Ravi as stated in your example, this user should be present in Student Table. You can create a loginID as Primary key in login table. This should be linked to Student table via a Foreign key loginID in Student table and you should be able to achieve what you are looking for.

select st.fname from login lin left join on student st lin.loginID =st.loginID where lin.loginID='ID of student';

score 1 · Answer 3 · edited Feb 24 '15 at 20:05

Since you are working with student table, i assume that every student has unique index number, so you could add that unique Index column in student table and in Index column your login table, since all of your system users are students...

SELECT studentName FROM studentTable
WHERE Index IN
                (
                    SELECT Index FROM loginTable 
                    WHERE loginTable.userName = username 
                    AND loginTable.password = password
                )

Get Full name of User logged-in using login Details in C# windows form Application

3 Answers3