WinForms Grid - How to Edit the SQL Data Source Connection and Query at Runtime

This example demonstrates how to use the SqlDataSourceUIHelper class to give the End-User a capability to edit the SqlDataSource component's connection or queries at runtime via wizards.

Implementation Details

To execute a connection configuration wizard, call the SqlDataSourceUIHelper.ConfigureConnection method and pass the SqlDataSource component instance to it.

To execute a query editing wizard, call the SqlDataSourceUIHelper.EditQuery method and pass the SqlDataSource component's SqlQuery instance to it.

Note

Refill the SqlDataSource after its connection or query is edited. Use the SqlDataSource.Fill method for this purpose.

The SqlDataSourceUIHelper class also provides other wizards that can be used to configure the SqlDataSource component. Please refer to the SqlDataSourceUIHelper Members help topic for more information.

Files to Review

• Form1.cs (VB: Form1.vb)

Documentation

• Binding to SQL Data
• Specify Data Connection