Working with SQL Parameters

C# offers you the capability to gain more control over the SQL you use in a data adapter by supporting SQL parameters, which are much like variables that you can use in SQL statements. You can assign values to these parameters at runtime without having to alter the SQL in a data adapter.


Before leaving the topic of data navigation, it's important to note that, unlike Windows forms, there is no BindingContext property in Web forms, which means that there is no Position subproperty to use. If you want to navigate through the records in a dataset in a Web form, you must do it yourself. One good trick is to use data views for this purpose. For example, this code shows how ...

Get Microsoft® Visual C#® .NET 2003 Kick Start now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.