> Subject: [Firebird-net-provider] slow connection > I have the relationships set between the tables and the > controls display the > correct information, however VERY slowly. The form takes > several minutes to > open and is several seconds to change customers. > > I do a TableAdapter.Fill for each of the tables on the onLoad > event of the > form. This seems to load ALL of the rows of each table >
Hi, According to my knowledge that is exactly the way how Datasets work :-( > > > I want to return only the relevant rows for the customer in orders and > orderitems, but I think I am getting them all. How do I set this up > correctly? First of all - in some cases it is not good idea to use DataAdapter and Datasets at all. In my "dataset-applications" I usually modify the SelectCommand.CommanText with appropriate WHERE clause. If anyone knows better solution, please post it here ;-) Regards Marek Leitl ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
