Check if user exists

[KothuriKavitha]

please give me for this "when user creates new account ,when he enter his username ,it must check with database and if user already exits with same name,must give message that user exits".

[debasisdas]

if the data is stored in database use COUNT to findout if the entry already exists.

[kunal pawar]

Right, count users with same using Executescalar function, and then prompt appropriate message

[malav123]

Hi,

You can fetch querry at the time of submit button click and compare the value of username textbox with the field of database, if it exists then prompt the user that "user name already exists"...

[Frinavale]

please give me for this "when user creates new account ,when he enter his username ,it must check with database and if user already exits with same name,must give message that user exits".

What have you tried so far?
Do you know how to Use a database in your Application?

-Frinny

[castron]

try this:

SqlCommand sqlCount = myConnection.Cr eateCommand();
sqlCount.Comman dText = "SELECT COUNT(*) FROM tablename WHERE UserName = '" + aUserName + "'";
int recCount = (int)sqlCount.E xecuteScalar();


if (recCount == 0) // no existing record for username
{
insert record
}
else
{
user already exist
}