using System; using System.Collections.Generic; using System.Configuration; using System.Data.SqlClient; using System.Text; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } private int _lastid = 0; public int lastid { get { return _lastid; } private set { _lastid = value; } } public string URL; public string IMG; protected IEnumerable GetMedia() { List list = new List(); try { DatabaseAction.Execute(delegate(SqlConnection con) { // TOP nn * here means select up to nn entries from the returned row. string querystring = @"SELECT TOP 10 * FROM videos WHERE id > @LastId ORDER BY id DESC;"; SqlCommand db = new SqlCommand(querystring, con); db.Parameters.AddWithValue("@LastId", lastid); SqlDataReader reader = db.ExecuteReader(); while (reader.Read()) { StringBuilder sb = new StringBuilder(512); //not a pretty table URL = reader["path"].ToString(); IMG = reader["image"].ToString(); sb.Append(""); // sb.Append(""); sb.Append("

"); //
//sb.Append(""); list.Add(sb.ToString()); lastid = (int)reader["id"]; } }); } catch (Exception ex) { Response.Write(ex.Message); } return list; } // this is the video id code!!!!!! public string GetVideoId(string uri) { string link = (new Uri(uri)).Query; string id = ""; int length = link.IndexOf('&'); if (length == -1) { length = link.Length; id = link.Substring(link.IndexOf('=') + 1); } else { length = length - 3; id = link.Substring(link.IndexOf("=") + 1, length); } if (String.IsNullOrEmpty(id)) throw new Exception("

internal error parsing " + uri + "

"); return id; } protected string GetPrevPage() { return ""; } protected string GetNextPage() { return ""; } protected void SearchBox_TextChanged(object sender, EventArgs e) { } public string GetEmbedCode(string PlaylistUrl) { StringBuilder sb = new StringBuilder(512); sb.Append("

"); sb.Append("

"); return sb.ToString(); } }