Datasheet

Figure 8-19
Let's look at an example to see how this works.
Try It Out Using Parameters
1.
Create a new blank ASP.NET page called Parameters.aspx.
2. Add a Label and change the Text property to Category:.
3. Add a DropDownList next to the label, and change the ID property to lstCategory.
4. Add a Button next to the DropDownList and change the Text property to Fetch.
5. Add a DataGrid underneath the other controls. Your page should now look like Figure 8-20:
Figure 8-20
6. Double-click the Fetch button to switch to the Click event procedure. Add the following code:
Sub Button1_Click(sender As Object, e As EventArgs)
Command
Parameters
Parameter
Parameter
Parameter
278
Chapter 8
57076_Ch 8 SAN.qxd 01/12/2003 6:43 PM Page 278