Newbie question... HELP

Question

Hi , may i know how can i check wether a user exist or not in the database. Like a registration page , i wanna check if the user nric is already in the database, and if it does not exist then it will store the new user data.

abdullah · Answer

Hi, simpy you have to search the databse for that name .... if it doesnt exist then add it to the database otherwise ................ Here take a look at this script ....... this script is to access a page that require a password (registration) So first I check wether the name & password matches if not or dont exist in the database prevent him from going forword...... void Login(string user, string pass) { OleDbConnection myConn = new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("login.mdb")); OleDbCommand myComm = new OleDbCommand("SELECT username, password FROM users WHERE username='" + user + "' AND password='" + pass + "'", myConn); myConn.Open(); OleDbDataReader myReader = myComm.ExecuteReader(); do { while (myReader.Read()) { if (user == myReader.GetString(1) && pass == myReader.GetString(2)) { messages.Text = "Your login was successful!"; } else { messages.Text = " Your login was unsuccessful!"; } } } while (myReader.NextResult()); myReader.Close(); myConn.Close(); }

Newbie question... HELP

Answers (1)