I am still learning C# and would like to know what the most efficient means is to bind data from a database into this simple application I have written. I'm still very confused by DataGrids, Data tables, Data Sets, Adapters, etc. I think there's something basic I am not getting.
The application is as follows:
The user enters some parameters X, Y, Z about themselves, and then the application goes to the datbase and finds X, Y, Z (all keys in the table) and returns A, B. There is only ONE resulting row containing A and B, never more than one row. I need to display A and B on the page in a Label field, so how do I get this result and display it?
What should I use? Seems like overkill to use a Data grid or data table for just one resulting record.
Once I get the result set back, can I bind it to a label field? or does it have to be bound to a repeater (also overkill for this application).
I got as far as the DataAdapter, but I'm not sure what to do from there. Help!