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

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Jan 2009
Posts: 3
Reputation: ben2008 is an unknown quantity at this point 
Solved Threads: 0
ben2008 ben2008 is offline Offline
Newbie Poster

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

 
0
  #1
Jan 8th, 2009
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
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 176
Reputation: Kusno is an unknown quantity at this point 
Solved Threads: 13
Kusno's Avatar
Kusno Kusno is offline Offline
Junior Poster

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

 
0
  #2
Jan 8th, 2009
Hi Ben,

Something like this ?
  1. SELECT DISTINCT Fullname, EmailId FROM Customer INNER JOIN User ON Customer.CustID = User.CustID

Thanks,
NEVER NEVER NEVER GIVE UP
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC