Data loading FROM the grid

Its my first time here. And I'm a new to programming and to VB.NET too so please don't mind if I say or ask stupid things :P

Okay here's my question. Let's say I have a table which contains student details. (Student Code, Name, DOB, Sex, Address, Contact No) and I have a grid which shows ONLY the student code and the name.

Now What I wanna do is when you double click on a cell, ALL the data related to that particular row should be loaded into a form with textboxes.

Please a little help with some example code would be really appreciated.


Thanks very much.
I.J

Well it depends in part on how your grid is populated but in general you would likely need to do a query on your database using a where clause so as to get the record that matches the selected student code.

There are lots of samples online for working with data is this way try a couple of google searches.