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 [2012/02/13 11:13] smayr [Resources] |
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 38: | Line 39: | ||
| * For VS2010: '' | * For VS2010: '' | ||
| * Add registry (perform with admin rights) using '' | * Add registry (perform with admin rights) using '' | ||
| + | |||
| ==== Install Assembly in GAC ==== | ==== Install Assembly in GAC ==== | ||
| * Verify that '' | * Verify that '' | ||
| Line 102: | 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 123: | Line 126: | ||
| * Server Type: Super/ | * Server Type: Super/ | ||
| {{: | {{: | ||
| + | |||
| === Data Source === | === Data Source === | ||
| * Add Data Source. | * Add Data Source. | ||
| Line 145: | 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 208: | 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 242: | 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 257: | 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 296: | Line 303: | ||
| ... | ... | ||
| < | < | ||
| + | < | ||
| + | connectionString=" | ||
| + | ServerType=0; | ||
| + | data source=localhost; | ||
| + | initial catalog=C: | ||
| + | user id=SYSDBA; | ||
| + | password=masterkey; | ||
| + | dialect=3" | ||
| + | providerName=" | ||
| < | < | ||
| - | connectionString=" | + | connectionString=" |
| - | providerName=" | + | |
| + | DataSource=localhost; | ||
| + | Database=C:\Program Files\Acme\MyApp\data\mydb.gdb; | ||
| + | User=SYSDBA; | ||
| + | Password=masterkey; | ||
| + | Dialect=3" | ||
| + | providerName=" | ||
| </ | </ | ||
| < | < | ||
| Line 314: | Line 336: | ||
| < | < | ||
| < | < | ||
| - | connectionString=" | + | connectionString=" |
| + | | ||
| + | Database=C:\Program Files\Acme\MyApp\data\mydb.gdb; | ||
| + | User=SYSDBA; | ||
| + | Password=masterkey; | ||
| + | Dialect=3" | ||
| providerName=" | providerName=" | ||
| </ | </ | ||