DataTable dtRawTable = new DataTable();
DataTable dtFinalised=new DataTable();
dtFinalised.Columns.Add("Col1",typeof(int));
dtFinalised.Columns.Add("Col2",typeof(int));
dtFinalised.Columns.Add("Col3",typeof(int));
for (int index = 0; index <= dtRawTable.Rows.Count; index++)
{
DataRow dr = dtFinalised.NewRow();
if(index%2==0)
{
dr["Col1"] = (Convert.ToInt32(dtRawTable.Rows[index-1]["Col1"].ToString())-(Convert.ToInt32(dtRawTable.Rows[index]["Col1"].ToString())-Convert.ToInt32(dtRawTable.Rows[index-1]["Col2"].ToString())));
dr["Col2"] = (Convert.ToInt32(dtRawTable.Rows[index - 1]["Col2"].ToString()) - (Convert.ToInt32(dtRawTable.Rows[index]["Col1"].ToString()) - Convert.ToInt32(dtRawTable.Rows[index - 1]["Col2"].ToString())));
dr["Col3"] = (Convert.ToInt32(dtRawTable.Rows[index - 1]["Col3"].ToString()) - (Convert.ToInt32(dtRawTable.Rows[index]["Col1"].ToString()) - Convert.ToInt32(dtRawTable.Rows[index - 1]["Col2"].ToString())));
}
else
{
dr["Col1"] =Convert.ToInt32(dtRawTable.Rows[index]["Col1"].ToString());
dr["Col1"] = Convert.ToInt32(dtRawTable.Rows[index]["Col1"].ToString());
dr["Col1"] = Convert.ToInt32(dtRawTable.Rows[index]["Col1"].ToString());
}
dtFinalised.Rows.Add(dr);
dtFinalised.AcceptChanges();
}
Please mark it a s Answer if it is useful to u