Tech Solutions

In this blog I am going to show how we can fetch data from Dynamics CRM OnPremise and Show them in a gridview on Web Page. Not only this but also following points: Selecting value of row by clicking anywhere on a row. Searching data in Gridview. Sorting of data in Gridview. Paging in Gridview. First of all take a Textbox for serach box and Gridview on your web page and place below code:: <form id="form1" runat="server">        <script type="text/javascript">        function RefreshParent(row) {          if (window.opener != null && !window.opener.closed) {              var message = "";              message += "Id: " + $("td", row).eq(0).html();              message += "\nName: " + $("td", row).eq(1).html();              alert(message);   ...

This blog contains the whole list of COndition operators used in FetchXMl and the aggregation used in FetchXML while using C# Source: MSDN Here is a list of all ConditionalOPerator and the second table contains the list of aggregation used in FetchXML:: ConditionOperator FetchXML Operator Description BeginsWith like The string occurs at the beginning of another string. Between between The value is between two values. Contains like The string contains another string. DoesNotBeginWith not-like The string does not begin with another string. DoesNotContain not-like The string does not contain another string. DoesNotEndWith not-like The string does not end with another string. EndsWith like The string ends with another string. Equal eq The values are compared for equality. EqualBusinessId eq-businessid The value is equal to the specified business ID. EqualUserId eq-userid The value is equal to the specified user ID. EqualUserTe...