Data...

Ok, so I'm copying information from an external SQL database to my VB.net program. Now I'm a bit confused with the ways I can import it... I've been reading about Datasets and Result Sets and from what I can see the Result Set is the easiest way of doing it.

Before I started I thought I should ask if anybody had any suggestions. I don't want to start doing it all and then find out I'm doing it wrong!!

Thanks again,

Alex

The brief for this project changes as regularly as the weather! Grr, anyway... First question is still valid... Now I still need to display a list of destinations for the drivers... This info will be stored in a database so I'll just pull that off. The thing is, the driver needs to be able to select the destination (click the destination like a button) for it to pull up another form/panel with a load of other information. Does anybody have any idea on how I can go about this, as I presume a datagrid won't allow "links" in it right? Can I populate the datagrid with link buttons maybe?

Thanks again!

Ok, another update... Datagrids it seems have an onclick event. So in theory I can capture this event, see what row's been clicked and pass that information to the next form.