I have two tables:



exchange(exc_code,exc_desc) (Exchange code and exchange description)



exchange_rate(exr_code, exr_valu, exr_date) (Exchange code, excange rate value, exchange rate date)





I want to display on one grid the following information: (exr_code is a foreign key to exc_code)



exr_code,exc_desc,exr_valu,exr_date





What is the best way to achive this? I tried to read the forms and manages to create a new custom field on a BO but still it cannot be displayed in the grid.



Could you please give me a simple example?



Best Regards

How realistic would it be for you to use a "SELECT *" in a table with millions of records?



One of my projects have the need to import millions of records from CSV files and at some point I did reach a couple of SystemOutOfMemory exceptions you can look it up in the forums and had to changed my design not to fill a data table with that many records if is not really needed. I believe that is a limitation of .NET data tables, even though there are some settings you can make to the project to make the .EXE handle more available memory and it worked a bit in my case but I had to abandon my original design to show the data in a datagridview.



Of course you may have a legitimate reason to show all the data to the users, but if that can be avoided it will be best for you and the reliability of your application.

Edhy Rijo