using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Runtime.Remoting.Contexts;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;

namespace Newdelhibarassocia
{
    public partial class Video : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bindvideo();
            }
        }

        private void bindvideo()
        {
            DataTable dt = new DataTable();
            SqlDataAdapter da = new SqlDataAdapter("select * from [newdelhibar_VideoAlbumList] order by cast(AlbumRank as int)", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "products");
            dt = ds.Tables["products"];
            rpter.DataSource = ds.Tables["products"];
            rpter.DataBind();

        }

    }
}