How can I send an email with autoGenerateEditButton set to True?

We would like an email sent out when an update is made.

How can I do this when autogenerateEditButton of gridview set to true?

Here is an example:

<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" 
    AutoGenerateColumns="False" DataKeyNames="ID" AllowPaging="True" 
    OnRowDataBound="gvRowDataBound" **onRowUpdated="btnSendEmail_Click"** AutoGenerateEditButton="True">
    <Columns>
 开发者_开发知识库       <asp:BoundField DataField="date_stamp" HeaderText="Entry Date" ReadOnly = "true"
            SortExpression="date_stamp" />
    </Columns>
</asp:GridView>

My email code is on codebehind called sub btnSendEmail_Click().

    Protected Sub btnSendEmail_Click(ByVal sender As Object, ByVal e As GridViewUpdatedEventArgs)
        Dim cnn As SqlConnection
        'Dim param As SqlParameter
        Dim cmd As SqlCommand

        Dim sqlStr As String = ""
        Dim sqlStrD As String = ""

        Dim connStr As String = ConfigurationManager.ConnectionStrings("Database_DBConnectionString").ConnectionString
more - not posted
more - not posted

Instead of having a 'Send Email' button and rely on the user to manually click it, why not create a hook to handle the Gridview's RowUpadated event?

  void GridView1_RowUpdated(Object sender, GridViewUpdatedEventArgs e)
  {

    // Indicate whether the update operation succeeded.
    if(e.Exception == null)
    {
      int index = GridView1.EditIndex;
      GridViewRow row = GridView1.Rows(index);
      //example to pull the data from a cell to send it to your function
      SendEmail(row.Cells(0).Text);

      Message.Text = "Row updated successfully. Email Sent!";
    }
    else
    {
      e.ExceptionHandled = true;
      Message.Text = "An error occurred while attempting to update the row. No email sent.";
    }

  }

VB code:

Private Sub GridView1_RowUpdated(sender As Object, e As GridViewUpdatedEventArgs)

    ' Indicate whether the update operation succeeded.
    If e.Exception Is Nothing Then
        Dim index As Integer = GridView1.EditIndex
        Dim row As GridViewRow = GridView1.Rows(index)
        'example to pull the data from a cell to send it to your function
        SendEmail(row.Cells(0).Text)

        Message.Text = "Row updated successfully. Email Sent!"
    Else
        e.ExceptionHandled = True
        Message.Text = "An error occurred while attempting to update the row. No email sent."
    End If

End Sub

EDIT to comment I used the parameter as an example to show you how to pull the value from the gridview if you wanted to pass it. Something like this:

SendEmail

Protected Sub SendEmail(ByVal RowNumber as Integer)
    Try
        Const ToAddress As String = "ThierEmail@domain.com"
        Const FromAddress As String = "YourEmail@domain.com"
        Dim Subject As String = "Row Updated"

        Dim mm As New MailMessage(FromAddress, ToAddress)
        mm.Subject = Subject
        mm.IsBodyHtml = False

        mm.Priority = MailPriority.High
        mm.Body =  String.Format("Row ID {0} was updated.",RowNumber)

        'Send the email
        Dim smtp As New SmtpClient()
          smtp.Send(mm)
    Catch ex As Exception
        'You should catch your error here
        Throw ex
    End Try
End Sub

You will need to have btnSendEmail_Click() handle the GridView's RowEditing event. In your ASP code, you should have:

<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
     OnRowEditing="btnSendEmail_Click"
     ...
     AutoGenerateEditButton="True">

Then in your codebehind:

Protected Sub btnSendEmail_Click(ByVal sender As Object, ByVal e As GridViewEditEventArgs)
    '...code to send email...