Using Data Repeater, using SQL statements VB2010

See more:

VB

Hi All,

I have used a data repeater and linked it with the data source. The program lists all the names of clients from the database with an ID number and also a URL.

My first question is how can i make the url that is displayed as a link label, link to the default browser when clicked. I normally use the Shell(c:/program files/internet explorer/iexplore.exe "URL HERE") command but i'm not sure how to make this work with the data repeater?

My second question is to do with starting services, i need to take the ID number from the current data repeater record and then place it within a service name, for example if the service was callled Client_** the two ** represent the client ID. This then needs to start the service when button is clicked on the current record on the data repeater.

My third and final question is how to query a field in a current record of a data repeater, for example if i wanted to query a field called ID for that current record shown, is there a function i need to use to call the information?

Thanks for any pointers, i'm a VB 6 man and have never used the data repeater before.

Thanks, Paul.