There are a good number of different grape varieties that will grow in sheltered situations even in the north. Some you may not have heard of and some possibly you have....
Dessert grapes - no problem - are you looking for white or red grapes?
Seeded or seedless?
Some recommendations from me (not an exhaustive list by any means)
Seeded white - Phoenix (wine and dessert, dual purpose) Seneca, Siegerrebe (early, small grapes but delicious) Madeleine Angevine (dual puropse)
Seeded red - Alden, Boskoop Glory, Gagarin Blue, Regent and Rondo (both dual purpose)
Seedless white - Interlaken, Lakemont, Somerset seedless (pink grape recommended for the north.
Seedless red - Beauty, Mars (often said good for north) Vanessa.
Plenty there to be going on with. :)