Send particular GridView Row as email body on Button click in ASP.Net

miki

SOLVED CLOSED ACTIVE ANSWERED
User: miki
Posted: on Feb 19, 2014 12:54 AM
Forum: Data Controls
Answer: 1
Views: 7646

I am new to ASP.NET and have made a register page, 'get' which on submitting redirects to another page 'pick1' displaying the data in Gridview. In each row of the Gridview there are 'View' buttons which on clicking opens a pop-up page having 2 buttons 'send mail' and 'cancel'. On clicking 'send Mail' button, i want selected row of data to be sent by email instead of the entire gridview. Right now only the entire gridview data is coming to my mail. Also i want to attach a link to the email so that it redirects to the 'pick1' page again on clicking in email. How can I do it?

Below is my code for 'pick1' page:

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.BindData();
            }
        }

        private void BindData()
        {
            string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString();
        SqlConnection con = new SqlConnection(strconn);
        
            SqlCommand cmd = new SqlCommand("select * from example2;", con);
            //string strQuery = ("select part,batch,quantity,user from example1",con);
            //SqlCommand cmd = new SqlCommand(strQuery);
            GridView1.DataSource = GetData(cmd);
            GridView1.DataBind();
            
        }

        private DataTable GetData(SqlCommand cmd)
        {
            string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ToString();
          

            DataTable dt = new DataTable();
            using (SqlConnection con = new SqlConnection(strconn))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    con.Open();
                    sda.SelectCommand = cmd;
                    sda.Fill(dt);
                    return dt;
                }
            }

        }

            
       protected void View(object sender, EventArgs e)
        {



            using (GridViewRow row = (GridViewRow)((LinkButton)sender).Parent.Parent)
            {

                txtpart.Text = row.Cells[0].Text;
                txtbatch.Text = row.Cells[1].Text;
                txtquantity.Text = row.Cells[2].Text;
                txtuser.Text = row.Cells[3].Text;

                popup.Show();
            }
        }

      protected void sendmail(object sender, EventArgs e)
       {
           

                   MailMessage Msg = new MailMessage();  //variable of type Mailmessage with the name Msg and the new keyword lets us create objects.
                   MailAddress fromMail = new MailAddress("example@hotmail.com");
                   // Sender e-mail address.
                   Msg.From = fromMail;
                   // Recipient e-mail address.
                   Msg.To.Add(new MailAddress("example@hotmail.com"));
                   String.Format("<a href=\"{0}\">click here</a>", HttpContext.Current.Request.Url);
                   // Subject of e-mail
                   Msg.Subject = "Send Gridivew in EMail";
                   Msg.Body += "Please check below data <br/><br/>";               
                   Msg.Body += GetGridviewData(GridView1);
                   Msg.Body += "Your message : <html><body><a href='http://localhost:53519/pick1'></a></body></html>";

                   Msg.IsBodyHtml = true;

                   SmtpClient client = new SmtpClient();
                   client.Port = 587;
                   client.Host = "smtp.live.com";
                   client.EnableSsl = true;

                   client.DeliveryMethod = SmtpDeliveryMethod.Network;
                   client.UseDefaultCredentials = false;
                   client.Credentials = new System.Net.NetworkCredential("example@hotmail.com", "xxxx");

                   client.Send(Msg);

                   ScriptManager.RegisterStartupScript(this, this.GetType(), "popup", "alert('Mail sent ..!!');", true);
               }
       
         //This Method is used to render gridview control

        public string GetGridviewData(GridView GridView1)
        {
            StringBuilder strBuilder = new StringBuilder();
            StringWriter strWriter = new StringWriter(strBuilder);
            HtmlTextWriter htw = new HtmlTextWriter(strWriter);
            GridView1.RenderControl(htw);
            return strBuilder.ToString();
        }
        public override void VerifyRenderingInServerForm(Control control)
        {
            /* Verifies that the control is rendered */
        }

        protected void cancelbutton_Click(object sender, EventArgs e)
        {
            ClearInputs(Page.Controls);
            //Rest of your code
        }

        void ClearInputs(ControlCollection ctrls)
        {
            foreach (Control ctrl in ctrls)
            {
                if (ctrl is TextBox)
                    ((TextBox)ctrl).Text = string.Empty;
                ClearInputs(ctrl.Controls);

            }

        }
        
    }


And the image of my 'pick1' and 'popup' page:

the pick1.aspx.cs page

pop up page appears after clicking 'view' button

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

Azim

0 3

Reply
ANSWER
User: Azim
Replied: on Feb 19, 2014 02:14 AM
Report

I have merge two article

http://aspsnippets.com/Articles/Display-GridView-Selected-Row-data-in-TextBox-outside-GridView-in-ASPNet.aspx

http://aspsnippets.com/Articles/Send-GridView-in-email-in-ASPNet-using-C-VBNet.aspx

I have downloaded the sample from first link then added a second GridView inside a Div tag which is set to display none. Now i am binding the Row details in Dummy table and that table is again bound to GridView2 after that SendEmail() function gets called to send GridView2 which contain single Row. In GridView2 use only BoundField.

HTML:

<form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
            runat="server" AutoGenerateColumns="false" OnSelectedIndexChanged="OnSelectedIndexChanged">
            <Columns>
                <asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" />
                <asp:TemplateField HeaderText="Name">
                    <ItemTemplate>
                        <asp:TextBox ID="txtName" Text='<%# Eval("Name") %>' runat="server"></asp:TextBox>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Country">
                    <ItemTemplate>
                        <asp:Label ID="lblCountry" Text='<%# Eval("Country") %>' runat="server" />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:LinkButton Text="Select" ID="lnkSelect" runat="server" CommandName="Select" />
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
        <br />
        <div style="display: none">
            <asp:GridView ID="GridView2" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
                runat="server" AutoGenerateColumns="false">
                <Columns>
                    <asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" />
                    <asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" />
                    <asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="150" />
                </Columns>
            </asp:GridView>
        </div>
    </div>
    </form>

protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
                        new DataColumn("Name", typeof(string)),
                        new DataColumn("Country",typeof(string)) });
            dt.Rows.Add(1, "John Hammond", "United States");
            dt.Rows.Add(2, "Mudassar Khan", "India");
            dt.Rows.Add(3, "Suzanne Mathews", "France");
            dt.Rows.Add(4, "Robert Schidner", "Russia");
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
    }

    protected void OnSelectedIndexChanged(object sender, EventArgs e)
    {
        GridViewRow row = GridView1.SelectedRow;
        int id = Convert.ToInt32(row.Cells[0].Text);
        string name = (row.FindControl("txtName") as TextBox).Text;
        string country = (row.FindControl("lblCountry") as Label).Text;
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)),
                        new DataColumn("Name", typeof(string)),
                        new DataColumn("Country",typeof(string)) });
        dt.Rows.Add(id, name, country);
        this.GridView2.DataSource = dt;
        this.GridView2.DataBind();
        this.SendEmail();

    }

    private void SendEmail()
    {
        using (StringWriter sw = new StringWriter())
        {
            using (HtmlTextWriter hw = new HtmlTextWriter(sw))
            {
                GridView2.RenderControl(hw);
                StringReader sr = new StringReader(sw.ToString());
                MailMessage mm = new MailMessage("sender@gmail.com", "receiver@gmail.com");
                mm.Subject = "GridView Email";
                mm.Body = "GridView:<hr />" + sw.ToString(); ;
                mm.IsBodyHtml = true;
                SmtpClient smtp = new SmtpClient();
                smtp.Host = "smtp.gmail.com";
                smtp.EnableSsl = true;
                System.Net.NetworkCredential NetworkCred = new System.Net.NetworkCredential();
                NetworkCred.UserName = "sender@gmail.com";
                NetworkCred.Password = "<password>";
                smtp.UseDefaultCredentials = true;
                smtp.Credentials = NetworkCred;
                smtp.Port = 587;
                smtp.Send(mm);
            }
        }
    }

    public override void VerifyRenderingInServerForm(Control control)
    {
        /* Verifies that the control is rendered */
    }

Namespace:

using System.Data;
using System.IO;
using System.Net.Mail;

Thank You.

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

Send particular GridView Row as email body on Button click in ASP.Net

Company

Explore

Follow us

Contact Us