Hi, as per my knowledge, don't take Balance Column in database, instead u have to calculate Balance when u r binding to DataGridView. i have sample code in php u can use same thing in vb.net
if($row['credit']!=0){
$balance = $balance + $row['credit'];
}
else if($row['debit']!=0){
$balance = $balance - $row['debit'];
}