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

Advertisements

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

http://www.nitrix-reloaded.com/2010/09/26/creating-excel-files-from-dataset-using-openxml-20-c-sharp/

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/

http://www.dispatchertimer.com/tutorial/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.

http://www.dispatchertimer.com/tutorial/how-to-create-an-excel-file-in-net-using-openxml-part-1-basics/

OctoberCMS : Plugin

Language : Bahasa

plugin adalah plug itu colok, in itu masuk, jadi pulgin itu bunting.

cara buat plugin menggunakan plugin Builder. plugin ini dapat digunakan untuk membuat plugin, tanpa harus menggunakan coding, ya setidaknya memudahkan untuk membuat plugin.

cek rainlab builder plugin

  1. buka admin page nya octobercms
  2. masuk ke setting, terus system, update & plugin
  3. klik install plugin

lugin

udah?

  1. cari rainlab builder, biasanya udah mincul di sebelah kanan menu update & plugin, klo blum search aja
  2. install udah cepet
  3. selesai install bakalan muncul menu baru di tab atas sebelah setting, builder, tuh diatas ada liat lagi.

ada cicak?

terus gimana pake nya? gw jg ngak tau

langsung aj cek tutorial oppaicial dari petapa berikut di vimeo.

vimeo ga bs dibuka? diblokir sama “internet cepat buat apa”

pake psiphone aj lah rese.