private void selectFollowed() { selectedTable = DBAccessor.selectAllWhere("Follows Join Playlist on Follows.PlaylistAuthor = Playlist.Author" + " AND Follows.PlaylistDateCreated = Playlist.DateCreated", "Follows.Username", this.CurrentUser); dataGridView1.DataSource = new BindingSource(selectedTable, null); dataGridView1.Columns["PlaylistAuthor"].Visible = false; dataGridView1.Columns["PlaylistDateCreated"].Visible = false; }
private void UpdateTables() { DataTable dt = DBAccessor.selectAllWhere("PlaylistView", "[Playlist Name]", PlaylistName); CurrentTable = dt; this.CurrentPlaylistDataGrid.DataSource = new BindingSource(dt, null); dt = DBAccessor.selectAllTable("MediaView"); this.AllMediaDataGrid.DataSource = new BindingSource(dt, null); }
private void expandPlaylistToolStripMenuItem_Click_1(object sender, EventArgs e) { int index = GetSelectedRowNumber(); if (index == -1) { return; } selectedTable = DBAccessor.selectAllWhere("PlaylistView", "Author = '" + this.CurrentUser + "' and [Playlist Name]", (string)this.dataGridView1.Rows[index].Cells["Name"].Value); dataGridView1.DataSource = new BindingSource(selectedTable, null); dataGridView1.Columns["MediaFilepath"].Visible = false; }
public void SetPlaylist(string PlaylistName) { this.PlaylistName = PlaylistName; this.PlaylistNameBox.Text = PlaylistName; DataTable dt = DBAccessor.selectAllWhere("PlaylistView", "[Playlist Name]", PlaylistName); foreach (DataRow dr in dt.Rows) { if (((int)dr["PlaylistIndex"]) > this.PlaylistSize) { this.PlaylistSize = (int)dr["PlaylistIndex"]; } } UpdateTables(); }
public PlaylistEditor(string username, Boolean isCreation = false) { this.Username = username; InitializeComponent(); if (isCreation) { this.PlaylistName = Interaction.InputBox("Enter playlist name:", "Playlist Editor", ""); this.PlaylistNameBox.Text = this.PlaylistName; CreatePlaylist(); UpdateTables(); DataTable dt = DBAccessor.selectAllWhere("PlaylistView", "[Playlist Name]", PlaylistName); foreach (DataRow dr in dt.Rows) { if (((int)dr["PlaylistIndex"]) > this.PlaylistSize) { this.PlaylistSize = (int)dr["PlaylistIndex"]; } } } }
private void myReviewsToolStripMenuItem_Click(object sender, EventArgs e) { this.selectedTable = DBAccessor.selectAllWhere("Reviews", "Username", this.CurrentUser); dataGridView1.DataSource = new BindingSource(selectedTable, null); }