鼠标从datagrid上划过时，背景色发生变化，点击任何一个单元格的时候选中一行

1. 在datagrid里创建4个BoundColumn和一个LinkButton。
 <asp:DataGrid id="DataGrid1" style="Z-INDEX: 110; LEFT: 16px; POSITION: absolute; TOP: 168px"
  Visible="True" runat="server" AutoGenerateColumns="False">
  <Columns>
   <asp:BoundColumn DataField="ID" HeaderText="ID"></asp:BoundColumn>
   <asp:BoundColumn DataField="NUM1" HeaderText="NUM1"></asp:BoundColumn>
   <asp:BoundColumn DataField="NUM2" HeaderText="NUM2"></asp:BoundColumn>
   <asp:BoundColumn DataField="NUM3" HeaderText="NUM3"></asp:BoundColumn>
   <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" HeaderText="Edit!" CancelText="Cancel"
    EditText="Edit"></asp:EditCommandColumn>
  </Columns>
 </asp:DataGrid> 
2.通过OracleDataAdapter的Fill函数获得数据，并自动关闭连接 
        Dim OraclDataSet As DataSet
        Dim OraclDataAd As OracleDataAdapter
        Dim OrclCnn As OracleConnection
        Try
            OrclCnn = New OracleConnection
            OrclCnn.ConnectionString = "Data Source=edc81;User Id=test;Password=test"
           
            OraclDataSet = New DataSet
            OraclDataAd = New OracleDataAdapter("select ID,NUM1,NUM2,NUM3 from test1", OrclCnn)
            OraclDataAd.Fill(OraclDataSet)
           
            DataGrid1.DataSource = OraclDataSet.Tables(0).DefaultView
            DataGrid1.DataBind()
        Catch ex As Exception
            Throw ex
        Finally
           
        End Try 
3. datagrid的Edit事件
    Private Sub DataGrid1_EditCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.EditCommand
        DataGrid1.EditItemIndex = e.Item.ItemIndex
        BindDataGrid()
    End Sub 
4. datagrid的Cancel事件
    Private Sub DataGrid1_CancelCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.CancelCommand
        DataGrid1.EditItemIndex = -1
        BindDataGrid()
    End Sub
5.  datagrid的Update事件 
    Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
        ''略
    End Sub
6.  鼠标从datagrid上划过时，背景色发生变化，点击任何一个单元格的时候选中一行
    Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
        If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then
            e.Item.Attributes.Add("onmouseover", "this.style.backgroundColor='Silver',this.style.cursor='hand'")
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor='white',this.style.cursor='hand'")
            'onclick事件绑定在linkbutton上
            e.Item.Attributes.Add("onclick", GetPostBackClientEvent(e.Item.Cells(4).Controls(0), ""))
        End If

    End Sub