Accessing a SQL Database from a Microsoft Dynamics CRM Plug-in

Description:-

In this example we explain that how to use external SQL server database from CRM plugin and perform the operation on it.

This is the real issue I faced that I have requirement like when new lead is created in CRM at that its lead data automatically inserted to the SQL server database table. Here database is other not the same CRM database.so for that I have created one code that will allow you to insert the last created lead from CRM to SQL database table easily.

We demonstrate insert data into SQL database from the CRM or fetch the data form CRM database and insert it to other SQL database.so how to transfer data from CRM database to SQL database using CRM plug-in.

Here we explain how to insert last inserted Lead into CRM to external SQL database using web service. Or fetch last inserted lead data from CRM and insert these data into SQL database using web service.

Here we create one table Called “Lead” in the external SQL database and when new lead is inserted in CRM database at that we fire the plugin that will automatically get Lead data from the CRM database and insert it to lead table in SQL Database.

creating Lookup table field using extended data type in AX

 Description:-

In previous example we already explain that how to create lookup in AX and now In this example we explain that how to create EDT (Extended data type In AX 2012).or creating Lookup table field using extended data type in AX. The best advantages of EDT is you can access it in any form directally.Below is the step to create EDT in ax.

how to bind Lookup in ax 2012.

Description:-

In this example we explain that how to add control with Lookup in AX 2012. Or how to bind Lookup for string edit control in ax 2012.

Look up is nothing but a one kind of terms and are used in ax to show data of other table in dropdown list format.

To create lookup  for any field just override the Lookup  method of the field in which you want to create lookup and paste the below code in your lookup method and change the table name and field name from the below code as per your requirements.

But the main disadvantages of using lookup is you need to override this method on every form in which you required.so if you need same functionality on all the places accessing the field on the form. You have to use EDT relation ship for this.check this post for EDT in AX Create EDT instead of Lookup in AX 2012

How to Display tooltip on dropdownlist items in asp.net using jquery or javascript.

Description :

in this example we explain that how to display tooltip on dropdown items using jquery and javascript. or how to add tooltip to asp.net dropdownlist items using jquery/javascript in asp.net.
suppose i have one dropdown and its items display the name of the employee now if i have to display also the employee code then how can i achieve because at a time only one datfield is displayed in dropdownlist items.

so to ahieve this type of facility to display employee name as well as employee code on items tooltip then we have to use javascript or jquery to display this.

so below example demostrate the display tooltip on dropdown items in asp.net using jquery or javascript.

display loading image on button click using jquery

Desciption:

in this example we explain that how to display Loading image when user clicked on button using javascript or jquery in asp.net.we all show that types of behavior or functionality in many website like for when we do any banking transaction at that it will display loading image before done the transaction.

so that is very easy to display loading image or popup in our website to display user for wait sometime to done the process.