public static void Main()
var table = new DataTable();
table.Columns.Add("sno",typeof(int));
table.Columns.Add("amount",typeof(int));
table.Rows.Add(new object[]{ 1,12});
table.Rows.Add(new object[]{ 1,-6});
table.Rows.Add(new object[]{ 2,10});
table.Rows.Add(new object[]{ 2,-5});
table.Rows.Add(new object[]{ 2,-5});
table.Rows.Add(new object[]{ 3,12});
table.Rows.Add(new object[]{ 3,-4});
table.Rows.Add(new object[]{ 3,-4});
table.Rows.Add(new object[]{ 3,-4});
var FinalDataTable = table.AsEnumerable()
.Where(g => g.Sum(r => (int)r["amount"]) != 0)
foreach(DataRow row in FinalDataTable.Rows)
Console.WriteLine($"{row["sno"]} = {row["amount"]}");
public int sno {get;set;}
public int amount {get;set;}