The SQLDataSource

1. Drop an SQLDatasource on your webpage and configure like below…

Notice the Column: Operator: and Source: fields on the dialog box.  I’ve temporarily entered a value of “young”.  (We’ll be changing this value via code later)

2. Drop the GridView control on your form, set the datasource to the sqlDataSource and “enable editing”

3. To change the “Select” parameter programmatically, use the code below…

Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting

        e.Command.Parameters("@CandidateName").Value = "smith"

End Sub

Here’s how to filter the sqlDatasource…

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        SqlDataSource1.FilterExpression = "CandidateName like '%gay%'"

End Sub