Thursday 14 January 2021

 Description:

In this example, we explain that How to run a more than 8000 characters SQL statement from a variable? Or varchar (MAX) text cuts off while going more than 8000 characters inside a procedure. Or how to print the SQL Query when it exceeds the 8000 character. Because the problem was that by default Nvarchar (max) only print 8000 characters so when your query exceeds the 8000 characters at that time what should you do if you want to debug or print the string sql query.

How to run a more than 8000 characters SQL statement from a variable?

 Description:

In this example, we explain that How to run a more than 8000 characters SQL statement from a variable? Or varchar (MAX) text cuts off while going more than 8000 characters inside a procedure. Or how to print the SQL Query when it exceeds the 8000 character. Because the problem was that by default Nvarchar (max) only print 8000 characters so when your query exceeds the 8000 characters at that time what should you do if you want to debug or print the string sql query.

This entry was posted in :

Wednesday 13 January 2021


Description:

In this example we explain that how to add double click event on right click using JQuery. Or how to fire double click event with context menu using JQuery. Or how can I call double click event with right click context menu in Grid view or Data Table using JQuery.

As we all know because by default double click is not fire because of the it will call context menu event first and when context menu appears then it will not allow any action on data table or grid view.

How to add double click event with context menu using JQuery


Description:

In this example we explain that how to add double click event on right click using JQuery. Or how to fire double click event with context menu using JQuery. Or how can I call double click event with right click context menu in Grid view or Data Table using JQuery.

As we all know because by default double click is not fire because of the it will call context menu event first and when context menu appears then it will not allow any action on data table or grid view.

Sunday 11 October 2020

 

Display Download Count Day,Month,Year wise

Description:

In this example we explain that how to get download count Day, Month, Year wise in a single query Using SQL Query. Or how to get download count reports of Day, Month, Year in a single query using SQL Query.

Suppose you have to display some charts or report of the website viewer or mobile app download count for Day, Moth, Year wise at that time below SQL Query is useful to get the data.

SQL Query for Counting Records per Day,Month,Year in a single view

 

Display Download Count Day,Month,Year wise

Description:

In this example we explain that how to get download count Day, Month, Year wise in a single query Using SQL Query. Or how to get download count reports of Day, Month, Year in a single query using SQL Query.

Suppose you have to display some charts or report of the website viewer or mobile app download count for Day, Moth, Year wise at that time below SQL Query is useful to get the data.

This entry was posted in :

Friday 2 October 2020

 

sql query to get month wise count


Description:

In this example we explain that how to get all Month  like Jan,Feb, Dec etc.. Using SQL Query. or how to get download count per month of the year using SQL Query. Or count records of every month in a year using SQL.or SQL query to get month wise count and display it on website or chart. or how to get count of month based on a year using SQL query.

We have requirement like display Month wise download application count in website. So achieve this below is the SQL Query that will helpful for you to get month wise download count.

 

SQL Query to get Count records for every month wise in a year

 

sql query to get month wise count


Description:

In this example we explain that how to get all Month  like Jan,Feb, Dec etc.. Using SQL Query. or how to get download count per month of the year using SQL Query. Or count records of every month in a year using SQL.or SQL query to get month wise count and display it on website or chart. or how to get count of month based on a year using SQL query.

We have requirement like display Month wise download application count in website. So achieve this below is the SQL Query that will helpful for you to get month wise download count.

 

This entry was posted in :

 

Day wise count of current Month

Description:

In this example we explain that how to get all date of the current month like 1 oct, 2 oct… 31 oct etc.. Using SQL Query. Or how to get download count per day of the current month day wise using SQL Query.

We have requirement like display day wise download application count in website. So achieve this below is the SQL Query that will helpful for you to get daily date wise download count.

 

How to get all dates in the current month with download count using SQL Query

 

Day wise count of current Month

Description:

In this example we explain that how to get all date of the current month like 1 oct, 2 oct… 31 oct etc.. Using SQL Query. Or how to get download count per day of the current month day wise using SQL Query.

We have requirement like display day wise download application count in website. So achieve this below is the SQL Query that will helpful for you to get daily date wise download count.

 

This entry was posted in :

Thursday 6 August 2020

 

Description:

In this example we explain that how to store binary Image in Database in Asp.Net Core. or how to store image in database using .Net Core. So how to save Images to database using Asp.Net Core.

So here we demonstrate that how to upload file and save file n a binary format in database using Asp.Net Core. Below is the code that will help you to save or upload file in database in .net core.

How to upload a file and save in binary format in Asp.net Core

 

Description:

In this example we explain that how to store binary Image in Database in Asp.Net Core. or how to store image in database using .Net Core. So how to save Images to database using Asp.Net Core.

So here we demonstrate that how to upload file and save file n a binary format in database using Asp.Net Core. Below is the code that will help you to save or upload file in database in .net core.

This entry was posted in :

Wednesday 5 August 2020

Description:

In this example we explain that how to retrieve the current user logged in to Dynamic 365 CRM.or how to retrieve or get the Logged In user security Role Name in Dynamic 365 using JavaScript. Or how to get User security role name from context in Dynamic 365 using JavaScript. Or get security role name of the Logged In user using JavaScript.


So below is the JavaScript code that will help you to get the current Logged In user security role name in Dynamic 365.or how to get All Security Role Names of the Logged In User in Dynamic 365 using JavaScript.

 

Code :

function GetLoggedInUserSecurityRoleNames() {

 // Get Logged In User Context

 var userSettings = Xrm.Utility.getGlobalContext().userSettings;

 // Get Logged In User Security Roles

 var loggedInUsersecurityRolesGuidArray = userSettings.securityRoles;

 var totalSecurityRolesArray = new Array();

 var allRolesName = "";

 

if (loggedInUsersecurityRolesGuidArray.length > 0) {

 Xrm.WebApi.retrieveMultipleRecords("roles", "?$select=name,roleid").then(

 function success(result) {

 if (result.entities.length > 0) {

 // Push Role Names and Role Ids to Array

 for (var rolesCount = 0; rolesCount < result.entities.length; rolesCount++) {

 totalSecurityRolesArray.push({ RoleName: result.entities[rolesCount].name, RoleId: result.entities[rolesCount].roleid });

 }

 

allRolesName = userSettings.userName + " has the below Security Roles\n------------------------------------\n";

 

// Compare the User Security Roles with Total Security Roles

 for (var userSecurityRolesCounter = 0; userSecurityRolesCounter < loggedInUsersecurityRolesGuidArray.length; userSecurityRolesCounter++) {

 for (var totalsecurityRolesCounter = 0; totalsecurityRolesCounter < totalSecurityRolesArray.length; totalsecurityRolesCounter++) {

 if (totalSecurityRolesArray[totalsecurityRolesCounter].RoleId.toLowerCase() == loggedInUsersecurityRolesGuidArray[userSecurityRolesCounter].toLowerCase()) {

 allRolesName += totalSecurityRolesArray[totalsecurityRolesCounter].RoleName + "\n";

 break;

 }

 }

 }

 }

 

// Show User Roles

 Xrm.Utility.alertDialog(allRolesName, null);

 },

 function (error) {

 // Show error

 Xrm.Utility.alertDialog(error.message, null);

 });

 }

}


Get the Logged In User Security Role Names using JavaScript in Dynamics 365

Description:

In this example we explain that how to retrieve the current user logged in to Dynamic 365 CRM.or how to retrieve or get the Logged In user security Role Name in Dynamic 365 using JavaScript. Or how to get User security role name from context in Dynamic 365 using JavaScript. Or get security role name of the Logged In user using JavaScript.


So below is the JavaScript code that will help you to get the current Logged In user security role name in Dynamic 365.or how to get All Security Role Names of the Logged In User in Dynamic 365 using JavaScript.

 

Code :

function GetLoggedInUserSecurityRoleNames() {

 // Get Logged In User Context

 var userSettings = Xrm.Utility.getGlobalContext().userSettings;

 // Get Logged In User Security Roles

 var loggedInUsersecurityRolesGuidArray = userSettings.securityRoles;

 var totalSecurityRolesArray = new Array();

 var allRolesName = "";

 

if (loggedInUsersecurityRolesGuidArray.length > 0) {

 Xrm.WebApi.retrieveMultipleRecords("roles", "?$select=name,roleid").then(

 function success(result) {

 if (result.entities.length > 0) {

 // Push Role Names and Role Ids to Array

 for (var rolesCount = 0; rolesCount < result.entities.length; rolesCount++) {

 totalSecurityRolesArray.push({ RoleName: result.entities[rolesCount].name, RoleId: result.entities[rolesCount].roleid });

 }

 

allRolesName = userSettings.userName + " has the below Security Roles\n------------------------------------\n";

 

// Compare the User Security Roles with Total Security Roles

 for (var userSecurityRolesCounter = 0; userSecurityRolesCounter < loggedInUsersecurityRolesGuidArray.length; userSecurityRolesCounter++) {

 for (var totalsecurityRolesCounter = 0; totalsecurityRolesCounter < totalSecurityRolesArray.length; totalsecurityRolesCounter++) {

 if (totalSecurityRolesArray[totalsecurityRolesCounter].RoleId.toLowerCase() == loggedInUsersecurityRolesGuidArray[userSecurityRolesCounter].toLowerCase()) {

 allRolesName += totalSecurityRolesArray[totalsecurityRolesCounter].RoleName + "\n";

 break;

 }

 }

 }

 }

 

// Show User Roles

 Xrm.Utility.alertDialog(allRolesName, null);

 },

 function (error) {

 // Show error

 Xrm.Utility.alertDialog(error.message, null);

 });

 }

}


Thursday 28 November 2019

3 elements per row for wrapping flexbox : css

Description:

In this example we explain that how to display three items per row using CSS.or how to display three items or three Checkboxes per row in Checkbox List using CSS.or how I can show three column per row that’s type of question was raised by many developers.

So in this scenario we have a requirement like Checkbox List contains 50 items and we have to display three items per row.

So to achieve this below is the code to display 3 items per row or per line using CSS.

how to display three items per row using CSS

3 elements per row for wrapping flexbox : css

Description:

In this example we explain that how to display three items per row using CSS.or how to display three items or three Checkboxes per row in Checkbox List using CSS.or how I can show three column per row that’s type of question was raised by many developers.

So in this scenario we have a requirement like Checkbox List contains 50 items and we have to display three items per row.

So to achieve this below is the code to display 3 items per row or per line using CSS.

Sunday 3 November 2019

Get Total Count of records in CRM

Description:


In this example we explain that how to count number of records in Dynamic CRM and display it in a form or entity. In this example we explain that how to get total number of contacts in Dynamic CRM.so to get total count records below is the code for that

How to get the total record count from an entity in Dynamic CRM

Get Total Count of records in CRM

Description:


In this example we explain that how to count number of records in Dynamic CRM and display it in a form or entity. In this example we explain that how to get total number of contacts in Dynamic CRM.so to get total count records below is the code for that
This entry was posted in :

Thursday 30 May 2019

how to read resource file in .Net core


Description:

In this example we explain that how to read resource file in .Net core. Or how to read .resx file in .Net Core and MVC.we have requirement like read resource file dynamically and bind it to Dataset in .Net Core 2.1.so here we demonstrate how to reading a file stream from resource file in .Net Core.
Below is the code to demonstrate how to read and write XML or Resource file in .Net Core and bind the result in Dataset Table.

how to read resource file in .Net core

how to read resource file in .Net core


Description:

In this example we explain that how to read resource file in .Net core. Or how to read .resx file in .Net Core and MVC.we have requirement like read resource file dynamically and bind it to Dataset in .Net Core 2.1.so here we demonstrate how to reading a file stream from resource file in .Net Core.
Below is the code to demonstrate how to read and write XML or Resource file in .Net Core and bind the result in Dataset Table.

Monday 13 May 2019

How to Send Birthday Email to Contacts using Custom Workflow in Dynamic CRM


Description:


In this example, we explain that how to Sending an automated email to a Contact on their birthday, a simple requirement that can be achieved with Dynamics 365 Custom Workflow.
Generally will get the requirement from client to send Birthday emails to their customers. Everyone will suggest going with Console Application schedule to run at the specific time but that is not the best solution so here we demonstrate to how to send Birthday Email to client or customer by using Workflow in Dynamic 365 CRM.

How to Send Birthday Email to Contacts using Custom Workflow in Dynamic CRM

How to Send Birthday Email to Contacts using Custom Workflow in Dynamic CRM


Description:


In this example, we explain that how to Sending an automated email to a Contact on their birthday, a simple requirement that can be achieved with Dynamics 365 Custom Workflow.
Generally will get the requirement from client to send Birthday emails to their customers. Everyone will suggest going with Console Application schedule to run at the specific time but that is not the best solution so here we demonstrate to how to send Birthday Email to client or customer by using Workflow in Dynamic 365 CRM.

Thursday 21 March 2019

How to hide “Showing 1 of N Entries” with the dataTables.js library

Description:


In this example we explain that how to remove showing 0 to 0 of 0 entries in data table in Grid View using JQuery. Alternatively, how to hide showing 0 to 0 of 0 entries in data table of grid view in JQuery. Alternatively, How to hide “Showing 1 of N Entries” with the dataTables.js library.

Here in our requirement I want to display data table grid but in bottom I do not want to show showing 0 to 0 of 0 entries in data table so to achieve this below is the single line code that will help you to hide or remove showing 0 to 0 of 0 entries in data table  grid.


You have to include like "info":false,

How to hide “Showing 1 of N Entries” with the dataTables.js library

How to hide “Showing 1 of N Entries” with the dataTables.js library

Description:


In this example we explain that how to remove showing 0 to 0 of 0 entries in data table in Grid View using JQuery. Alternatively, how to hide showing 0 to 0 of 0 entries in data table of grid view in JQuery. Alternatively, How to hide “Showing 1 of N Entries” with the dataTables.js library.

Here in our requirement I want to display data table grid but in bottom I do not want to show showing 0 to 0 of 0 entries in data table so to achieve this below is the single line code that will help you to hide or remove showing 0 to 0 of 0 entries in data table  grid.


You have to include like "info":false,

Monday 25 February 2019

how to remove pagination in datatable

Description:

In this example we explain that how to remove pagination in datatable in GridView using JQuery.or how to hide pagination in datatable of gridview in JQuery.

Here in our requirement I want to display datatable grid but in bottom I do not want to show pagination so to achieve this below is the single line code that will help you to hide or remove pagination in datatable grid.

You have to include like "bPaginate": false,
So here we explain that how to hide jquery datatable pagination.

How to remove Pagination in Data table Grid in .Net Core.

how to remove pagination in datatable

Description:

In this example we explain that how to remove pagination in datatable in GridView using JQuery.or how to hide pagination in datatable of gridview in JQuery.

Here in our requirement I want to display datatable grid but in bottom I do not want to show pagination so to achieve this below is the single line code that will help you to hide or remove pagination in datatable grid.

You have to include like "bPaginate": false,
So here we explain that how to hide jquery datatable pagination.