how to delete empty row

See more:

VB

hi, i got a probleam with my database, the probleam is i have 10 of empty row which doesnt not have any data, this is happen because i click to many insert button insert data. Please show me the coding should i use to delete my empty row. For you info i have table name is Bundle and 2 column which is name and type . Please give me example please.Is this my coding correct

connection.ConnectionString = " Data Source=Danawa;Initial Catalog=Store;Integrated Security=True"
Try

connection.Open()
cmd = New SqlCommand("DELETE FROM bundle WHERE type = is NUll'" & Me.txtsearchbundle.Text & "' ", connection)
ra = cmd.ExecuteNonQuery()
MsgBox("Category Are Deleted!!", MsgBoxStyle.Information, "Record Deleted = " & ra)

Catch ex As Exception
MsgBox("Record Failed to Delete")
End Try
connection.Close()

[Edit]Added "code" tag - losmac[/Edit]