GridView得到关键字及行索引的三种情况

1------------------------------'这个是用RowCommand来删除
Protected Sub GridView1_RowCommand(
        Dim i As Integer = Convert.ToInt16(e.CommandArgument)
        Dim id As String = GridView1.DataKeys(i).Value.ToString()
 sql = "Delete from oaswab where aid=" + id
EXESQL(sql)

Sub GridView1_RowDataBound(By
    If e.Row.RowType = DataControlRowType.DataRow Then
                  e.Row.Cells(17).Attributes.Add("onclick", "return confirm('确认删除吗?');")

2----------------------------'这个是用RowDeleting来删除
    Protected Sub GridView1_RowDeleting(...
         Dim sid As String
         sid = GridView1.DataKeys(e.RowIndex).Value().ToString
         DelEvents(sid)

3---------------------------GridView里的模板列与DropDownlist相连
DropDownlist的SelectedIndexChanged事件
Dim r As Integer = CType(CType(sender, DropDownList).NamingContainer, GridViewRow).RowIndex
        UpdateAlert(r)'这个r得到了所在的行号

UpdateAlert(r as integer)事件
        Dim id As String = GridView1.DataKeys(r).Value.ToString'得到关键字
        Dim ABT, ATYPE As DropDownList
        ABT = GridView1.Rows(r).FindControl("ABT")
        ATYPE = GridView1.Rows(r).FindControl("ATYPE")
        Dim Sql As String = "Update oas_calalerts set AlertBT=" + ABT.SelectedValue.Trim + ",AlertType='" + ATYPE.SelectedValue.Trim + "' where cid='" + id + "'"
        EXESQL(Sql)