IT Study

Solution file (.sln) lost CRM Developer Toolkit Instance

Andre MargonoCRM 2011, IT Study, Microsoft CRM, Microsoft Dynamics, Microsoft Dynamics CRM 2011, , , ,

I’ve encountered this issue several times (especially when we are check in to TFS), that the solution file is not merged properly, and for some reason the developer toolkit bind is removed.

 
To fix this, edit .sln file using notepad/any text editor, then add:
 
GlobalSection(CRMSolutionProperties) = preSolution
  SolutionIsBoundToCRM = True
EndGlobalSection​
 
In Global, after:
 
GlobalSection(TeamFoundationVersionControl) = preSolution

 

Config Files in ASP.Net

Andre MargonoIT Study, Web Development

I think this is a beginner subject of ASP.Net development, however I somewhat miss this thing when I was learning ASP.Net in Uni…

When we creating an ASP.Net web application, sometimes we create other projects under the same solution to handle business logic or other relevant classes. And sometimes we want to create the application config file on that respective project. However that project is not an executable project.. So I confused and asking myself for about an hour to think.. Why the value that I retrieve from the config file (App.config) always null??

The reason is: I put the config file on the project that has no executable, so when I debug and run the solution, it automatically call the web application and all of the config that used is the config of web (which is Web.config).

So instead of using the config file from specific project that does not have executable at all, I should use and set the keys config file where the project is executable.

handling jQuery on ASP.NET ID

Andre MargonoIT Study, jQuery, Web Development,

jQuery is a very powerful library for making good interaction on your web application. However in ASP.Net development environment there is a problem that I found when selecting the ID of an ASP.Net control.

Usually we can select the id of specific html tag by using this

$(document).ready(function(){
$('#IDofSpecificTag').click(function() {
// do implementation here
)};
});

But when we want to access the ID of ASP.Net Control we cannot simply select the ID of the control, as when it rendered in html page (after it compiled) it will have some attachment (prefix) on the id.
For example, my asp:textbox with id txtBarcode it renders as ContentPlaceHolder1_txtBarcode in the generated html.

The Solution:

$(document).ready(function(){
$('# <%= IDofSpecificTag.ClientID %>').click(function() {
// do implementation here
)};
});

OR


$(document).ready(function(){
$("*[id$='IDofSpecificTag']")..click(function() {
// do implementation here
)};
});

I prefer the first solution as it is very simple in implementation, however it is not very good practice to mix up between ASP.Net tag with javascript..
I hope this will be useful for people who are still learning how to use jQuery in ASP.Net 🙂

Oracle Auto Increment ID

Andre MargonoIT Study

Oracle does not support the auto increment automatically. We need to create sequence and trigger before.

Sequence creation:

CREATE SEQUENCE sequence_name
MINVALUE value
MAXVALUE value
START WITH value
INCREMENT BY value
CACHE value;

example:

CREATE SEQUENCE book_sequence
MINVALUE 1
MAXVALUE 999999999999999999999999999
START WITH 1
INCREMENT BY 1
CACHE 20;

Trigger Creation:

CREATE OR REPLACE TRIGGER <trigger name> BEFORE INSERT ON <table name> REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT <sequence name>.nextval INTO :NEW.<id from table> FROM dual; END;

example:

CREATE OR REPLACE TRIGGER "BOOK_TRIGGER" BEFORE INSERT ON book REFERENCING NEW AS NEW FOR EACH ROW BEGIN SELECT book_sequence.nextval INTO :NEW.BOOKID FROM dual; END;

That’s all hopefully it’s helpful..

Basic AJAX

Andre MargonoIT Study

I found this function to load a document via ajax. It enables people to do web task without reloading the page

function loadXMLDoc(url)
{
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
xmlhttp.open(“GET”,url,false);
xmlhttp.send(null);
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject(“Microsoft.XMLHTTP”);
xmlhttp.open(“GET”,url,false);
// Do not send null for ActiveX
xmlhttp.send();
}
document.getElementById(‘test’).innerHTML=xmlhttp.responseText;
}