CRM 2011 like Subgrid With Sorting in JavaScript, CRM 2011 Display fetchxml in IFrame, Display Custom Advance Find view in Iframe 2014,

Today,
My post is about how to display Related Notes of an Entity in CRM Subgrid with Sorting, Refresh, Delete Multiple and Open Multiple Records:

For Example we want to display all Notes of Account Entity :

1. First of all Add IFrame to Account Entity with the following Properties:

2. Then Add New JavaScript library to the form Properties and Paste the following code in it.

            function Notes() {

1.     if (Xrm.Page.ui.getFormType() == 1) {
2.         return;
3.     }
4.     var NotesGrid = document.getElementById("IFRAME_RelatedAttachments");
5.     if (NotesGrid == null || NotesGrid.readyState != "complete") {
6. 
   
7.         setTimeout("Notes()", 2000);
8.         return
9. 
   
10.     }
11.     NotesGrid.src = "about:blank";
12.     var fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true' count='6'><entity name='annotation'><attribute name='annotationid'/><attribute name='subject'/><attribute name='notetext'/><attribute name='modifiedby'/><attribute name='filename'/><attribute name='isdocument'/><attribute name='filesize'/><attribute name='modifiedon'/><order attribute='modifiedon' descending='false'/><link-entity name='" + Xrm.Page.data.entity.getEntityName() + "' from='" + Xrm.Page.data.entity.getEntityName() + "id" + "' to='objectid' alias='aa'><filter type='and'><condition attribute='" + Xrm.Page.data.entity.getEntityName() + "id" + "' operator='eq'  value='" + Xrm.Page.data.entity.getId() + "'/></filter></link-entity></entity></fetch>";
13. 
    
14. 
    
15. 
    
16.     var layoutXml = "<grid name='resultset' object='5' jump='subject' select='1' icon='1' preview='1'><row name='result' id='annotationid'><cell name='isdocument' width='40' /><cell name='subject' width='200' /><cell name='filename' width='200' /><cell name='notetext' width='200' /><cell name='filesize' width='100' /><cell name='modifiedby' width='150' /><cell name='modifiedon' width='100' /></row></grid>";
17. 
    
18. 
    
19.     EmbedAdvancedFindView("IFRAME_RelatedAttachments", "annotation", fetchXml, layoutXml, "name", "false", "{DDDFF6AE-2F52-4640-B2BB-2BA59DA0777C}");
20. 
    
21.     // to remove the toolbar items from the advance find grid
22.     var iFrame1 = null;
23.     iFrame1 = crmForm.all.IFRAME_RelatedAttachments;
24.     var iDoc1 = iFrame1.contentWindow.document;
25.     iFrame1.attachEvent("onreadystatechange", Ready1);
26.     RemoveWhiteSpace();
27. 
    

}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

function EmbedAdvancedFindView(iFrameId, entityName, fetchXml, layoutXml, sortCol, sortDescend, defaultAdvFindViewId) {

    try {

        var iFrame = document.getElementById(iFrameId);

        var httpObj = new ActiveXObject("Msxml2.XMLHTTP");

        var url = "/" + ORG_UNIQUE_NAME + "/advancedFind/fetchData.aspx";

        var params = "FetchXML=" + fetchXml

        + "&LayoutXML=" + layoutXml

        + "&EntityName=" + entityName

        + "&DefaultAdvFindViewId=" + defaultAdvFindViewId

        + "&ViewType=1039";

        httpObj.Open("POST", url, true);

        httpObj.setRequestHeader("Content-type", "application/x-www-form-urlencoded");

        httpObj.setRequestHeader("Content-length", params.length);

        httpObj.onreadystatechange = function () {

            if (httpObj.readyState == 4 && httpObj.status == 200) {

                var doc = iFrame.contentWindow.document;

                iFrame.src = null;

                doc.open();

                doc.write(httpObj.responseText);

                doc.close();

                // doc.body.style.padding = "0px";

                // doc.body.style.backgroundColor = "#eaf3ff";

            }

        }

        httpObj.send(params);

    }

    catch (e) {

    }

}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

function Ready1() {

    try {

        var iFrame = crmForm.all.IFRAME_RelatedAttachments;

        var iDoc1 = iFrame.contentWindow.document;

        if (iDoc1.getElementById("gridMenuBar") != null)

            iDoc1.getElementById("gridMenuBar").style.display = "none";

    } catch (e) {

    }

}

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

3. Call the Notes() function on Onload event of Account Form, and you will see a Subgrid Displayed with Sorting on each column, and Refresh Button.

Bridge Inspection and Management system in Asp Dot Net (.NET C#) with Source Code and Database in MS Sql Server 2008

I have developed Bridge Inspection System using Visual Studio Web-Site Project in Asp.net with C#, using my own CSS styling.
Database: in Microsoft SQL server 2008 R2.
Above is the Main Screen, Default Page.
Following are features in this Bridge Inspection System:

• Admin who can add more admins,Collectors,Inspectors and Bridges to be inspected in  System
  Delete Collectors, Inspectors and Bridges from the System.
• Bridge Inspector who can Inspect the Bridges that are currently added and make a report
• Bridge Collector who can View the final Reports added by BI.
• Reports Generation from Inspected Bridge Data and Export Reports in PDF format to be ready for download and printing.
• Profile Management.
• and more ..........................
• Sql Server 2008 Database, Normalized and Complete Relationships.

Following are some screen-shots of the system.

Admin Login:

Admin Page:

 Add Bridge Profile:

Profile Managment:

 Bridge Profile View:

If anyone need Source Code along with the Database file, please ask in Comments I will provide links:
Thanks,
Saqib Khan. (Dynamics CRM developer).