How to Send (Pass) DataTable as parameter to Stored Procedure in Asp.Net using C#

Description:

In this example we explain that how to send DatatTable as parameter to stored procedure in Asp.Net using C#.or how to pass Data Table as parameter in stored procedure in C#.or passing Data Table to stored procedure as an argument using C#.or how to pass Data Table to stored procedure in asp.net.

Below is the code to how to pass data table in stored procedure in SQL Server using C#.

Select certain columns of a data table using C#.

Description:

In this example we explain that how to select certain columns of data table in C#.or how to fetch some specific column from Data Table in C#.or how to get some column from select statement in Data Table using C#.

Here we have one Data Table in which it’s contain many columns but I want to just fetch or retrieve some specific column so to achieve this below is the code foe how to retrieve some specific columns form Data Table in C#.

How do you handle multiple submit buttons in ASP.NET MVC Framework?

Description:
In this example, we explain that how to handle multiple submit button in MVC form in .Net. Or how do you handle multiple submit buttons in Asp.Net MVC Framework. Alternatively, how to handle multiple submit buttons on single View in MVC.

Below is the code that are useful to handle multiple submit button on single form in MVC.

How to get logged-in user Id and name in Dynamic CRM using JavaScript.

Description:

In this example, we explain that how to get users name of logged in user role in Dynamic 365 CRM using JavaScript. Alternatively, how to get current logged in user name using JavaScript in Dynamic CRM.or how to get the Logged in user id from JavaScript in dynamic CRM.

So here in this example we explain that how to get current user ID and Name in Dynamic CRM using JavaScript. Alternatively, how to retrieve current user info using JavaScript in Dynamic 365 CRM.below is the JavaScript code that will helpful you to get user name and id of the current logged in user in Dynamic CRM.

Getting Security Role Name for logged-in user in Dynamics using Xrm.

Description:

In this example, we explain that how to get logged in user role in Dynamic 365 CRM.or how to get security role name for logged-in user in Dynamic CRM using XRM.or how to retrieving login user security roles in Dynamic CRM.or how to get role name of current user in Dynamic CRM using JavaScript. Alternatively, get current logged in user’s security role using JavaScript.so below is the JavaScript code with XRM will used to get or retrieve current logged in user role in Dynamic CRM.

filter with parent opportunity id using Odata query Dynamic CRM.

Description:

In this example, we explain that how to filter with parent opportunity is using OData service in Dynamic CRM.or how to get or filter record based on parent opportunity using OData in Dynamic CRM.or OData query to get some parent field in Dynamic CRM.or using OData query to determine whether specific entity has children or not in Dynamic CRM.

So below is the JavaScript code with OData query to fetch or filter record with parent opportunity in Dynamic CRM.

Prefiltering in SSRS report on selected(current) record in Dynamic CRM.

Description:

In this example, we explain that how to run the SSRS report based on specific entity record using FetchXML in Dynamic 365 CRM.or prefiltering in SSRS report on current or selected record in Dynamic CRM using FetchXML. Alternatively, working with SSRS report pre-filtering or related entities record using FetchXML in Dynamic CRM.or how to display current record on SSRS report using FetchXML in Dynamic CRM.

So below is the FetchXML to prefiltering record in SSRS in Dynamic CRM.

Retrieving the last record in each group - SQL Server.

Description:

In this example we explain that how to get Last Record of each group using SQL Server. Alternatively, SQL query to retrieve Last record of each product or group using SQL Server. Alternatively, how to get last record of each group in every month of specific range using SQL query. Alternatively, how do I get latest record of each group using SQL Server query. Alternatively, how to select Last record of each group using SQL Server.

So below is the SQL query that will help you to select or retrieve last record of each group in each month.

Add/Insert New Value into OPTIONSET - Microsoft Dynamics CRM.

Description:

In this example, we explain that how to get or set Option Set item dynamically in Dynamic CRM using JavaScript. Alternatively, how to Add/Insert new value into Option Set in Dynamic CRM using JavaScript. Here in this example we explain that how to add New Items in Option Set control in Dynamic CRM using JavaScript. Or dynamically add or remove Option to an Option Set using JavaScript in Dynamic CRM.or add new Option Set to an Option in Dynamic CRM using JavaScript.in below example ="example-enableFiltering" is the id of the Select.

How to open confirmation dialog in Dynamic CRM.

Description:

In this example we explain that how to open Confirmation Dialog Box in Dynamic CRM using JavaScript. Alternatively, how to open Confirmation Dialog Box in Dynamic CRM and perform action when click on the button using JavaScript.

In Dynamic CRM Xrm.Utility library are used to display Confirm and alert Dialog Box in a form. Here in this example we explain that how to open confirmation dialog box and when click on ok button then perform some action or when click on cancel at that time close the dialog box.

So below is the JavaScript code to open Confirmation Dialog Box in Dynamic 365 CRM.

How to Get Opportunity Won or Lost via JavaScript in Dynamic CRM.

Description:

In this example we explain that how to get Opportunity is Won or lost using JavaScript in Dynamic CRM.or how to get the Status of the Opportunity using JavaScript in Dynamic 365 CRM.or How to track Opportunity closed as won using JavaScript in Dynamic CRM.

In our requirement like when any Opportunity is open by user at that time we have to get the status of the Opportunity like it is Won Opportunity or Lost Opportunity so we have used one JavaScript function on Form Load of Opportunity and get the status of the Opportunity when Opportunity is open by end user.

So below is the JavaScript code that are used to get the Opportunity status like Won or Lost in Dynamic CRM.

Retrieve Option set value from web API in Dynamic CRM

Description:

In this example, we explain that how to get the Option Set Value and Text in jQuery Ajax call success method result in Dynamic CRM.or how to retrieve Option set value from web api in Dynamic CRM.or retrieve the option set values for collection attribute in Dynamic CRM.

So here we explain that how to get option set text and value from OData query in Dynamic CRM web api.so below is the OData query that are useful to get the Option set value in Dynamic CRM.

Display Pie Chart in Dynamics CRM using Web Resource.

Description:
In this example, we explain that how to display pie chart in Dynamic CRM using HTML Web Resource. Alternatively, how to display revenue vs cost of particular opportunity in pie chart using HTML web Resource and Canvas JS chart in Dynamic CRM.or how to display pie chart in Dynamic CRM entity form using JavaScript and Web Resource.

So here we explain that how to get data of the Opportunity entity and display it in Pie Chart dynamically using HTML Web Resource and JavaScript in Dynamic CRM.