login screen validation

[uma]

Front end am using is vb.net and Back end is oracle.i have a login screen
with username and password and a submit button.Once i click the submit button it should verify with my database and if that user name and password entered is correct then it should go to the next form. otherwise if that username and password doesn't exixt then a message should be displayed as invalid username.

i need the vb.net code for this.Please help me.Waiting for ur reply

 

[jmcilhinney]

I've answered one of your other threads but this is all starting to sound suspiciously like homework to me. Otherwise, what is someone who doesn't know what a flat file is doing using Oracle?

 

[Amr_Maher]

ok someone here really need the help of that prob.

but my back end is sql server 2000 ....
i thought about making sql statment " SELECT PASSWORD FROM VALIDATION WHERE USERNAME = @ USERNAME" AND THROW THE RESULT IN STRING .. THEN COMPARE STRINGS ... THE RESULT AND WUT THE USER ENTERED .. IS THAT TRUE .. ANY OTHER IDEA ...

/* TABLE VALIDATION */
CREATE TABLE VALIDATION
(
ID int identity (1,1) primary key,
UserName nvarchar (50) NOTNULL and Unique, /* 2 constraints */
password nvarchar (50),
)
GO


I hope it's true ... don't care about the sql syntax i know it's not right ... as i added the constraint differently .. i'm just showing wut constraints are on the fields ...