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

Question

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.

Ravi Patel · Answer

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

Ashiwani Sharma · Answer

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); } }

Vipul Malhotra · Answer

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: public void ButtonClick( string username) { //usernameisavailable if (CheckUserNameAvailability(username)) { } //usernameisnotavailable else { } } public bool CheckUserNameAvailability( string username) { //makeacalltothedbtogetthedataagainstthei/pusernamefromtheUSERtable //iftheo/pno.ofrowsis1,thenitstakendoreturnfalse //elsereturntrue return false ; } The comments explains the code. In case you need more depth into it. please let me know Hope it helped.

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

Answers (3)