In particular, Bound Fields turn into Text Box Web controls; Check Box Fields, which are displayed as unclickable checkboxes in the read-only status, become clickable.
Selecting event, you can perform any additional preprocessing required or cancel the database query entirely. Select(Data Source Select Arguments) method by accessing the Sql Data Source Selecting Event Args. The Sql Data Source Selecting Event Args class is used in the Sql Data Source View.To demonstrate this functionality, let's look at using a Grid View to list all of the records from the SELECT [Product ID], [Product Name], [Products].[Category ID], [Category Name], [Unit Price], [Discontinued] FROM [Products] INNER JOIN [Categories] ON [Products].[Category ID] = [Categories].[Category ID] ORDER BY [Product Name] can be specified through the data source's wizard, via the Select Query property in the Properties window, or declaratively.Previous installments in this article series have covered these steps in detail.The following table lists the events and associated Event Args classes and event handler delegates.Initializes a new instance of the Sql Data Source Selecting Event Args class, using the specified Db Command object and any Data Source Select Arguments passed to the Sql Data Source.