Browsed by
Category: Tutorial

Trigger AutoNumber di SQL Server

Trigger AutoNumber di SQL Server

Berikut ini trigger buatan saya untuk membuat autonumber, mungkin belum sempurna 100%, tapi paling tidak sudah berjalan dalam 3 tahun terakhir === begin trigger === SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[ti_Quotation] ON [dbo].[Quotation] after insert AS declare @xcounter nvarchar(100), @tahun nvarchar(2), @bulan nvarchar(2), @nomor int; declare @curr_tahun nvarchar(2), @curr_bulan nvarchar(2); declare xcount cursor for select counter,substring(counter,4,2), substring(counter,6,2),CONVERT(INT,substring(counter,8,5)) from AutoGen where table_name = ‘Quotation’; declare curr_monthyear cursor for select replicate(‘0’,2-len(convert(varchar,MONTH(GETDATE()))))+convert(varchar,MONTH(GETDATE())) , substring(convert(varchar,YEAR(getdate())) ,3,2); open xcount; open…

Read More Read More

Saving bandwidth when downloading Visual Studio 2017

Saving bandwidth when downloading Visual Studio 2017

Today Microsoft release Visual Studio 2017, in the my previous post, you can download offline install of Visual Studio, but for some people, they just need Desktop development only, no need to download all component which is total around 18GB. To saving your bandwidth, download only what you need, use –add <workload_id> options,for example: I just want download Winform Development only, so use vs_community__18950355.1469052767.exe –layout d:\vs2017a –add Microsoft.VisualStudio.Workload.ManagedDesktop It’s only 1.4GB, faster than you download all component which is total…

Read More Read More

Tutorial menggunakan Syncfusion Dashboard part 1

Tutorial menggunakan Syncfusion Dashboard part 1

Pada tulisan ini saya mencoba berbagi aplikasi dari Syncfusion, yaitu Syncfusion Dashboard, sebuah aplikasi yang menampilkan dashboard secara interactive melaui browser, beberapa feature yang ada di Syncfusion Dashboard adalah Designer Dashboard yang mudah digunakan Mengatur atau memanage dashboard melalui web Dashboard server yang dapat di deploy pada Azure Web Application Menggunakan engine HTML5 Dapat digabungkan dengan aplikasi web kita Free jika menggunakan Community License Jika ingin mencoba, silahkan register atau request terlebih dahulu untuk Community License di https://www.syncfusion.com/downloads/communitylicense Instalasi Syncfusion…

Read More Read More

Cisco Packet Tracer 6.3 and 7 for Windows and Linux

Cisco Packet Tracer 6.3 and 7 for Windows and Linux

Cisco Packet Tracer The best way to learn about networking is to do it. Cisco Packet Tracer, an innovative network configuration simulation tool, helps you hone your networking configuration skills from your desktop or mobile device. Use Packet Tracer to: Sharpen your skills for a job interview Prepare for a certification exam Practice what you learn in networking courses Cisco Packet Tracer  7.0 (Windows and Linux, 32bit and 64 bit) and 6.3 (Windows and Linux) download link http://viid.me/qxs8H6   System…

Read More Read More

Step by step using Microsoft Synchronize SDK for multi client

Step by step using Microsoft Synchronize SDK for multi client

Prepare SQL Server Local Cache Start command prompt Check your localdb version, if you want deploy to 32 bit client, you should use version 12.xx (SQL server 2014 LocalDB) Type sqllocaldb v To check SqlLocalDB Instannce, use sqllocaldb i If you have 2 version, now check your MSSQLLocalDB server version If the version is not version 12.x, you have to create new instance and set version to 12 Now check again your synctestDB instance using correct version (12.0.2000.8) Now you’re…

Read More Read More

Monetize Blog for beginner

Monetize Blog for beginner

Here some WordPress plugin to monetize your blog for beginner: Using Shorte.st, WordPress plugin download here download the plugin and register Shorte.st Enable the plugin Once your blog connect to the Shorte.st, Your Public API token will appear, then set Links to ON Set Domain selection type to EXCLUDE and put your domain list in Domain list (comma separated), it means that plugin will exclude all your blog in to shortening, just external link shortened Capping means how many ads…

Read More Read More

How to use Instagram SDK for Windows Form

How to use Instagram SDK for Windows Form

This tutorial will guide you to develop an Instagram uploader for Windows Forms. Many 3rd party SDK support C# but not many support Windows Form Desktop, yes, almost C# SDK for Windows 8/10, Windows Phone application. I just found the SDK that suits for Windows Form Desktop, you can download from https://github.com/Codeusa/InstaSharp and compile and integrate with your application. Step 1 : Create New Project and add Reference Open your Visual Studio, create new Project, choose Windows Forms Application and…

Read More Read More

How to fix error 0x8001010E (RPC_E_WRONG_THREAD) when run Windows Phone project

How to fix error 0x8001010E (RPC_E_WRONG_THREAD) when run Windows Phone project

Did you get error Error 1 Retrieving the COM class factory for component with CLSID {2D0A16C9-53D9-42C1-BCC2-8D2A135E2163} failed due to the following error: 8001010e The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)) When try to debug or run Windows Phone Apps or you notice at the Run button there’s no Windows Phone 8 Emulator list, here is the solution: Go to C:\Users\<Username>AppData\Local\Microsoft\Phone Tools\CoreCon\ Delete all folder inside it Run Visual Studio as…

Read More Read More

Set PHP config on Azure + Docker

Set PHP config on Azure + Docker

I have bought Monstroid themes, so far this themes works great.. But there is a problem when I try to install child themes as below I have tried to find php.ini on my Azure and I can’t find it. I think there’s no php.ini since I’m using Docker in my Azure. Then I tried to find the solution on internet then found the solution is quite easy, just put php.ini setting under .htaccess with prefix php_value then the error gone,…

Read More Read More