C# tutorial: Create Installer on VS 2017

first you must download the installer extension for vs 2017

here :

https://marketplace.visualstudio.com/items?itemName=VisualStudioProductTeam.MicrosoftVisualStudio2017InstallerProjects

its .vsix jusst double click and install, restart your VS2017

then follow this

Creating an MSI Package for C# Windows Application Using a Visual Studio Setup Project

C# tutorial: export large dataset 100k++ to excel using openxmlwriter

so yeah, i was somehow successful exporting excel usnig openxml sdk and closexml. (not sure). but when i was going to export some large database about 700k++ dataset, the memory just off the chart then it failed. so theres a solution to this by using opemxmlwriter by writing direcly to file rather than storing data in cache then export those data. credits to the author mikes heres the link.

http://mikesknowledgebase.com/pages/CSharp/ExportToExcel.htm

https://stackoverflow.com/questions/11811143/export-datatable-to-excel-with-open-xml-sdk-in-c-sharp#comment83441963_33474040

C# Tutorial : app config setting configuration and save dialog

so you know, theres a way to store your aplication configuration such as database connection, and any other setting for your app. you can use .ini or app.config. the thing is because UAC on windows, things may fail. so yeah. but try it anyways.

https://www.c-sharpcorner.com/article/four-ways-to-read-configuration-setting-in-c-sharp/

oh yeah and save dialog

https://stackoverflow.com/questions/5136254/saving-file-using-savefiledialog-in-c-sharp

https://stackoverflow.com/questions/180330/obtain-file-path-of-c-sharp-save-dialog-box

C# : and the database

Ok, jadi saya coba belajar lagi tentang C# dan database. Lumayan muter2 bagi saya apalagi mau nya cuman instant, satu tutorial mencakup dari ambil data dari database sampai export ke excel. Saya belum nemu tutorial yang cocok (karena keterbatasan ilmu pemrograman saya). sepp lanjut. saya bikin tutorial? belum ntar kapan2

1. Pelajari cara koneksi ke database lewat coding.
2. Pelajari ambil data dan CRUD. Titik berat di dataset atau datatable ya.
   https://www.completecsharptutorial.com/ado-net/dataset-tutorial-with-c-ado-net-programming-example.php
3. Export ke excel.

http://cstruter.com/blog/291

Creating Excel Files from DataSet using OpenXML 2.0 – C#

https://stackoverflow.com/questions/11811143/export-datatable-to-excel-with-open-xml-sdk-in-c-sharp

http://www.technetexperts.com/web/export-data-to-excel-using-openxml-sdk/

How to create an Excel file in .NET using OpenXML – Part 1: Basics

so theres another solution by using openxml library, we can use another library called CloseXML to ease our code.

https://www.codeproject.com/Tips/1107815/Export-an-Excel-File-using-ClosedXML

https://github.com/closedxml/closedxml/wiki/Adding-DataSet

ok lanjut

C# Tutorial : a link to the OpenXML (excel)

C# Visual Studio 2017. There are 2 ways (three or more way using library). to export or create excel files in C#.

1. using ms interops, needs office excel program to be installed on dev machine or even after deployment on client (end-user) pc.
2. using OpenXML, saves or create xlsx files.
3. third party library, whether free or paid.

like my any other posts there isnt any tutorial in it, just link to another page or site. why? i learn from it, you should too.

How to create an Excel file in .NET using OpenXML – Part 1: Basics

C# Tutorial : a useful link

so if you knew somethinig about C# but its been so long from the last time you wrote a  code and need a refreshment from basic but not that basic, heres a link to youtube channel … a lil bit slow but nonetheless a useful one. credit : @programmingknowledge