Chandra Oemaryadi has written 244 articles

Kendo DatePicker Hide Year

Hide header year pada kendo datepicker [code language=”javascript”] var startPicker; startPicker.bind(‘open’, function (e) { var dp = e.sender; var calendar = dp.dateView.calendar; if (calendar.view().name === "year") { calendar.element.find(".k-header").css("display", "none"); calendar.element.find(".k-footer").css("display", "none"); }; }); [/code]

Kendo DatePicker Start End Validation

Case: 2 datepicker start dan end Validasi: max start adalah end, min end adalah start [code language=”javascript”] var startPicker, endPicker; startPicker = $(‘#StartDate’).data(‘kendoDatePicker’); endPicker = $(‘#EndDate’).data(‘kendoDatePicker’); startPicker.setOptions({ max: endPicker.value(), }); startPicker.bind(‘change’, function () { var startVal = startPicker.value(); endPicker.setOptions({ min: startVal, }); }); endPicker.setOptions({ min: startPicker.value() }); endPicker.bind(‘change’, function () { var endVal = endPicker.value();…

Aktivasi Product Microsoft Setelah Reinstall

Jika kita menggunakan product Microsoft dari Action Pack, ketika reinstall dan menggunakan product key yang sama ada kemungkinan dibilang bahwa product key tersebut sudah digunakan. Solusinya menghubungi nomor telepon Microosft activation 0800-120-1201 Nanti akan diminta untuk memasukan Installation ID, dan diberikan Confirmation ID untuk aktivasi kembali

Backup MySQL

There is Two way to backup your database One:Folder backup In windows go to xampp installation folder xampp> mysql > data > here you find your database name folder. copy it and save it . Also copy ib_logfileXX and ibdata you can use any other computer just go to xampp installation folder xampp> mysql >…

SQL Server Convert Row to Column using Pivot

Mengubah baris menjadi kolom pada SQL Server menggunakan pivot [code lang=”sql”] select order_media_mlr_id, DESIGN, LOCATION from ( select order_media_mlr_id, category, modified_time from order_media_mlr_logs where status = ‘READY_TO_SHOW’ ) d pivot ( max(modified_time) for category in (DESIGN, LOCATION) ) piv; [/code] https://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server

Fresh Install SQL Server 2014 Cannot Login

Saya baru install SQL Server 2014 dan tidak bisa login. Waktu dicek di “Event Viewer”, ternyata ada file yang gagal diakses oleh SQL Server. Cara memperbaiki file path bisa cek di situs ini https://social.technet.microsoft.com/wiki/contents/articles/31786.sql-server-not-starting-after-fresh-installation.aspx Bagian fix the broken path Reset password user sa, mengikuti cara pada web di atas juga Jika setelah diperbaiki, masih gagal…

Send Parameter in Web Service using Post Method

Berikut adalah cara mengirim data melalui web service dengan metode post. Mengirimkan object Web service: [code language=”csharp”] [HttpPost] public ServiceResponseStub<ProcurementPresentationStub> GetAll(GridRequestParameters parameter) { //kamus ServiceResponseStub<ProcurementPresentationStub> response = new ServiceResponseStub<ProcurementPresentationStub>(); //EFMemoDeptRepository repo = new EFMemoDeptRepository(); List<Procurement> data; List<ProcurementPresentationStub> returnData; List<SGUser> userList; Business.Infrastructure.FilterInfo filters; int? take = null; //algoritma filters = parameter.Filters; if (parameter.Take != 0) take…

Kendo Popover Inside Grid

Berikut adalah cara untuk menampilkan popover di dalam kendo grid: Kendo grid [code language=”javascript”] $("#media-grid").kendoGrid({ //… columns: [ //… { field: ‘SlaEnd’, title: ‘Target Selesai Sesuai SLA’, template: kendo.template($("#slaEndTemplate").html()), }, //… ], save: function (e) { //kamus var attribute = e.container.find("input[name=MediaName]").data("kendoComboBox"); var grid = this; //algoritma setTimeout(function () { //grid.refresh(); sortMediaGrid(); grid.tbody.find(‘[data-toggle="popover"]’).kendoTooltip({ position: ‘top’, width:…