Hi Carlos, >Couldn't you use TableAdapters ( and fill them with data ) or fill the >dataset table using the TableAdapter ??
Yes, I use DataAdapter to fill a DataSet (I do not use TableAdapter as a policy to avoid design-time GUI dependancy). But because I have to create a DbCommand (FbCommand) using only a single SQL statement (since batch query is not supported), the Fill method of the DataAdapter populates only a single DataTable in the DataSet with data. On the other hand, as I understand, we need to add a Relation to the DataSet to obtain parent-child relation between two tables. So my question is, how can I populate the second table in the same DataSet? Or can I set tables from different DataSets into a Relation, and adding it to one of the DataSets' Relation will work to get parent-child relationship? Maybe I'm missing something very basic but please enlighten me. I want to establish parent-child relationship in the detached data objects level, not in the original database level. Regards, Nobuya ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
