Export Data from Database to Excel and send Excel File as email attachment in ASP.Net

Question

Sir I am following this Export data from SQL Server to Excel in ASPNet using C and VBNetit is very useful and working very fine  my question is this how to send this EXCEL FILE AUTOMATICALLY as this file is not being stored anywhere without downloading  Thank you

dharmendr · Accepted Answer

Hi  bhushan98Refer below linkExport GridView to Excel and send Excel File as email attachment in ASPNet

bhushan98 · Answer

Private Function GetData As DataTable    Dim constr As String    Dim connection As SqlConnection    constr  ConfigurationManagerConnectionStrings34Connectionstring34ToString    connection  New SqlConnectionconstr    Using con As SqlConnection  New SqlConnectionconstr        Using cmd As SqlCommand  New SqlCommand34SELECT  FROM customers34            Using sda As SqlDataAdapter  New SqlDataAdapter                cmdConnection  con                sdaSelectCommand  cmd                Using dt As DataTable  New DataTable                    sdaFilldt                    Return dt                End Using            End Using        End Using    End UsingEnd FunctionProtected Sub exportexcel 39    Dim dt As DataTable  GetData    dtTableName  34GridViewData34    Using wb As XLWorkbook  New XLWorkbook        wbWorksheetsAdddt        Using memoryStream As MemoryStream  New MemoryStream            wbSaveAsmemoryStream

Export Data from Database to Excel and send Excel File as email attachment in ASP.Net

Export data from SQL Server to Excel in ASP.Net using C# and VB.Net

Export GridView to Excel and send Excel File as email attachment in ASP.Net

Company

Explore

Follow us

Contact Us