Warning: Creating default object from empty value in /home/marengg1/public_html/blog/wp-content/themes/deleveb/functions/admin-hooks.php on line 160

Converting Float to Varchar in SQL Server, In Non Scientific Form

Published on December th, 2013
Andri Kasta Marengga

Converting Float to Varchar in SQL Server, In Non Scientific Form

Recently I got a problem about my data in SQL Server database. Here’s the chronology : I have a data on DB (let’s says this is Table A) that should be updated based on an Excel file from a user Because the Excel file has a huge number of rows, I decide to import this file to […]

Continue Reading →

How to add ListItem to Dropdownlist at first position

Published on January th, 2013
Andri Kasta Marengga

How to add ListItem to Dropdownlist at first position

Recently I knew a “new” method named ddlArea.Items.Insert. Here’s the story how we met Result of code snippet above:  “All Area” item disappear from my dropdownlist, I guess binding dropdownlist with a new datasource replace all its item with new items. If I put ddlArea.Items.Add(myItem) after DataBinding call, myItem will be placed on the last […]

Continue Reading →

Programatically Change Color Of An Element to Hexa Color Code

Published on January th, 2013
Andri Kasta Marengga

Programatically Change Color Of An Element to Hexa Color Code

Changing color (ex: forecolor) of an element is actually easy. You only have to do this one line script But the weakness of this way is you can’t specify your personal color. Solution to this matter is we have to define our custom color (either in css file or by code) first and then use […]

Continue Reading →

JQuery Datepicker Throws Runtime Error

Published on November th, 2012
Andri Kasta Marengga

JQuery Datepicker Throws Runtime Error

I use JQueryUI Datepicker as my datepicker on ASP Net webform. It run smoothly until I added some field validator to my form. Whenever I click on date picker calendar icon it throws this error On this line of codes The reason why its breaking because of the onselect function of the datepicker causes validators […]

Continue Reading →

Saving SQL Server Query Result In Text Format

Published on October th, 2012
Andri Kasta Marengga

Saving SQL Server Query Result In Text Format

Saving query result from SSMS is not easy as it seems, some of my colleague copy from SSMS query result and paste it to Excel. Apparently it’s not a problem, but it can be a problem if your data saved in text data type column but containing numeric data. If you paste this data directly […]

Continue Reading →

Delete All Sharepoint Recycle Bin Items

Published on September th, 2012
Andri Kasta Marengga

Delete All Sharepoint Recycle Bin Items

Cleaning up Sharepoint recycle bin items look like a simple job, just select which item you want to delete and press Delete Selection button. But can you imagine what a boring task if you have thousands items there? You have to select item by item, page by page. Ppffftt I found a little magic to […]

Continue Reading →

Dynamics CRM Open New Window After IFrame Postback Button Click

Published on September th, 2012
Andri Kasta Marengga

Dynamics CRM Open New Window After IFrame Postback Button Click

I have a Dynamics CRM form and add an iFrame in it, inside this iFrame I have a plan to display an ASPX webform page, I already develop that webform and it works like a charm. The problem raised after I deploy ASPX webform to Dynamics CRM iFrame. After the submit button is clicked, Dynamics […]

Continue Reading →

Using Bulk Edit in Dynamics CRM

Published on July th, 2012
Andri Kasta Marengga

Using Bulk Edit in Dynamics CRM

One of user’s favorite feature of Dynamics CRM is Bulk Editing, which is a feature to edit some records in a click. CRM User simply select all records he want to edit, and click More Actions → Edit. Beside of its benefit, bulk edit feature might be misused. Last month, I faced a “big” problem, […]

Continue Reading →

How To Delete Dynamics CRM Organization

Published on May th, 2012
Andri Kasta Marengga

How To Delete Dynamics CRM Organization

Sometimes we need to delete an Organization in Microsoft Dynamics CRM. But unfortunately this option doesn’t appear in Deployment Manager. The only option you got there is just to disable organization. And now, I’ll give you the magic touch how to delete Organization(s) in Microsoft Dynamics CRM 😀 The first thing you have to do […]

Continue Reading →