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.
NAVIGATING THROUGH DATASETS IN WEB APPLICATIONS
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 ...