Table Joining

Question

Hi allIm a newbie here and Iam making a windows application in which i imported a datagridview .I want to join two tables by asigning a primary key.The problem here is that i need to calculate amount of whole transaction by multiplying two columns...and giving it to the last column...Hope you understood the problem for now.

Vijaya Kadiyala · Answer

Hi I agree to Bechir post that if you shift this logic to SQL query then it makes your life very easy. Also please make sure if you have N tables in your query then you need to have atleast N-1 joining conditions in WHERE cluase to avoid cartesian product. Thanks -- Vj http://dotnetvj.blogspot.com

Bechir Bejaoui · Answer

Ok the jointure at the SQL server level is possible but the jointure at the DataTables within the ADO.net is not possible nevertheless the jointure can be possible done manually via customized code using tools within the System.Xml and System.Xml.Xpath To prevent this headake I advise you achieve the entire job at the SQL server level or your database by using transactionsfuctions and stored procedures and then simply call them through code