send excel data to mail c# code

Question

To create windows service get sql data to import excel sheet and send the data through outlook mail set a time?

Vishal Yelve · Answer

Hi Naveen, try this hope this will help int count = 0; string connectionstring ="Server=(local);initial catalog=Test;Trusted_Connection=True"; SqlConnection sqlConnection =new SqlConnection(connectionstring); SqlCommand cmd =new SqlCommand(); SqlDataReader reader; DataSet ds =new DataSet(); cmd.CommandText ="select * from Empdetails"; cmd.CommandText +=" where shifttype = @par "; cmd.Parameters.Add("@par", SqlDbType.Int).Value = j; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConnection; sqlConnection.Open(); reader = cmd.ExecuteReader(); string filePath =@"C:\Users\God\Desktop\DataDump\" + j + "Excel.xls"; System.IO.StreamWriter sw_In =new System.IO.StreamWriter(filePath); if (reader.HasRows) { while (reader.Read()) { if (count == 0) { for (int i = 0; i

Vishal Joshi · Answer

Hello Naveen, Please check the below article to create window service runs at a specific time. https://www.c-sharpcorner.com/article/create-window-service-in-net-core/ For importing data from excel to SQL server please refer below article. https://www.c-sharpcorner.com/article/import-excel-data-into-sql-table-using-sqlbulkcopy-in-c-sharp/ Thanks

Rajeesh Menoth · Answer

Hi Naveen, You can go through my article, If doubt please reach out to me. https://www.c-sharpcorner.com/UploadFile/2a6dc5/send-multiple-email-with-attachment-using-Asp-Net-with-C-Sharp/ Note: complete code I have given in my article attachment section.

Jignesh Kumar · Answer

Hi Naveen, Please refer this link which will help you, https://www.c-sharpcorner.com/UploadFile/4b0136/sending-email-with-an-attached-file/