public DataTable GetTableData(string challans)
{
DataTable dt = new DataTable();
tblBillDataTableAdapter adp = new tblBillDataTableAdapter();
dt = adp.GetTableData(challans);
return(dt);
}
public string GetTotal(string challans)
{
tblBillDataTableAdapter adp = new tblBillDataTableAdapter();
Double total = 0;
foreach (var x in adp.GetTableData(challans))
{
total = total + x.monTotalPrice;
}
return(total.ToString());
}