Loading

Table Joining

Muzakkir

18y3.2k

Hi all,Im 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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala18y ago
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 Bejaoui18y ago
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 transactions,fuctions and stored procedures and then simply call them through code