Jun 22, 2017 02:54 PM|tandohtakyie|LINK
ID | username | password descId | userID | description
----------------------------- 1 | 2 | this is for the test description
1 | admin | admin 2 | 1 | this is for the admin description
2 | test | test
so i have created two different tables in my sql database (tblUsers and tblDescription) and of course every user has an id
but what i want to do is when a user logs in ,
it will check the id of the user who is logged in and display the description in an asp.net label.
i've been able to create the login with formauthentication in c# but i can't figure out how to get the description of the user?
i've done a couple research as i'm new to database and it works on my query in ms sql but i still couldn't get it right in my c#
can i get some help , thanks in advance.
c#, database, sql statement, asp.net