Subject | Select Statement -> Dataset |
---|---|
Author | lec_sas |
Post date | 2006-06-06T17:11:27Z |
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?
Thank You
Darin Amos
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?
Thank You
Darin Amos