public JsonResult FetchMenuStyles() { List <DropdownClass> dropdownList = new List <DropdownClass>(); DataTable dt = new DataTable(); try { using (MsqlConnection mc = new MsqlConnection()) { using (SqlCommand cmd = new SqlCommand("GetMenuStyles", mc.msqlConnection)) { using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { mc.open(); cmd.CommandType = CommandType.StoredProcedure; sda.Fill(dt); mc.close(); } } } } catch (Exception ex) { } for (int i = 0; i < dt.Rows.Count; i++) { DropdownClass dropdownClass = new DropdownClass(); dropdownClass.Value = Convert.ToInt32(dt.Rows[i][0]); dropdownClass.Text = dt.Rows[i][1].ToString(); dropdownList.Add(dropdownClass); } return(Json(dropdownList, JsonRequestBehavior.AllowGet)); }
public JsonResult FetchDispItems(int length) { List <DropdownClass> dropdownList = new List <DropdownClass>(); for (int i = 1; i <= length; i++) { DropdownClass dropdownClass = new DropdownClass(); dropdownClass.Value = i; dropdownClass.Text = i.ToString(); dropdownList.Add(dropdownClass); } return(Json(dropdownList, JsonRequestBehavior.AllowGet)); }