Loading

C# Language, if ( else if) condition check based on username

C# Language, if ( else if) condition check based on username

Geetha Rajendran

Geetha Rajendran

10y926Visual Basic .NET

how to check condition for username availability into my table (using c# if else)

After that,

based on username it will be show the record. otherwise (NULL means (username NA)) It will show "record not found"( Message box) like this ....

pls share any reference ...Thankyou Dudes.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Patel10y ago
Hi ,
refer the bellow link
http://www.aspdotnet-suresh.com/2011/12/how-to-create-simple-login-form-using.html
http://www.msdotnet.co.in/2013/04/how-to-make-registration-and-login-form.html#.V01ipvl97X4
http://www.aspsnippets.com/Articles/Simple-User-Login-Form-example-in-ASPNet.aspx
0
Ashiwani Sharma10y ago
Plz refer the Below Code for desired output :--
SqlDataReader dr;
SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM TABLE WHERE USER='1010093'", conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr[0].ToString() == "user")
{
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "onload", "alert(\"Record Not Found !\");", true);
}
}
0
Vipul Malhotra10y ago
It would be more meaningful if you could just make a different method for checking the availability of the user.
Please have a look at the code snippet below:
publicvoidButtonClick(stringusername)
{
//usernameisavailable
if(CheckUserNameAvailability(username))
{
}
//usernameisnotavailable
else
{
}
}
publicboolCheckUserNameAvailability(stringusername)
{
//makeacalltothedbtogetthedataagainstthei/pusernamefromtheUSERtable
//iftheo/pno.ofrowsis1,thenitstakendoreturnfalse
//elsereturntrue
returnfalse;
}
The comments explains the code.
In case you need more depth into it. please let me know
Hope it helped.
0