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);
>
>
Hello:
> How I can get meta data by use FirebirdClient.
Have you checked the FbConnection.GetSchema method ??
--
Carlos Guzmán Álvarez
Vigo-Spain
Blog: http://carlosga.wordpress.com/
FirebirdClient : http://www.firebirdsql.org/
XMPP Client : http://code.google.com/p/xmppclien
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
why not ?
wds.Clear
wCmd1 = New FbCommand("SELECT * FROM .", wConn)
da1 = New FbDataAdapter(wCmd1)
wdsClear()
da1.Fill(wds)
wCmd2 = New FbCommand("SELECT * FROM ;", wConn)
da2 = New FbDataAdapter(wCmd2)
da2
Hi all,
How I can get meta data by use FirebirdClient.
Thanks.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Nobuya Higuchi
Sent: Thursday, September 13, 2007 04:40
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-pr
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
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 :
Dim wRel As New DataRelation("Relat_dp", _
ds.Tables(0).Columns("id"), ds.Tables(1).Columns
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)