I am trying to preform the basic query and edit using an SQL database. I am new to development using C# an InfoPath. I am able to connect using a connection string and write to the database using a very simple, 'Insert' statement. The InfoPath forms fields are the fields from the web service database table. How do I write the basic 'select' statement based on one of the fields, (example:name), being the query field?
Thanks in advance for all your assistance.