Login Page in C# using windows application

Question

Hello sir I am new to programming concepts.I have to know how to create a login page using windows application.I finished designing the login form.Can u help me

Vijay Yadav · Answer

Hi Suthish Thanks for your suggestion and i would definitely talk to my TL regarding this :)

Suthish Nair · Answer

If that be done your coding will be much appreciated and also the application performance. I know its difficult to do all the stuff again. I suggest to discuss with your TL/PM. Take time and rebuild your code. There is no shortcuts :)

Vijay Yadav · Answer

Hi Suthish I refer to article that you said in the earlier post aznd came to know about sql injection. But now my query is that my project is about to complete now is it possible to change the sql query and use parameter or there is some other alternative. Please Help.

Suthish Nair · Answer

If this query got resolved then please Accept the post that helped you as Answer. So other members can easily find the answers.

Suthish Nair · Answer

Vignesh refer article Simple Login Project in ASP.Net . The samples are in web application but you will get an idea how to access the DB and validate user credentials.. Vijay This not a good way of coding which leads to SQL Injections. Refer article: Parameterized Query and SQL Injection Attacks SQL Injection and Cross-Site Scripting

Vijay Yadav · Answer

Hi The example is shown below 1) First you have to open the connection sqlconnection con=new sqlconnection(); con.Open(); SqlCommand cmd = new SqlCommand( select * from tbl_Login where Username=' + txtUserName.Text + ' and Password=' + txtpassword.Text + '   con); SqlDatareader dr = cmd.ExecuteReader(); if (dr.HasRows) Messagebox.show(Success); else Messagebox.show(Fail); Regards Vijay

Vignesh Raja · Answer

hi i cant get u can u give some examples by using the login page in database

Vijay Yadav · Answer

Hi Now write the code on button click event. All you have to do is to fire the query to the database and check the credentials according to that and if the data exist you have show successful message or open some other form and if it is unsuccesful then show Invalid credentials in message box. Any query feel free to ask. Regards Vijay