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] |
* Test queries by selecting TableAdapter component in form, then right-clicking and "Preview Data". | * Test queries by selecting TableAdapter component in form, then right-clicking and "Preview Data". |
* 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. {{:swdev:howto:firebird-dotnet-vs2008-dataset-designer.jpg|VS2008 DataSet Designer}} |
{{:swdev:howto:firebird-dotnet-vs2008-dataset-designer.jpg|VS2008 DataSet Designer}} | * Create queries using Query Builder. While in the DataSet Designer, right-click on a table, then Configure > Query Builder. Select necessary fields, then < Finish >. {{:swdev:howto:firebird-dotnet-vs2008-tableadapterconfigwzd.jpg|VS2008 TableAdapter Configuration Wizard}} {{:swdev:howto:firebird-dotnet-vs2008-querybuilder.jpg|VS2008 Query Builder}} |
* Create queries using Query Builder. While in the DataSet Designer, right-click on a table, then Configure > Query Builder. Select necessary fields, then < Finish >. | |
{{:swdev:howto:firebird-dotnet-vs2008-tableadapterconfigwzd.jpg|VS2008 TableAdapter Configuration Wizard}} {{:swdev:howto:firebird-dotnet-vs2008-querybuilder.jpg|VS2008 Query Builder}} | |
* 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; |
In ''[Files]]'' section, add global assembly cache (GAC) registration for ''FirebirdSql.Data.FirebirdClient.dll'' (one line, where {#LibDir} is where the source file is located): | In ''[Files]]'' section, add global assembly cache (GAC) registration for ''FirebirdSql.Data.FirebirdClient.dll'' (one line, where {#LibDir} is where the source file is located): |
<code> | <code> |
Source: {#LibDir}\FirebirdClient\FirebirdSql.Data.FirebirdClient.dll; DestDir: {win}\assembly; Flags: gacinstall sharedfile; | Source: {#LibDir}\FirebirdClient\FirebirdSql.Data.FirebirdClient.dll; |
StrongAssemblyName: "FirebirdSql.Data.FirebirdClient, Version=2.6.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, ProcessorArchitecture=MSIL" | DestDir: {win}\assembly; Flags: gacinstall sharedfile; |
| StrongAssemblyName: "FirebirdSql.Data.FirebirdClient, Version=2.6.0.0, Culture=neutral, |
| PublicKeyToken=3750abcc3150b00c, ProcessorArchitecture=MSIL" |
</code> | </code> |
| |
* 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. |
{{:swdev:howto:firebird-dotnet-vs2008-advancebinding-dialog1.jpg|Advanced Data Binding dialog}} | {{:swdev:howto:firebird-dotnet-vs2008-advancebinding-dialog1.jpg|Advanced Data Binding dialog}} |
* Select a table under the data source. Eg: For table ''PATIENT''... | * Select a table under the data source. Eg: For table ''PATIENT''... |
{{:swdev:howto:firebird-dotnet-vs2008-advancebinding-dialog2.jpg|Advanced Data Binding dialog}} | {{:swdev:howto:firebird-dotnet-vs2008-advancebinding-dialog2.jpg|Advanced Data Binding dialog}} |
* Select a field under the table. Eg: For table ''PATIENT'' and field ''LASTNAME''... | * Select a field under the table. Eg: For table ''PATIENT'' and field ''LASTNAME''... |
{{:swdev:howto:firebird-dotnet-vs2008-advancebinding-dialog3.jpg|Advanced Data Binding dialog}} | {{:swdev:howto:firebird-dotnet-vs2008-advancebinding-dialog3.jpg|Advanced Data Binding dialog}} |
* The data binding string should look like ''PATIENTBindingSource - LASTNAME''. The data binding dialog allows customization: | * The data binding string should look like ''PATIENTBindingSource - LASTNAME''. The data binding dialog allows customization: |
{{:swdev:howto:firebird-dotnet-vs2008-advancebinding-dialog4.jpg|Advanced Data Binding dialog}} | {{:swdev:howto:firebird-dotnet-vs2008-advancebinding-dialog4.jpg|Advanced Data Binding dialog}} |
| |
=== BindingNavigator === | === BindingNavigator === |
<connectionStrings> | <connectionStrings> |
<!--<add name="Acme.App.Database.Properties.Settings.MyAppDB_localhost" | <!--<add name="Acme.App.Database.Properties.Settings.MyAppDB_localhost" |
connectionString="character set=NONE;ServerType=0;data source=localhost;initial catalog=C:\Program Files\Acme\MyApp\data\mydb.gdb;user id=SYSDBA;password=masterkey;dialect=3" | connectionString="character set=NONE; |
| ServerType=0; |
| data source=localhost; |
| initial catalog=C:\Program Files\Acme\MyApp\data\mydb.gdb; |
| user id=SYSDBA; |
| password=masterkey; |
| dialect=3" |
providerName="FirebirdSql.Data.FirebirdClient" />--> | providerName="FirebirdSql.Data.FirebirdClient" />--> |
<add name="Acme.App.Database.Properties.Settings.MyAppDB_localhost" | <add name="Acme.App.Database.Properties.Settings.MyAppDB_localhost" |
connectionString="Charset=NONE;ServerType=0;DataSource=localhost;Database=C:\Program Files\Acme\MyApp\data\mydb.gdb;User=SYSDBA;Password=masterkey;Dialect=3" | connectionString="Charset=NONE; |
| ServerType=0; |
| DataSource=localhost; |
| Database=C:\Program Files\Acme\MyApp\data\mydb.gdb; |
| User=SYSDBA; |
| Password=masterkey; |
| Dialect=3" |
providerName="FirebirdSql.Data.FirebirdClient" /> | providerName="FirebirdSql.Data.FirebirdClient" /> |
</connectionStrings> | </connectionStrings> |
<connectionStrings> | <connectionStrings> |
<add name="Acme.App.Database.Properties.Settings.MyAppDB_localhost" | <add name="Acme.App.Database.Properties.Settings.MyAppDB_localhost" |
connectionString="Charset=NONE;ServerType=1;Database=C:\Program Files\Acme\MyApp\data\mydb.gdb;User=SYSDBA;Password=masterkey;Dialect=3" | connectionString="Charset=NONE; |
| ServerType=1; |
| Database=C:\Program Files\Acme\MyApp\data\mydb.gdb; |
| User=SYSDBA; |
| Password=masterkey; |
| Dialect=3" |
providerName="FirebirdSql.Data.FirebirdClient" /> | providerName="FirebirdSql.Data.FirebirdClient" /> |
</connectionStrings> | </connectionStrings> |