I have Two Sql Table.
1st Table name is Allowence and Columns are EmpId,Name,Basic Salary,Da,Ca,HRA.
2nd Table name is Deduction and columns are EmpId, PF,ESI,Others.
I wants to display all these column to a DataGridView.
also I want to calculate Gross Salary and display this Gross Salary value to DataGridView.
I am using Visulal Studio 2010 and sql server 2008.
Please help to solve these problem.