using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace Newdelhibarassocia { public partial class Photo_Gallery : System.Web.UI.Page { Class1 obj = new Class1(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Repeater1Bind(); } } private void Repeater1Bind() { string qrajneeti = "select pkId,replace(CoverPhotoPath, '~/', '') as CoverPhotoPath,AlbumName,AlbumRank from newdelhibar_PhotoAlbumList order by AlbumRank Asc"; DataSet dsrajneeti = obj.ReturnDataSet(qrajneeti); if (dsrajneeti != null && dsrajneeti.Tables[0].Rows.Count > 0) { Repeater1.DataSource = dsrajneeti; Repeater1.DataBind(); } } } }