This is what I have so far...
Sub dgrdSites_ItemCreated ( s as Object, e as dataGridItemEventArgs )
If e.Item.ItemType = ListItemType.Item or e.Item.ItemType = ListItemType.AlternatingItem Then
e.Item.Attributes.Add("onmouseover", "this.style.backgroundColor='#DCDCDC'"

e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor='#EAEAEA'"

'e.Item.Attributes.Add("onclick", "this.style.backgroundColor='#DCDCDC'"

End If
dgrdSites.SelectedIndex = e.Item.ItemIndex
End Sub
It works great thanks! However I have a couple of other questions before you get really bored of me!
I'm trying to figure out how to reset all of the other rows to standard backcolor when a row is clicked so that only one row appears as selected. I thought about something like...
dgrdSites.Items.Backcolor="#EAEAEA" but it won't work. Any better way?
Also with the mouseover thing which is pretty cool I'm trying to work out a way to do it so that it won't mouseover on the selected row since doing do resets the colour on mouseout. If there's an easy way to exclude the selected row form the mouseover code that would be great!
Thanks
Steve Gordon