[Firebird-net-provider] Update database from DataSet

2008-10-16 Thread Steve Harp
HI All, I have a class method that returns a DataSet to my application. I bind the DataSet to an DataGridView and would like to do the Add/Edit/Delete stuff from within the grid. How do I update the database from the DataSet? The only examples I've seen use a DataAdapter but all I have

[Firebird-net-provider] Assistance getting table created programmatically

2008-10-16 Thread vstdev
I haven’t used firebird in a long time. I can’t seem to get create a table on the fly I get a -1 every time. I create my table like this. FbConnectionStringBuilder cs = new FbConnectionStringBuilder (); cs.ServerType = 1; cs.Database = FBFile; FbConnection.CreateDatabase

Re: [Firebird-net-provider] performance-problem using .net-provider

2008-10-16 Thread Carlos
Hello: Testquery: SELECT * FROM RECORDED_FLOAT_VALUE WHERE FK_MEASUREMENT_RECORDING IN ([some id's like 91, 92, 93...]) If i run this query in ibexpert-consoleit needs 13,4s to give over 600.00 results. Are yoiu sure IBExpert is returning all the rows at the same time ?? -- Carlos

Re: [Firebird-net-provider] Update database from DataSet

2008-10-16 Thread Jiri Cincura
On Thu, Oct 16, 2008 at 3:33 PM, Steve Harp [EMAIL PROTECTED] wrote: I have a class method that returns a DataSet to my application. I bind the DataSet to an DataGridView and would like to do the Add/Edit/Delete stuff This is just done by any basic grid by default (when not disabled). Just

Re: [Firebird-net-provider] Assistance getting table created programmatically

2008-10-16 Thread Jiri Cincura
On Thu, Oct 16, 2008 at 4:01 PM, vstdev [EMAIL PROTECTED] wrote: The return code is -1 everytime. Anyone see anything glaring… Again please excuse me I am very rusty with this DB. And what it should return? It's a DDL command. -- Jiri {x2} Cincura (CTO x2develop.com)