SqlDataSource component

Remember to install Firebird DbProviderFactory in machine.config first.

1. Select the sqlDataSource1 in the Designer.

2. Configure Data Source.

The wizard configuration doesn't work if you don't have installed Visual Studio SDK (so far).

3. "Failure has occurred while loading a type."

If this is your problem don't use the wizard and continue with the steps below. The other option is to install Visual Studio SDK.

5. First set the connection string.

We will load the connection string from the web.config file using Expressions binding. Click on "..." next to (Expressions) in the Properties Window.

6. Binding ConnectionString property

Select "ConnectionString" property and bind it to ConnectionStrings expression type. Select your connection string name from the drop down list (here "mydb").

7. Configure SelectCommand property

Select SelectCommand property in the Properties Window and click on "..." next to it. Type your SQL statement and use "@" as the starting character of the parameters. By clicking on "Refresh Parameters" button the parameters will be recognized automatically and preloaded to the Parameters list. Then you can configure the source of parameter. If none of the available choices is good you can set the parameter in the code: 

SqlDataSource1.SelectParameters["@id"].DefaultValue = "123";