how to display results in vb form

I am creating a form in Visual Basic Express 2008 and was hoping to get some advice from someone?

I would like to be able to display the results of my SQL query on the form, in the same way that data is displayed when you go into "modify table" in SQL server management studio. Basically, my query will return somewhere between 1 and 20 rows of data, and I would like to display the data on my form with a checkbox at the far right of each row

I've attached an image of how i would like to display my query results on the form, as my explanation is probably bad

Currently, i have about 10 text boxes in a single row and I am writing the information from the 10 columns i need into each of the text boxes. I realise that this is a crappy way to do it but it's the only way i know of right now. (and it limits me to only displaying one row)

Hope someone can help and thanks in advance





[image]local://8675/1CC00EA83DBF41848FC56193B532DE55.JPG[/image]

Attachment(s)

Attachments are not available: Download requirements not met

I would look for examples of the DataGrid control.