I have a database as shown below.(database created using SQL Server 2005)
name : george,simon
address : bangalore,hyderabad
now I want the following thing to be done. I have a form with two text boxes. if I type something in one textbox, the corresponding value to that typed value from database has to be displayed in another text box.
for example, if I type "george" in one text box, "bangalore" has to be displayed in another textbox. How can I achieve it?