Linking and querying a database

skinny90

I am using Visual Web Developer 2010 to develop a database driven website in C#.

I have linked the database to the website and when I use the SqlDataSource tool from the toolbox, I can view information from the database.

My question is:
How do I generate an SQL query using data gathered from a textbox?

For example:
In the customer table I have FirstName & LastName. I want to be able to query the database to display all customers by the name entered in the textbox (e.g. "John").

Is there a generic code which can be used to execute sql statements using variables?

Any help would be greatly appreciated.

stephenlane80

Do you have any experience with ASP.Net ? If your not able to create a parametrized sql query then your gonna find it difficult to create you application. Have a look at a simple tutorial here:
http://www.codeproject.com/Articles/361579/A-Beginners-Tutorial-for-Understanding-ADO-NET

If i were you i would avoid the drag and drop connections and data sets as you have no control of the code thats generated and you wont lean about how to code these things.