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.

Create Contact or Account in CRM using Services or asp.net webform.

Description:

In this example we explain that how to create Contact or Account in CRM using asp.net web form or from asp.net website. Or how to create Contact using CRM Discovery web services to generate contact or Account through programmatically. We already explain that how to create lead from asp.net web form in previous example. Here we explain how to create contact or Account programmatically in CRM using C#.

To create Contact in CRM through programmatically create web form in your asp.net web application and use the below code.

How to Create Lead in Dynamic CRM from asp.net web form.

Description:

In this example we explain that how to create Lead in Dynamics CRM from external contact form. Or how to create Lead using asp.net website or web application. Here we explain how to create Lead programmatically in CRM using C#.

Here we create simple webpage leveraging the CRM 2013 IOrganizationService web service. Here we use CRM Discovery service to create Lead in CRM programmatically from asp.net website or web application.

To create lead in CRM through programmatically create web form in your asp.net web application and use the below code.

CRUD operation in asp.net without any postback using html control

Description:-

In this example we explain that how to perform insert, update, delete operation in asp.net without any post back using HTML control.

Previously we already explain that how to perform CRUD operation in asp.net without post back on client side code. Here the concept is same but we only use HTML control not any asp.net control.

Here we use jQuery ajax web method for perform all insert, update and delete operation.so how to display data to html table control look like grid view In asp.net and perform all the operation on client side without page load or post back using jQuery ajax web method.

Implement Remember Me functionality using CheckBox ASP.Net

Description:-

In this example we explain that how to Implements remember me checkbox functionality in login page in asp.net using C#.

We all know that in every social website there is a facility for the remember me checkbox when we are login at this website. Here we create same functionality when user login, here we simply uses the cookie to store the username and password for particular user for specific time if user check mark the remember me checkbox when login. When user redirect to login page second time at that time we create code that will check the if cookie for username and password is exists then it will automatically set the username and password from the cookie in page load and user do not have to type credential for every time when they want to login to website.

So how to implement the remember me checkbox functionality in our website using cookie in asp.net.

set WaterMark Text in PDF using itextsharp in C#

Description:-

In this example we can explain that How can we create a PDF file with watermark text as a Background of the pdf  using itextsharp dll in asp.net using C#.

Generally we create simple pdf directally by exporting gridview control data to pdf but sometime we have requirement like watermark text display as background of pdf in each and every pages in our application.

Suppose if we have created one pdf report for any Honda showroom then Honda company have normally requirement like its HONDA name display as watermark text in pdf background in every pages of the pdf. Here we demonstrate set the watermark text in pdf using itextsharp in C#.

How to set Default Button in MVC Web Form Application

Description:-

In this example we explain that how set default button in mvc web application using jquery. In our asp.net website this is simply we directly set default button in any content placeholder or any container like in panel control have property of DefaultButton so you can easily set them for particular webpage.

But how to set Default Button in our MVC web application.here we demonstrate set default button in mvc using simple jquery.

How to Bind XML File data to Treeview in asp.net

Description:-

In this example we explain that how to bind XML file data to TreeView in Asp.Net or how to populating the TreeView control with XMLDataSource in asp.net.or Dynamically bind TreeView from XML file in asp.net.

Here we create a one XML file for country and it's related state and we want to bind this country and it's state to the TreeView Dynamically from the XML file.

So to do this first we have to open the XML file in read/write mode and then we have to fetch it's node one by one and binds it to the TreeView.

JQuery datepicker calender with Dropdown month and year in asp.net.

Description:-

In this example we explain that how to Display calendar with Dropdown in month and year for selecting month and year in asp.net using jquery. Or display or bind month and year in DropdownList in calendar for selecting month and year in asp.net.

We already explain that display calendar in asp.net but in simple calendar if you want select before 50 year ago year then you have to press back button of the year in calendar control many time so it is time consuming. But now in this calendar you simply directally select year that you want in dropdown inside in calendar control.