Re: [Firebird-net-provider] Boolean type and DataTable

2006-05-03 Thread Alex Jankowski
Hi paha, I want to use the DataTable in a DataGridView which has a DataGridViewCheckBoxColumn. Therefore the column in the DataTable needs to contain boolean values. /Alex -Original message- From: paha [EMAIL PROTECTED] Date: Wed, 3 May 2006 13:45:10 +0200 To: firebird-net-provider@lis

[Firebird-net-provider] Boolean type and DataTable

2006-05-03 Thread Alex Jankowski
Hi, I have a DataTable with a column that contains boolean values. I have no problem saving this data to the firebird database. The problem arises when I want to retrieve the data again using the FbDataAdapter as these boolean values now are integers. How do I get this column as boolean values i

Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate1?

2006-04-11 Thread Alex Jankowski
Hi Carlos, > Using embedded server right ?? Yes, I'm using the embedded server. Is it possible, that it will work in the near future? /Alex --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applicati

[Firebird-net-provider] Support for Firebird 2 Release Candidate 1?

2006-04-11 Thread Alex Jankowski
rd ADO.NET Data Provider 2.0 Release Candidate 1? Best regards Alex Jankowski --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast an

Re: Re: Re: [Firebird-net-provider] Support for Firebird 2.0?

2006-03-17 Thread Alex Jankowski
I found the problem, the three dll's: icuin30.dll, icuuc30.dll and icudt30.dll are also needed to use the fbembed.dll. My mistake. /Alex --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications

Re: Re: [Firebird-net-provider] Support for Firebird 2.0?

2006-03-17 Thread Alex Jankowski
Hi Carlos, >It should work yet with Firebird 2.0. I'm using the embedded version of Firebird. I've tryed to replace the fbembed.dll with the new one from Firebird 2.0 Beta 2, but now get the following exception: Unable to load DLL 'fbembed': The specified module could not be found. (Exception fr

Re: Re: [Firebird-net-provider] Support for Firebird 2.0?

2006-03-17 Thread Alex Jankowski
Hi Carlos, >It should work yet with Firebird 2.0. Ok, I just though it didn't, because the FAQ says that only Firebird 1.0.x and 1.5.x are supported. (http://www.firebirdsql.com/index.php?op=devel&sub=netprovider&id=faq) /Alex --- This SF.Net

[Firebird-net-provider] Support for Firebird 2.0?

2006-03-17 Thread Alex Jankowski
Hi, Is the .NET Data Provider going to support Firebird 2.0 (currently the Beta 2)? If yes, when will this be available? Best regards Alex Jankowski --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that

RE: [SPAM MIAS=2,40%] Re: [Firebird-net-provider] Creating a Firebird table from a DataTable'sschema

2006-03-15 Thread Alex Jankowski
nt32 UInt64 Best regards Alex Jankowski --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking in

[Firebird-net-provider] Creating a Firebird table from a DataTable's schema

2006-03-15 Thread Alex Jankowski
Hi, Is there a simple way to generate a sql statement that creates a table on a Firebird database from DataTable's schema? The idea is that the DataTable object afterwards should be filled into the created table. Thanks in advance. Alex Jank

Re: [Firebird-net-provider] Filling a table with data

2006-03-13 Thread Alex Jankowski
Hi Carlos, >The whole code or the Update call only ?? What version of the provider >and the server are you using ?? The call to Update() takes 14 seconds. I'm using the .NET Provider 2.0 Beta 4 and the embedded version of Firebird 1.5.3. Ale

RE: Re: [Firebird-net-provider] Filling a table with data

2006-03-13 Thread Alex Jankowski
the IBPP library (25000 INSERTs takes only 5 seconds). I have added my code for the two approaches - am I doing something wrong? Alex Jankowski First approach: FbConnection connection = new FbConnection(connectionString); connection.Open(); FbDataAdapter dataAdapter = new FbDataAdapter("S

Re: [Firebird-net-provider] Filling a table with data

2006-03-13 Thread Alex Jankowski
seconds using INSERT statements in C++ with the IBPP library. I also tryed using FbCommand to execute 25.000 INSERT statement, but this also performed badly. Can the FbBatchExecution solve this problem, and what limitation does the ISQL script commands ha

[Firebird-net-provider] Filling a table with data

2006-03-13 Thread Alex Jankowski
Hi, What is the best and fastest way to fill data from a DataTable object into a table using the .NET provider? Thanks in advance. Alex Jankowski --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends