SQL Query to return all records from current month or This month

Description:

In this example we explain that how to get records of current month using SQL Server. Or SQL Query to get the This Month record in SQL Server. Or SQL Query to return all records from current month using SQL Server. Or SQL query to select all records created in current month. Or how to retrieve current month date values in SQL Server.

SQL Server - Filter by Dates in SQL using SQL Query.

Description:

In this example we explain that how to get the Last Month, Next Month, This Month, Last Week, Next week, This Week, Today, Yesterday, tomorrow created record in SQL Server. Or how to fetch or select the record based on Date filter in SQL Server. Or SQL Query to get or select the record based on different Date filter condition in SQL.

Here we demonstrate the basic idea or some important SQL Query of the Date that we have used in our daily routines.so below is the different SQL Query to get the record from SQL Server based on some different Date filter criteria.

Access ViewBag value inside JavaScript function in ASP.Net MVC

Description:
In this example we explain that how to use ViewBag value inside JavaScript function in Asp.Net MVC.or how to access ViewBag value in JavaScript function using MVC Razor View. Or how to access ViewBag value at client side in ASP.Net MVC.or how to transfer ViewBag value from controller to Razor view in MVC.

Insert Dynamic content in Email Template from related record using Click Dimension in Dynamic CRM

Description:

In this example we explain that how to display dynamically contact name to an Email using click dimension in Dynamic CRM.or insert Dynamic content in Email Template from related record in Dynamic CRM using click dimension. Or how to insert Dynamic contact fullname of the related record in Email Template when email is sent from Dynamic CRM using click dimension. Or how to send an email to the marketing list with dynamic content in email using click dimension in Dynamic CRM.

So below is the single line code that will display contact fullname dynamically in email template based on related record of the contact in Dynamic CRM suing click dimension.

view in browser in click dimension custom html

Description:

In this example we explain that how to display View in Browser link in click dimension custom html in Dynamic CRM. or how to create view in browser link to display Email Template Email in browser in Dynamic CRM using Click Dimension. Or code for the display email in browser using view in browser link in email using click dimension in Dynamic CRM.

So below is the single line code is used to display view in browser link in email to show outlook email in browser in dynamic CRM using click dimension.

Implement Google RECaptcha Code with Example in ASP.Net

Description:

In this example we explain that how to implement the Google RECaptcha code in Asp.Net.or how to create Google RECaptcha to validate the user in website in Asp.Net.or how to implement the I am not Robert Google RECaptcha in Web Application using Asp.Net.

Google RECaptcha generally validate the Captcha response on client side using its call back functions.so how can we implement Google RECaptcha in our website?

Before implement you have to follow the below link to get the Site key and Secret key of the Google RECaptcha.

https://www.google.com/recaptcha/intro/index.html

Highlight row of WebGrid on Mouseover (Mouse Hover) in MVC using CSS

Description:

In this example we explain that Highlight rows of the WebGrid on Mouse over using CSS in Asp.Net MVC.or how to Highlight row of WebGrid in MVC when mouse hover using CSS.or how to change the colour of the row of the WebGrid in MVC Razor view using CSS.

So here we demonstrate that how to highlight the web grid or grid view row when mouse is hover using CSS in MVC Razor view.

Call jQuery function on Html.ActionLink click in ASP.Net MVC

Description:

In this example we explain that how to call jQuery function on Html.ActionLink click in Asp.Net MVC.or how to call jQuery function on click of the Html.ActionLink link button in Asp.Net MVC.or how to call client side function on click on Html.ActionLink in MVC.or how to implement the Html.ActionLink in Razor view to call the jQuery function in MVC.

How To Use Sorting In GridView In Asp.Net

Description:

In this example we explain that how to use Sorting in GridView in Asp.Net C#. or how to sort the data in GridView in Asp.Net using C#. or how to perform sorting in GridView in Asp.Net.or sorting GridView columns in asp.net using C#.

So here we demonstrate that how to create custom sorting for the GridView columns in Asp.Net using C#. below is the code to sort the GridView Data in Asp.Net.

How to set the option set value dynamically using javascript.

Description:

In this example we explain that how to get and set a OptionSet field using JavaScript in Dynamic CRM.or how to set OptionSet value Dynamically using JavaScript in Dynamic 365.or how to update the Option Set Value using JavaScript in Dynamic 365.or how to set OptionSet field value in Dynamic CRM using JavaScript. Or JavaScript to select a value in OptionSet filed in Dynamic CRM.

So here we demonstrate that how to set OptionSet Details in Dynamic 365 using JavaScript. Below is the JavaScript code to Get or Set the OptionSet field text/value in Dynamic CRM.

How to Get and Set a Lookup Field Using JavaScript in Dynamics 365

Description:

In this example we explain that how to get and set a Lookup field using JavaScript in Dynamic CRM.or how to update the Lookup Value using JavaScript in Dynamic 365.or how to set Lookup field value in Dynamic CRM using JavaScript. Or JavaScript to select a value in Lookup filed in Dynamic CRM.

So here we demonstrate that how to set Lookup Details in Dynamic 365 using JavaScript. Below is the JavaScript code to Get or Set the Lookup field text/value in Dynamic CRM.

how to retrieves all the child contacts of the account using JavaScript and web API in Dynamic CRM

Description:

In this example we explain that how to get or retrieve Multiple records using web API in Dynamic CRM.or how to retrieves all the child contacts of the account using JavaScript and web API in Dynamic CRM.or how to retrieve multiple records using JavaScript in Dynamic CRM.or using JavaScript to retrieve the records of the Dynamic CRM entity based on the id of the entity. Or retrieve the another entity record by using GUID of that record in JavaScript. When we retrieving multiple records request will be similar to single record but we need to specify the filter criteria using $filter.

So here we demonstrate that how to retrieve multiple record from the Dynamic CRM based on the GUID of the entity using JavaScript.

Retrieve another entity record by using GUID of that record in Javascript

Description:

In this example we explain that how to get or retrieve single records using web API in Dynamic CRM.or how to retrieve records using JavaScript in Dynamic CRM.or using JavaScript to retrieve the records of the Dynamic CRM entity based on the id of the entity. Or retrieve the another entity record by using GUID of that record in JavaScript.

So here we demonstrate that how to retrieve record from the Dynamic CRM based on the GUID of the entity using JavaScript.

QueryExpression to filter based on related entities in Dynamic CRM.

Description:

In this example we explain that how to filter the record based on QueryExpression in Dynamic CRM.or QueryExpression to filter based on related entities in Dynamic CRM.or retrieve the related entity records along with primary entity using Retrieve method in Dynamic CRM.

So here we demonstrate that Query Expression filter or condition against two linked entities in Dynamic CRM.or sample to retrieve multiple with the Query Expression class in Dynamic CRM.or Querying Data with the Query Expression in Dynamic CRM.

Here in below example we filter the contact entity with the Email Address and full name two conditional expression using Query Expression and return the related record if the match.