private void searchByGenre_Click(object sender, EventArgs e) { searchGenerics frm = new searchGenerics(4); frm.ShowDialog(); if (frm.searchVal != null) { dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS_BY_GENRE", "genre_id", SqlDbType.Int, frm.searchVal); } }
private void searchByLength_Click(object sender, EventArgs e) { searchGenerics frm = new searchGenerics(1); frm.ShowDialog(); string par = frm.searchPar; if (par == "GT") { dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS_BY_LENGTH_GT", "length", SqlDbType.Int, frm.searchVal); } if (par == "LT") { dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS_BY_LENGTH_LT", "length", SqlDbType.Int, frm.searchVal); } if (par == "EQ") { dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS_BY_LENGTH_EQ", "length", SqlDbType.Int, frm.searchVal); } }
private void removeSong_Click(object sender, EventArgs e) { searchGenerics frm = new searchGenerics(5); frm.ShowDialog(); }