i have a table named login in mysql database containing
(empid,fname,lname,mobno,emailid,usrname,usrpwd)
i have 2 textboxes in which i enter my username and pwd..so
based on what is entered in those textboxes it should
retreive all other details of dat username in the remaining
6 textboxes..i want the code for this...

Answer Posted / arush

SELECT empid,fname,lname,mobno,emailid FROM login where
usrname ='Textbox1.Text' and usrpwd ='Textbox2.Text';

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the keyword used to prevent a class from being inherited by another class?

891


Why c# is called type safe language?

632


Why we use get and set property in c#?

690


Why do we need events in c#?

711


What is a cshtml file?

701


What are the steps for creating clr trigger

775


Explain the process of Serialization?

733


What is difference between out and ref in c#?

705


Why do we use partial class in c#?

654


Explain the types of Polymorphism.

772


What is cshtml extension?

688


Is there hashmap in c#?

668


Which one is trusted and which one is untrusted?

680


Is enum a value type c#?

769


Why we use extension methods in c#?

639