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
