private void PopulateControls() { int userId = Convert.ToInt32(Session["UserID"]); int catTypeId = 0; if (Request.QueryString["term"] != null && Request.QueryString["term"] != "") { catTypeId = Convert.ToInt32(Request.QueryString["term"]); } ItemTableBLL bll = new ItemTableBLL(); DataTable dt = bll.GetItemNameListByCategoryId(userId, catTypeId); StringBuilder items = new StringBuilder(); items.Append("["); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { items.Append("{\"label\":" + "\"" + dr["ItemName"].ToString() + "\"},"); } items.Remove(items.ToString().LastIndexOf(','), 1); } items.Append("]"); Response.Write(items.ToString()); Response.End(); }
private void PopulateControls() { int userId = Convert.ToInt32(Session["UserID"]); int catTypeId = 0; if (Request.QueryString["term"] != null && Request.QueryString["term"] != "") { catTypeId = Convert.ToInt32(Request.QueryString["term"]); } ItemTableBLL bll = new ItemTableBLL(); DataTable dt = bll.GetItemNameListByCategoryId(userId, catTypeId); StringBuilder items = new StringBuilder(); items.Append("["); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { items.Append("{\"label\":" + "\"" + dr["ItemName"].ToString() + "\"},"); } items.Remove(items.ToString().LastIndexOf(','), 1); } items.Append("]"); Response.Write(items.ToString()); Response.End(); }