| 2. |
In a modern ADO.NET application, how do you change which rows a query retrieves based on a value that's only known once the page is actually running, like a visitor's search term?
Please select the best answer.
|
| |
A.
|
By changing the SqlCommand's properties in a design-time Properties window |
| |
B.
|
By editing the stored procedure's definition on the server each time a new value is needed |
| |
C.
|
By setting a parameter's value on the SqlCommand in C# code before the command executes |
| |
D.
|
By rewriting the connection string |