Adding to dataadpater Help?!

[BlueOysterCult]

Hello everyone

I have a program that is a CD collection - the user can browse through "my CD collection" - with a next and previous button. The user can even sort through them via a (menu)filter by Type (pop/rock) etc. I would like to put an option for adding a cd or removing one. I am clueless of how to do this. Can anyone Help?

 

Here: is the code for one of the filters so you a have an idea of what I am doing

Private Sub mnuByArtist_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnuByArtist.Click
       Dim strArtist As String, strSQL As String
       strArtist = InputBox("Please enter a artist to search")
       strSQL = "select CdArtist,CdTitle, CdYear,CdKey,CdCategory from Cds where CdArtist like '%" & strArtist & "%'"
       OleDbSelectCommand1.CommandText = strSQL
       DbCdCollection1.Clear()
       OleDbDataAdapter1.Fill(DbCdCollection1)
       UpdateCounter()
   End Sub

 

Thanks

Rob