how to retrieve fullname after login(asp.net/c#/sql)
 

Hi
I am using custom database to store data. I have two tables :Customer(CustID,Fname,Lname,Fullname) and
User(UserId,Emailid,Pwd,CustID(FK))
I want to retrieve the Fullname from Customer table based on logged user's Emailid.
How to collect the EmailId and pass to sql query.
Any help appreciated.
Thanks in advance
ben

Re: how to retrieve fullname after login(asp.net/c#/sql)
 

Hi Ben,

Something like this ?

SELECT DISTINCT Fullname, EmailId FROM Customer INNER JOIN User ON Customer.CustID = User.CustID

Thanks,