how can i create link in asp.net webforms please help

Accepted answer

Refer the link for creating the Download link in ASP.NET :

https://forums.asp.net/t/1992085.aspx?create+download+link+in+C+

For downloading the file in Server follow this link :

https://stackoverflow.com/questions/7725599/creating-download-link-to-a-file-on-a-file-server

For any further reference refer : http://www.c-sharpcorner.com/blogs/file-download-in-asp-net-with-c-sharp1

Hi Carnation Flowers,

Plaese follow this link -

1. http://www.c-sharpcorner.com/UploadFile/cd19b9/how-to-download-datatable-to-text-file-in-C-Sharp/

2. https://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-CSV-file-in-ASPNet-using-C-and-VBNet.aspx

3. https://stackoverflow.com/questions/1746701/export-datatable-to-excel-file

or

Private void CallFunction()

{

    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

    using (SqlConnection con = new SqlConnection(constr))

{

        using (SqlCommand cmd = new SqlCommand("SELECT * FROM Customers"))

{

            using (SqlDataAdapter sda = new SqlDataAdapter())

{

                cmd.Connection = con;

                sda.SelectCommand = cmd;

                using (DataTable dt = new DataTable())

{

                    sda.Fill(dt);

                    //Build the CSV file data as a Comma separated string.

                    string csv = string.Empty;

                    foreach (DataColumn column in dt.Columns)

{

                        //Add the Header row for CSV file.

                        csv += column.ColumnName + ',';

}

                    //Add new line.

                    csv += "\r\n";

                    foreach (DataRow row in dt.Rows)

{

                        foreach (DataColumn column in dt.Columns)

{

                            //Add the Data rows.

                            csv += row[column.ColumnName].ToString().Replace(",", ";") + ',';

}

                        //Add new line.

                        csv += "\r\n";

}

                    //Download the CSV file.

                    Response.Clear();

                    Response.Buffer = true;

                    Response.AddHeader("content-disposition", "attachment;filename=SqlExport.csv");

                    Response.Charset = "";

                    Response.ContentType = "application/text";

                    Response.Output.Write(csv);

                    Response.Flush();

                    Response.End();

}

}

}

}

}

in your button click just call this function.

http://www.c-sharpcorner.com/UploadFile/44fb93/download-file-from-gridview-using-Asp-Net/

Value or file name come from datarow in function in other part thankyou and any help apprcitaed

Please need help i still searching i tried many ways no one is working