Hi, u can use the following code....
Protected Sub ImgbtnSave_Click(ByVal sender As Object, ByVal e As EventArgs) Handles ImgbtnSave.Click
Conn.Open()
StrQry = ""
For i As Integer = 0 To GridView1.Rows.Count - 1
StrQry = "update mppProfRoleMapping set DesignCode='" & CType(GridView1.Rows(i).FindControl("Sno"), Label).Text & "' where ProfRoleCode ='" & CType(GridView1.Rows(i).FindControl("ddlProfRole"), DropDownList).SelectedValue & "'"
Next
Cmd.Connection = Conn
Cmd.CommandText = StrQry
Cmd.ExecuteNonQuery()
Cmd.Dispose()
Conn.Close()
End Sub