public JsonResult BindEtrackingRights(string xmlData) { DataTable dt = new DataTable(); List <List <string> > listarray = new List <List <string> >(); eTrackingAccessLayer objprovinvoice = new eTrackingAccessLayer(); try { DataSet ds = objprovinvoice.eTrackingFiltersData(xmlData); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; } List <String> columnlist = (from dc in dt.Columns.Cast <DataColumn>() select dc.ColumnName).ToList(); listarray.Add(columnlist); foreach (DataRow dr in dt.Rows) { List <String> jst = dr.ItemArray.Select(o => o.ToString()).ToList(); listarray.Add(jst); } } catch (Exception ex) { } var jsonResult = Json(listarray); jsonResult.MaxJsonLength = int.MaxValue; return(jsonResult); }
public JsonResult etrackingFiltersData(string xmlData) { List <ControlData> lst = new List <ControlData>(); eTrackingAccessLayer objOrders = new eTrackingAccessLayer(); try { DataTable dt = objOrders.eTrackingFiltersData(xmlData).Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { ControlData p = new ControlData(); p.value = Convert.ToString(dr[0]); p.key = Convert.ToString(dr[1]); lst.Add(p); } } } catch (Exception ex) { } return(Json(lst)); }