How to find the corresponding values of the other fields if value of one field is given.

Question

I have 3 textboxes. If I enter any value in textbox1(mapped with field1 in table), then press Find button, following should be achieved: 1. corresponding values of other fields should be displayed in text boxes 2. If record does not exist for the value, then message should be prompted (error handling) Output should use dataset,dataadapter concepts.