Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
swdev:dotnet:firebird_databases_in_.net [2016/02/23 13:58]
smayr [TextBox]
swdev:dotnet:firebird_databases_in_.net [2016/02/23 14:01] (current)
smayr [Configuration File]
Line 213: Line 213:
     * 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.{{:swdev:howto:firebird-dotnet-vs2008-dataset-designer.jpg|VS2008 DataSet Designer}}+    * Rearrange tables for easy view. {{: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>
Line 245: Line 245:
 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>
  
Line 302: Line 304:
 <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>
Line 322: Line 336:
 <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>