> refer 2nd example.
>
Please forgive the pseudo code, but how would I modify this code to
use a single transaction?
DataSetTableAdapters.LOCATIONSTableAdapter lota =
new DataSetTableAdapters.LOCATIONSTableAdapter();
DataSet.LOCATIONSDataTable lodt = lota.GetDataByRID(RID);
foreach (DataSet.LOCATIONRow n in lodt.Rows)
{
... Update ....
}
lota.Update(lodt);
lota.Dispose();
lodt.Dispose();
DataSetTableAdapters.LOCATION_RIDERSTableAdapter lrta =
new DataSetTableAdapters.LOCATION_RIDERSTableAdapter();
DataSet.LOCATION_RIDERSDataTable lrdt = lrta.GetDataByLocation(RID);
DataSet.LOCATION_RIDERSRow row;
foreach (DataSet.LOCATION_RIDERSRow n in lrdt.Rows)
{
... Update ....
}
lrta.Update(lrdt);
lrta.Dispose();
lrdt.Dispose();
TIA
Marv
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
