| | |
how to retrieve fullname after login(asp.net/c#/sql)
Please support our ASP.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Jan 2009
Posts: 3
Reputation:
Solved Threads: 0
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
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
Hi Ben,
Something like this ?
Thanks,
Something like this ?
ASP.NET Syntax (Toggle Plain Text)
SELECT DISTINCT Fullname, EmailId FROM Customer INNER JOIN User ON Customer.CustID = User.CustID
Thanks,
NEVER NEVER NEVER GIVE UP
![]() |
Other Threads in the ASP.NET Forum
- Previous Thread: selecting from a table and listing various data from another one related to the first
- Next Thread: FTP upload
| Thread Tools | Search this Thread |
.net 2.0 3.5 activexcontrol advice ajax alltypeofvideos asp asp.net bc30451 bottomasp.net browser businesslogiclayer button c# c#gridviewcolumn checkbox class click commonfunctions compatible confirmationcodegeneration content contenttype control countryselector courier css database datagrid datagridview datagridviewcheckbox datalist deadlock deployment development dgv dropdownlist dropdownmenu dynamic edit embeddingactivexcontrol expose findcontrol flash flv formatdecimal forms formview gridview homeedition iframe iis javascript jquery list login menu microsoft mono mssql multistepregistration nameisnotdeclared numerical objects order panelmasterpagebuttoncontrols problem ratings rotatepage save schoolproject search security serializesmo.table silverlight smartcard sql sqlserver2005 ssl suse textbox tracking unauthorized validation vb.net video virtualdirectory vista visual-studio visualstudio vs2008 web webarchitecture webdevelopemnt webdevelopment webservice wizard xml youareanotmemberofthedebuggerusers





