datagridview selection and column span

 have a DataGridView populated by an SQL db.
What i need to do and can't, is to doubleclick a row, and retrieve a
value from a column in that row into a string or int.

I also need some help on making a column span on a DataGridView..

Could anyone help me on this

Thx

Pedro