public List <object> LoadGallary(string CategoryID) { Cs_Gallary cs_Gallary = new Cs_Gallary(); DataTable dt = cs_Gallary.GetGalary(Convert.ToString(HttpContext.Current.Session["UserID"]), CategoryID); List <object> listGallary = new List <object>(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { listGallary.Add(new { GallaryID = Convert.ToString(dr["GallaryID"]), UserID = Convert.ToString(dr["UserID"]), Image = Cs_CommonFunction.RelativePath + "postWall/" + Convert.ToString(dr["Image"]), Caption = Convert.ToString(dr["Caption"]), Comment = Convert.ToString(dr["Comment"]), Description = Convert.ToString(dr["Description"]), CreatedDate = Convert.ToString(dr["CreatedDate"]) }); } } return(listGallary); }
private void BindImages(string CategoryID) { Cs_Gallary cs_Gallary = new Cs_Gallary(); DataTable dt = cs_Gallary.GetGalary(Convert.ToString(Session["UserID"]), CategoryID); for (int i = 0; i < dt.Rows.Count; i++) { ImageList = ImageList + " {image: '" + GetImageUrl(Convert.ToString(dt.Rows[i]["Image"])) + "', title: '" + Convert.ToString(dt.Rows[i]["Caption"]) + "', thumb: '" + GetImageUrl(Convert.ToString(dt.Rows[i]["Image"])) + "', url: '" + Convert.ToString(dt.Rows[i]["Description"]) + "' }"; if (i < dt.Rows.Count - 1) { ImageList = ImageList + ","; } } }