Q: read datatable column based on condition c# I have a datatable with some modified rows,  now i want to read the datatable with condition based on those modified rows. 
    row["Balance"] = dri["Balance"];
    dri.Close();
    DTRecord.AcceptChanges();
    row.SetModified();
}

//here i want to check that read where Balance is >0 

rd.SetDataSource(DTRecord);


A: you can get those records from Datatable in which Balance is > 0 by this code! 
DataRow[] dr = dtRecord.Select("Balance > 0");


A: @Ayaz Ulhaq, If we filter the datatable by 2 ways. 


*

*Datatable.Select(Expression) 
DataRow[] dr = dt.Select("Balance > 0");

*DataView filter
DataView dv = new DataView(dt);
// Filter by an expression. Filter all rows where Balance>0
dv.RowFilter = "Balance >0 ";

