Convet Data into CSV file in Asp.Net

 Source Code

<table class="style1">

        <tr>

            <td>

                &nbsp;

            </td>

        </tr>

        <tr>

            <td>

                <asp:GridView ID="GridView1" runat="server">

                </asp:GridView>

            </td>

        </tr>

        <tr>

            <td>

                <asp:Button ID="BtnCSV" runat="server" Text="CSV" OnClick="BtnCSV_Click" />

            </td>

        </tr>

        <tr>

            <td>

                &nbsp;

            </td>

        </tr>

    </table>

C# Code

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using System.IO;

public partial class FrmCSVfile : System.Web.UI.Page

{

    SqlConnection con;

    SqlDataAdapter da;

    DataTable dt;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (IsPostBack == false)

        {

            con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);

            da = new SqlDataAdapter("select * from demo", con);

            dt = new DataTable();

            da.Fill(dt);

            GridView1.DataSource = dt;

            GridView1.DataBind();

            ViewState["data"] = dt;

        }

    }

    protected void BtnCSV_Click(object sender, EventArgs e)

    {       

        CreateCSVFile(dt, @"C:\MasterBackup_satyajit\Satyajit Pradhan\xx.csv");

    }

    public void CreateCSVFile(DataTable dt, string strFilePath)

    {     

        dt = (DataTable)ViewState["data"]; 

        StreamWriter sw = new StreamWriter(strFilePath, false);

        int iColCount = dt.Columns.Count;

        for (int i = 0; i < iColCount; i++)

        {

            sw.Write(dt.Columns[i]);

            if (i < iColCount - 1)

            {

                sw.Write(",");

            }

        }

        sw.Write(sw.NewLine);

        foreach (DataRow dr in dt.Rows)

        {

            for (int i = 0; i < iColCount; i++)

            {

                if (!Convert.IsDBNull(dr[i]))

                {

                    sw.Write(dr[i].ToString());

                }

                if (i < iColCount - 1)

                {

                    sw.Write(",");

                }

            }

            sw.Write(sw.NewLine);

        }

        sw.Close();

    }

}

How to send Mail in Asp.Net

Source Code

<table style="border: 1px solid" align="center">

            <tr>

                <td colspan="2" align="center">

                    <b>Send Mail using mailing credentials in asp.net</b>

                </td>

            </tr>

            <tr>

                <td>

                    Gmail Username:

                </td>

                <td>

                    <asp:TextBox ID="txtUsername" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    Gmail Password:

                </td>

                <td>

                    <asp:TextBox ID="txtpwd" runat="server" TextMode="Password"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    Subject:

                </td>

                <td>

                    <asp:TextBox ID="txtSubject" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    To:

                </td>

                <td>

                    <asp:TextBox ID="txtTo" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    &nbsp;

                </td>

                <td>

                    <asp:FileUpload ID="FileUpload1" runat="server" />

                </td>

            </tr>

            <tr>

                <td valign="top">

                    Body:

                </td>

                <td>

                    <asp:TextBox ID="txtBody" runat="server" TextMode="MultiLine" Columns="30" Rows="10"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                </td>

                <td>

                    <asp:Button ID="btnSubmit" Text="Send" runat="server" OnClick="btnSubmit_Click" />

                </td>

            </tr>

        </table>

C# Code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Net.Mail;

public partial class Default8 : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

     

    }

    protected void btnSubmit_Click(object sender, EventArgs e)

    {

        try

        {

            MailMessage Msg = new MailMessage();

            // Sender e-mail address.

            Msg.From = new MailAddress(txtUsername.Text);

            // Recipient e-mail address.

            Msg.To.Add(txtTo.Text);

            Msg.Subject = txtSubject.Text;

            Msg.Body = txtBody.Text;

            if (FileUpload1.HasFile)

            {

                // File Upload path

                String FileName = FileUpload1.PostedFile.FileName; 

                //Getting Attachment file

                Msg.Attachments.Add(new Attachment(FileUpload1.PostedFile.InputStream, FileName));                            

            }

         

            SmtpClient smtp = new SmtpClient();

            smtp.Host = "smtp.gmail.com";

            smtp.Port = 587;

            smtp.Credentials = new System.Net.NetworkCredential(txtUsername.Text, txtpwd.Text);

            smtp.EnableSsl = true;

            smtp.Send(Msg);

            Msg = null;

            Page.RegisterStartupScript("UserMsg", "<script>alert('Mail sent thank you...');if(alert){ window.location='SendItem.aspx';}</script>");

        }

        catch (Exception ex)

        {

            Console.WriteLine("{0} Exception caught.", ex);

        }

    }

  

}