Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
swdev:dotnet:firebird_databases_in_.net [2016/02/23 13:52] smayr |
swdev:dotnet:firebird_databases_in_.net [2016/02/23 14:01] (current) smayr [Configuration File] |
||
---|---|---|---|
Line 26: | Line 26: | ||
=== DDEX: Support for Visual Studio === | === DDEX: Support for Visual Studio === | ||
+ | |||
==== Registry Update === | ==== Registry Update === | ||
* Add references in Registry: | * Add references in Registry: | ||
Line 103: | Line 104: | ||
</ | </ | ||
+ | |||
== Adding Firebird Support in an Application == | == Adding Firebird Support in an Application == | ||
* Open MS Visual Studio, and create or open a project: | * Open MS Visual Studio, and create or open a project: | ||
Line 124: | Line 126: | ||
* Server Type: Super/ | * Server Type: Super/ | ||
{{: | {{: | ||
+ | |||
=== Data Source === | === Data Source === | ||
* Add Data Source. | * Add Data Source. | ||
Line 146: | Line 149: | ||
* Review DataSource and DataSet: | * Review DataSource and DataSet: | ||
* {{: | * {{: | ||
+ | |||
=== Data-aware Controls === | === Data-aware Controls === | ||
* In the application form (GUI), add DataSet component, add DataGridView component and link to Data Source in current project. | * In the application form (GUI), add DataSet component, add DataGridView component and link to Data Source in current project. | ||
Line 209: | Line 213: | ||
* Test queries by selecting TableAdapter component in form, then right-clicking and " | * Test queries by selecting TableAdapter component in form, then right-clicking and " | ||
* If editing is necessary, select DataSet or TableAdapter component in form, then right-click and "Edit in DataSet Designer" | * If editing is necessary, select DataSet or TableAdapter component in form, then right-click and "Edit in DataSet Designer" | ||
- | * Rearrange tables for easy view. | + | * Rearrange tables for easy view. {{: |
- | | + | * Create queries using Query Builder. While in the DataSet Designer, right-click on a table, then Configure > Query Builder. Select necessary fields, then < Finish >. {{: |
- | * Create queries using Query Builder. While in the DataSet Designer, right-click on a table, then Configure > Query Builder. Select necessary fields, then < Finish >. | + | |
- | | + | |
* Fill DataGridView with table data. Add the following code to the main form: <code csharp> | * Fill DataGridView with table data. Add the following code to the main form: <code csharp> | ||
using System; | using System; | ||
Line 243: | Line 245: | ||
In '' | In '' | ||
< | < | ||
- | Source: {# | + | Source: {# |
- | StrongAssemblyName: | + | DestDir: {win}\assembly; |
+ | | ||
+ | | ||
</ | </ | ||
+ | |||
== Components with Data Binding == | == Components with Data Binding == | ||
+ | |||
=== DataGridView === | === DataGridView === | ||
* Add DataGridView component to a form. Set the following properties: | * Add DataGridView component to a form. Set the following properties: | ||
Line 258: | Line 264: | ||
* In TextBox component properties, go to Data > DataBindings > Advanced. | * In TextBox component properties, go to Data > DataBindings > Advanced. | ||
* Select Bindings > Other Data Sources > Project Data Sources, and pick one data source. | * Select Bindings > Other Data Sources > Project Data Sources, and pick one data source. | ||
- | {{: | + | {{: |
* Select a table under the data source. Eg: For table '' | * Select a table under the data source. Eg: For table '' | ||
- | {{: | + | {{: |
* Select a field under the table. Eg: For table '' | * Select a field under the table. Eg: For table '' | ||
- | {{: | + | {{: |
* The data binding string should look like '' | * The data binding string should look like '' | ||
- | {{: | + | {{: |
=== BindingNavigator === | === BindingNavigator === | ||
Line 298: | Line 304: | ||
< | < | ||
< | < | ||
- | connectionString=" | + | connectionString=" |
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
providerName=" | providerName=" | ||
< | < | ||
- | connectionString=" | + | connectionString=" |
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
providerName=" | providerName=" | ||
</ | </ | ||
Line 318: | Line 336: | ||
< | < | ||
< | < | ||
- | connectionString=" | + | connectionString=" |
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
providerName=" | providerName=" | ||
</ | </ |