login - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Author

Topic

Mpilo
Yak Posting Veteran

52 Posts

Posted - 2008-09-23 : 09:07:33

good day i am struggling to code my login page,i want to use two tables from the password and username tables to be combined into one
i am coding in c# and using Db SQL SERVER.
CAN SOMEONE assist me plz thanks

kathija khan(south africa)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-23 : 09:10:06

What are structure of tables? also what all columns you want to display?

Mpilo
Yak Posting Veteran

52 Posts

Posted - 2008-09-23 : 09:22:23

User table
{
Username varchar(30),
Password varchar(30),
Name varchar(30),
Surname varchar(30)

}
member table
{
MemberName varchar(30),
Surname varchar(30),
Id int=0 ;
MemberNo int=0;
}
the when the user login he use username and password and the member use Surname and Memberno.

quote:
Originally posted by visakh16

What are structure of tables? also what all columns you want to display?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-23 : 09:23:39

so what should be result you're looking for?

Mpilo
Yak Posting Veteran

52 Posts

Posted - 2008-09-23 : 09:24:43

i want to join them together

quote:
Originally posted by visakh16

so what should be result you're looking for?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-23 : 09:28:28

quote:
Originally posted by Mpilo

i want to join them together
quote:
Originally posted by visakh16

so what should be result you're looking for?

think this

SELECT *
FROM User u
INNER JOIN member m
ON m.MemberName=u.Name

replace * by actual column names

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-23 : 09:29:18

please dont cross post

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111178

Mpilo
Yak Posting Veteran

52 Posts

Posted - 2008-09-23 : 09:31:02

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources