Below is the code am trying to use
string sql = ("select item, sum(dr) from ledger where companyid = '"+ textbox1.text+"' GROUP BY item");