How to add column in dataGridView with calculation?

Prakash Mondal

I load a dataGridview using DataTable.

suppose:

public void loadGrid()

{

con.open();
SqlDataAdapter da= new SqlDataAdapter ("SELECT * FROM COMMISION_TB",con);
DataTable dt = new DataTable();
da.Fill(dt);
con.close();
dataGridview.AutogeneratedColumn=false;

dataGridview1.DataSource=dt;

}// I wite this code in notepad

Like that...

Empno	Name	Dept	Basic Salary	Commision (%)	Status
E123	Priya	EC	32500	2	Paid
E124	Riya	EN	20800	3.5	Paid
E125	Jiya	GG	29500	1.5	Paid

I want to display the total paid amount (basic salary+(basic salary * commission) ) in this gridview as column, that is

Empno	Name	Dept	Basic Salary	Commision (%)	Total Amount	Status
E123	Priya	EC	32500	2	33150	Paid
E124	Riya	EN	20800	3.5	21528	Paid
E125	Jiya	GG	29500	1.5	29942.5	Paid

Please give me solution.

5 Replies

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

Kaushik Dhameliya8y ago
Accepted answer
Hello Prakash

Change your sql query like

SELECT *, basicsalary +(basicsalary * commission) as totalpaid FROM COMMISION_TB
+3
Prakash Mondal8y ago
Hi! Rafnas T P
Please describe second method that, add one more column and calculate values by taking datatable values and bind to that column.
0
Rafnas T P8y ago
hi,
you can solve this by two method,
one is as per @kaushik you can change your query add one more field by calculating
and second method is add one more column and calculate values by taking datatable values and bind to that column
0
Kaushik Dhameliya8y ago
Hi sai, not need to add more column in gridview, because he passed datatable result in datagridview
+1
Sai Sherlekar8y ago
Add one more column as per Kaushik from SQL stored procedure. And add one more column in Grid view and bind.
0