I am new to SharePoint and am wanting to query a SharePoint site and return data to a C# windows form. This is my scenario I have a text box where a user can input a ICDN number, then press a button. I want to then run a select statement against the SharePoint site and
Select firstname, lastname, address, city, state, zip from sharepointlist where ICDN = textbox1.Text;
And populate corresponding textboxes on the windows forms with the returned values like such
textboxfname = firstname; textboxlname = lastname; textboxcity = city; textboxstate = state; textboxzip = zip;
Of course this is rough pseudocode, but the question at hand is how to query a specific field name from your sharepoint site?