> 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider