Filling a Dataset ??

Hi,

i have some problems filling a dataset from a firebird sql embedded database...



After this lines of code the DataSet is still empty. The property "HasRows" is still false...

If i use an FbDataReader it works fine and i can read the whole Database. Wheres my fault ? How do i fill a DatSet ?

I don't recognise this programming language, no doubt other readers will. Superficially it looks like Java or maybe php. The trouble is there is an interfacing .dll between your code and the firebird database manager that converts your code to sql queries as well as other things, and you need to address your question to people who have familiarity with it.

In particular, following an SQL query, for each row Firebird returns a set of parameters corresponding to the fields requested, and it then repeats this operation for each row that the query returns. It is the task of the receiving code to assemble these into a table. (Actually this is standard for all databases). For example Delphi assembles these in a TDataset component, php assembles them into a hidden table which can be accessed by row reference. It looks like your language needs an instruction to load the data into a Table. As you can see each language handles the data differently, hence my advice to address this question to a forum about your language.

Good luck.
Geoff Marshall

Hi,

The programming language is C#.

Thanks for your advice, this confirmed my sucpicion. Ill try to find someone who is familiar with this language an the datset.