private string getIssues(Int64 number, Int16 mode, Int64 mpId) { DataTable dt = new DataTable(); dt = (DataTable)issuesbal.getIssues(mpId, 50, 0, 0); if (dt.Rows.Count != 0) { JavaScriptSerializer js = new JavaScriptSerializer(); List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >(); Dictionary <string, object> row = null; foreach (DataRow dr in dt.Rows) { DataTable idt = (DataTable)issuesbal.getIssue(Convert.ToInt64(dr[0])); if (idt.Rows.Count != 0) { row = new Dictionary <string, object>(); foreach (DataColumn col in idt.Columns) { row.Add(col.ColumnName.Trim(), idt.Rows[0][col]); } rows.Add(row); } } return(js.Serialize(rows)); } return("[]"); }
private void loadlist() { ListIssues.DataSource = (DataTable)issuesbal.getIssues(mpidval, no_of_issues, filterType, SortBy); /* type 0,1,2 */ ListIssues.DataBind(); }