private string PopulateCounterUserwise(string userid)
{
report_Prop reportProp = new report_Prop();
reportProp.UserName = userid;
report_bal reportbal = new report_bal();
DataTable dt = reportbal.PopulateCounterUserwise(reportProp);
if (reportbal.ErrMessage != "" && reportbal.ErrMessage != null)
{
return("0#" + reportbal.ErrMessage + "$");
}
else
{
if (dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append(dt.Rows[i]["counterid"].ToString() + "#" + dt.Rows[i]["countername"].ToString() + "$");
}
return(sb.ToString());
}
else
{
return("0#No Data Found$");
}
}
}