data manipulation

[rangerbud249]

I would like to make a simple query.

I have a dropdownlist and two text boxes. How can I query my sql server db using those 3 variables as the (where) criteria so that I can display the (select) part of it in a datagrid.

Therefore I need to connect to my db.
make the Select From Where Statement
and then Bind all that info to a datagrid.

Any help and code examples will be so very much appreciated.
Or If you can let me know what book offers how to do form (data manipulation) using a sql server for your connections. Problem with the books I have is that they offer these things just in different chapters and not as a whole project.


Jose

[jhermiz]

Originally posted by rangerbud249
I would like to make a simple query.

I have a dropdownlist and two text boxes. How can I query my sql server db using those 3 variables as the (where) criteria so that I can display the (select) part of it in a datagrid.

Therefore I need to connect to my db.
make the Select From Where Statement
and then Bind all that info to a datagrid.

Any help and code examples will be so very much appreciated.
Or If you can let me know what book offers how to do form (data manipulation) using a sql server for your connections. Problem with the books I have is that they offer these things just in different chapters and not as a whole project.


Jose

SELECT blah1, blah2 WHERE Country='USA' AND Weight>160 AND Date IS Null

look up sqldataadapters, connections, and readers www.asp.net
the tutorial has VERY simple examples