Calculation before providing it to datagridview

Hey Santhosh Kumar, first of all data fetch from the database and then store a local data table like this type

DataTable dt= new DataTable("TableName"); //Table Name is optional
dt=queryFrom Database;
Check a proper your data successfully load in dt;

if(dt.Rows.count==0) // No data upload in your dt

get a data Row by Row

foreach(Row _row in dt.Row)
{
//you stuff here

}

after complete row again add row in your dt.

http://www.c-sharpcorner.com/UploadFile/deepak.sharma00/data-binding-in-wpf-datagrid-control-using-sql-server-databa/

Read the above article.