Subject Re: [firebird-support] Select Statement -> Dataset
Author Jiri Cincura
On 6.6.2006 19:11 +0200 lec_sas wrote:
> Hello,
> I have a question about the results from select statements using
> the embeded server. The issue is getting the results from the select
> statement into a grid in the user interface. The interface is
> developed with .NET, and .NET is going to send a sql request to a
> database layer written in ansi C. The C layer uses the embeded server
> API to execute the statement. This is where the problem is; to get the
> data, you have to use the fetch statement which returns 1 record at a
> time, this doesnt seem like it could potentially be a good way to get
> the data to the grid.
>
> Does anyone have any suggestions about the best way to get the results
> of the query to the grid on the .NET interface?

What about use Firebird .NET Provider? It's for .NET FW 1.1 and 2.0 too. The
2.0 version supports all features from ADO.NET 2.0. So developing .NET apps
is very fast. ;)

--
Jiri Cincura
http://www.cincura.net/