Send email to user on GridView Button Click using C# and VB.net in ASP.Net

narendra...

SOLVED CLOSED ACTIVE ANSWERED
User: narendramalpute139
Posted: on Jan 28, 2021 10:41 PM
Forum: Data Controls
Answer: 1
Views: 5608
Sample Code: Download

If click on delete button the user send the mail to the customer your request be deleted

My website is car sharing if passenger are book ride then driver get passenger request there two options accept and rejected if click on accept button then passenger get mail request accept and if click on rejected button when passenger get mail request rejected

   <center> <asp:GridView ID="GridView1" AutoGenerateColumns="false" runat="server" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" ForeColor="Black" OnRowDeleting="GridView1_RowDeleting" >        
          <Columns>           
              <asp:TemplateField HeaderText="No.">
                  <ItemTemplate>
                      <%# Container.DataItemIndex + 1 %>
                  </ItemTemplate>
              </asp:TemplateField>
              <asp:BoundField DataField="id" HeaderText="id" />
              <asp:BoundField DataField="first_na" HeaderText="Driver Name" />          
              <asp:BoundField DataField="name" HeaderText="Passangher Name" />
              <asp:BoundField DataField="address1" HeaderText="Passanger Address" />
              <asp:BoundField DataField="pass_email" HeaderText="Passanger Email" />
              <asp:BoundField DataField="mobile" HeaderText="Passanger Mobile Number" />
              <asp:BoundField DataField="pick_u" HeaderText="Pick UP" />
              <asp:BoundField DataField="drop_off" HeaderText="Drop Off " />
              <asp:BoundField DataField="time" HeaderText="Time" />
              <asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
        </Columns>         
        <FooterStyle BackColor="#CCCCCC" />
        <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
        <RowStyle BackColor="White" />
        <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#F1F1F1" />
        <SortedAscendingHeaderStyle BackColor="#808080" />
        <SortedDescendingCellStyle BackColor="#CAC9C9" />
        <SortedDescendingHeaderStyle BackColor="#383838" />
     </asp:GridView></center>

namespace Online_Marketplace_For_Carpoolong
{
    public partial class find_book : System.Web.UI.Page
    {               
        string str = ConfigurationManager.ConnectionStrings["carpool_connection"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)
        {   
           using(SqlConnection con =new SqlConnection(str))
           {                
                con.Open();
                SqlDataAdapter SqlBD = new SqlDataAdapter("select * from bookride where first_na ='"+Session["first_name"]+"'",con);
                
                DataTable dt1 =new DataTable();
                SqlBD.Fill(dt1);
                GridView1.DataSource = dt1;
                GridView1.DataBind();
                con.Close();
           }
        }

        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            using (SqlConnection con = new SqlConnection(str))
            {
                con.Open();
                SqlDataAdapter SqlBD = new SqlDataAdapter("delete from bookride where pass_email ='" + Session["email_id"] + "'", con);

                DataTable dt1 = new DataTable();
                SqlBD.Fill(dt1);
                GridView1.DataSource = dt1;
                GridView1.DataBind();
                Response.Write("<script>alert(' Your Request Deleted.');</script>");
                con.Close();
            }
        }
    }
}

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Jan 29, 2021 03:51 AM
Report

Hi narendramalpu...,

Refer below code.

HTML

<asp:GridView ID="GridView1" AutoGenerateColumns="false" runat="server">
    <Columns>
        <asp:TemplateField HeaderText="No.">
            <ItemTemplate>
                <%# Container.DataItemIndex + 1 %>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="id" HeaderText="id" />
        <asp:BoundField DataField="first_na" HeaderText="Driver Name" />
        <asp:BoundField DataField="name" HeaderText="Passangher Name" />
        <asp:BoundField DataField="address1" HeaderText="Passanger Address" />
        <asp:BoundField DataField="pass_email" HeaderText="Passanger Email" />
        <asp:BoundField DataField="mobile" HeaderText="Passanger Mobile Number" />
        <asp:BoundField DataField="pick_u" HeaderText="Pick UP" />
        <asp:BoundField DataField="drop_off" HeaderText="Drop Off " />
        <asp:BoundField DataField="time" HeaderText="Time" />
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button Text="Accept" runat="server" OnClick="OnAcceptReject" />
                <asp:Button Text="Reject" runat="server" OnClick="OnAcceptReject" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

using System.Net;
using System.Net.Mail;

VB.Net

Imports System.Net
Imports System.Net.Mail

Code

protected void OnAcceptReject(object sender, EventArgs e)
{
    Button btn = sender as Button;
    GridViewRow row = btn.NamingContainer as GridViewRow;
    string message = "";
    if (btn.Text == "Accept")
    {
        message = "Your request Accepted.";
    }
    if (btn.Text == "Reject")
    {
        message = "Your request Rejected";
    }
    string name = row.Cells[3].Text.Trim();
    string toEmail = row.Cells[5].Text.Trim();
    using (MailMessage mm = new MailMessage("sender@gmail.com", toEmail))
    {
        mm.Subject = "Car sharing request";
        mm.Body = "Hi " + name + ",<br /><br />" + message;
        mm.IsBodyHtml = true;
        SmtpClient smtp = new SmtpClient();
        smtp.Host = "smtp.gmail.com";
        smtp.EnableSsl = true;
        NetworkCredential NetworkCred = new NetworkCredential("sender@gmail.com", "senderpassword");
        smtp.UseDefaultCredentials = true;
        smtp.Credentials = NetworkCred;
        smtp.Port = 587;
        smtp.Send(mm);
    }
}

VB.Net

Protected Sub OnAcceptReject(ByVal sender As Object, ByVal e As EventArgs)
    Dim btn As Button = TryCast(sender, Button)
    Dim row As GridViewRow = TryCast(btn.NamingContainer, GridViewRow)
    Dim message As String = ""
    If btn.Text = "Accept" Then
        message = "Your request Accepted."
    End If
    If btn.Text = "Reject" Then
        message = "Your request Rejected"
    End If
    Dim name As String = row.Cells(3).Text.Trim()
    Dim toEmail As String = row.Cells(5).Text.Trim()
    Using mm As MailMessage = New MailMessage("sender@gmail.com", toEmail)
        mm.Subject = "Car sharing request"
        mm.Body = "Hi " & name & ",<br /><br />" & message
        mm.IsBodyHtml = True
        Dim smtp As SmtpClient = New SmtpClient()
        smtp.Host = "smtp.gmail.com"
        smtp.EnableSsl = True
        Dim NetworkCred As NetworkCredential = New NetworkCredential("sender@gmail.com", "senderpassword")
        smtp.UseDefaultCredentials = True
        smtp.Credentials = NetworkCred
        smtp.Port = 587
        smtp.Send(mm)
    End Using
End Sub

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Send email to user on GridView Button Click using C# and VB.net in ASP.Net

Company

Explore

Follow us

Contact Us