Thx for your help Scott,
only one pob
thats my Code
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.DataSource = "localhost";
cs.Database = "D:\\delphi\\shop\\TEST.fdb";
cs.UserID = "SYSDBA";
cs.Password = "masterkey";
cs.Charset = "NONE";
cs.Pooling = false;
DataSet ds = new DataSet();
FbDataAdapter da = new FbDataAdapter("SELECT * FROM Z_TEMP WHERE id >= @id",
cs.ToString());
da.SelectCommand.Parameters.Add("@id", 1);
da.Fill(ds);
dataGridView1.DataSource = ds;
But nothings happen in the DataGrid1, I think it's only a little mistake but
i don't find them, sorry.
----- Original Message -----
From: "Scott Price" <[EMAIL PROTECTED]>
To: <firebird-net-provider@lists.sourceforge.net>
Sent: Wednesday, January 25, 2006 12:10 PM
Subject: Re: [Firebird-net-provider] Examples for Firebird in VS 2005 (C++)
Hi Peter,
The DataAdapter exists in most connection tools. Its primary purpose is
to act as the go-between for something like a command and a dataset.
You create it literally to do translations between the commands and the
datasets you may wish to populate.
This is the recommended way to do it. :)
If you notice in the example, there is the line:
da.SelectCommand.Parameters.Add("@id", 1);
Well this is working with one of four pre-specified command properties on
the DataAdapter, Select, Insert, Update, Delete.
In this case you are working with the Select Command, and running a query
with a single parameter to limit the returned resultset. You then use the
DataAdapter to Fill a DataSet for use.
DataSets in .NET are very much disconnected, so that dataset is like a
copied reflection of the resultset you retrieved earlier. You can do lots
with that data in the dataset, but it will not be persisted until such
time as you choose to do the persistence work, so its working on a memory
copy of the data.
I hope that helps. :)
Regards,
Scott :)
Peter wrote:
Thx you help me a little bit. But your link is for FbTableAdapter not for
Command.
and "Command1. " have no "Fill" so I can't do
"fbCommand1.Fill(ds);"
Sorry for my noobie questions but I only want to use the best and free
Databse ;-)
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
