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$"); } } }