Hi,
I would like to set relation (parent-child) between multiple tables, but,
unfortunately, I don't understand how to do it with FB provider. All the
textbooks I have show it with MS SQL server where batch query (multiple
queries separated by ; ) is supported. With FB, batch query is not
supp
Hello:
> I would like to set relation (parent-child) between multiple tables, but,
> unfortunately, I don't understand how to do it with FB provider. All the
> textbooks I have show it with MS SQL server where batch query (multiple
> queries separated by ; ) is supported. With FB, batch query is n
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)
12, 2007 1:28:08 PM
Subject: Re: [Firebird-net-provider] how to use relation
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
Hi,
>If I understood, you try to create a relation between some datatables,so
>fill the same dataset with table1 and table >2 (call fill for both) and
>then something like this :
I don't know how to fill the second table.
Without batch query support, we can't do like,
strSQL = "select custome
FbDataAdapter(wCmd2)
da2.Fill(wds)
- Original Message
From: Nobuya Higuchi <[EMAIL PROTECTED]>
To: For users and developers of the Firebird .NET providers
Sent: Thursday, September 13, 2007 12:39:33 AM
Subject: Re: [Firebird-net-provider] how to use relation
Hi,
>If I un
Hi,
> why not ?
You're right! It seems that I was missing an obvious way.
Thanks a lot.
Nobuya
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.co
Hello:
> strSQL = "select customerid from customers; select orderid, customerid from
> orders";
> FbDataAdapter da = new FbDataAdapter (strSQL, strConn); // strConn being
> connection string
> da.TableMappings.Add("Table", "Customers");
> da.TableMappings.Add(Table1", "Orders");
> da.Fill(ds);
>
>