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.

 

Highlight Saturday,Sunday or weekend dates in calendar control in asp.net

Description:-

In this example we explain that how to Highlight Saturday,Sunday weekend dates in calendar control in asp.net C#, VB. Or Disable weekend dates or saturaday Sunday in calendar in asp.net. this is very useful example when you want to user enter only working hours date not holiday dates. So you can highlight or disable weekend dates or saturaday and Sunday in calendar as per your requirement. So there are multiple ways to highlight or disable or checked weekend days in calendar are as follows.

how to show print button in report viewer in chrome and mozila firefox in asp.net

Description:-
 

In this example we explain that how to show print button in Report Viewer. I also face that problem like report viewer print button is not showing in fire fox and chrome browser by default it will show in Internet Explorer. Or print button not visible in report viewer for mozila fire fox and chrome browser.  So how to display print button in report viewer that display in all browser like browser comp ability code for report viewer print button so it will work for the all the browser.

How to validate dynamically created control in asp.net

Description:-

In this example we explain that how to validate Date format in dd/mm/yyyy in asp.net C# backend code at runtime validation using Regex validator provided by .Net Framework.

We all know very to validate any like Date, only number, required validation, and Range validation is easily at client side but my problem is that it will be validated by runtime.

For example in my real project in which one form name like create report in which form one is dropdown and its contain three items like string, integer and Date. And second control is textbox and one submit button. Now condition is that if user select string item from dropdown list then only string are allow to enter in below Textbox control same like if user select Date item from dropdown list then only user allow to enter Date only and it also in dd/mm/yy format and same for Integer items. So it is difficult task to validate at runtime for me at first time. And then finally I got the solution are described bellows.

how to Create RSS feed Using Asp.net using C#

Description:-

In this example we explain that how to create RSS fied or create sample of the RSS fied in asp.net using C#.

First of all what is RSS. Its stands for “Realy Simple Syndication”. RSS are generally used to solve problems for users that regularly uses the internet’s provide user to easily stay informed by retrieving the content from the websites or any blogs in which you are interested. User can save the time by using RSS facility you do not need to visit each website individually.

date/time entry functionality in input field using jQuery spinner

Description:

In this example we explain that how to create the date/time entry functionality can easily be added to an input field or textbox in asp.net using jQuery or JavaScript. Or create input field time format using jQuery.

Here user can insert time into textbox but here AM and PM is default you select it but you cannot edit AM or PM with other value.

Here we demonstrate the Time Entry is a jQuery time plugin that enables your input field or textbox to accept a time value using a spinner.here you have to create one .js file and put the below code in it.

how to merge cells in gridview in asp.net using C#

Description:

In this example we explain that how to merge cells in gridview in asp.net. Or Merge Cells Columns in Row of GridView. Merge GridView Cells or Columns in a Row in ASP.Net using C#.

Here we use ondatabound event of the gridview to merge the common cells in one cell in gridview in asp.net. Here we counting total rows in gridview and then checking each cells value against value of same cell in previous row and then setting the RowSpan of cells.

Many time there is a situation when gridview contain same values for a column in multiple rows.so this repeated items are displayed in one time and merge cells.

Here we demonstrate merge cells in gridview that has same value in asp.net or how to merge all rows in a coloumn in a gridview in asp.net

moving rows of DataTable up and down in asp.net using C#

Description:-

In this example we explain that how to move rows up and down in datatable in asp.net. or Moving row of a DataTable up and down. Or interchange the position of DataRow in DataTable or change the index or position of the datarow in datatable in asp.net.

Sometime You will need to add an Order column, and assign the DataGrid with a DataView sorted by the Order column. In order to switch the position of rows, you will need to set the Order value of each row.

That was the real problem that I was faced before sometime and then now I wil solved it.my problem was that I want to arrane thje datarow in datatable. In my datatable's one coloumn is that "colorarea". And if colorarea's value in datarow is "cell" then its position remain same in datatable but colorarea's value is "row" then it's datarow position are moved to the last position of the Datatable rows.

So how to handle that's type of situation and so far we will demonstrate to move or change the position of the datarow in datatable in asp.net using c#.

Auto Increment Row Value In Asp.net MVC WebGrid Using C#.Net

Description:-

In this example we explain that how to auto increment Row value of web grid in mvc with asp.net. Or auto generates Row value in web grid in mvc or auto generate column for web grid in mvc that define the SR No in web grid in mvc with asp.net.

In simple grid view with asp.net we all know that how to add auto increment row value in simple asp.net grid view but when we are work in mvc architecture at that time how to auto increment row value of web grid in mvc.

Dynamically Bind Data in Ajax Accordion Panel Bind Data to Accordion from databse

Restrict the size of File when Uploaded How to Restrict the size of File when uploaded by user

increase number when I press arrow key on keyboard with javascript or JQuery.

Description:

In this example we explain that how to increase or decrease the value of the list based on arrow key press event using JavaScript or jQuery in asp.net.

I have faced live issue like I have requirement like I have one textbox with two arrow button up and down inside the textbox has a numeric value. Now what I want is to keep increasing that numeric value of textbox while I am pressing and holding any of arrow keys. If I press up arrow key then value must be increased by 1 and when I pressed down arrow key the value must decreased by 1. Also I have requirement like user cannot directly input value in textbox he/she do only by using up and down arrow key.

Dynamically Bind Data in Ajax Accordion Panel Bind Data to Accordion from databse

Restrict the size of File when Uploaded How to Restrict the size of File when uploaded by user

Finally I got the solution here we define the code for increase/decrease value based on arrow key using JavaScript and jQuery in asp.net as follows:

How to Create or Overwrite Text file in app.net using C#

Description:-

In this example we explain that how to create text file in asp.net or write data to the text file fetching from the database.

Here generally we create new file and write data to text file from the database.below is code for creating text file and write data to it.

how to create excel sheet file using NPOI dll in C# asp.net

Description:-

In the example we explain that how to create excel sheet file using NPOI dll in C# asp.net or how to export data to excel sheet file using NPOI in C#.

There is a multiple way to export data in excel sheet file here we use NPOI dll to easily create or export data to excel sheet file.

You can easily format each cell of the excel sheet file save the file give the name of the excel sheet tab and add multiple sheet in current excel file using NPOI dll.

So here explain how to export data to excel sheet file in C# asp.net using NPOI dll.

You have to download NPOI dll and assign reference to the project in bin folder. And use the namespace like.

How to Access Parent Page (.aspx) control (IDs) from its child User Control (.ascx) in asp.net

Description:-

In this example we explain that how to access .aspx page in UserControl (.acsx) page. Or how to pass .aspx page value to UserControl (.ascx) page in asp.net.

There is a live requirement that we need sometime and at that time we confused that how to use this all value that is in ASPX page to UserControl. So there are two way to use aspx page value in usercontrol page.by using public properties and second is page item collection.

Using Page Item Collection

There is new item collection packed with Page object from 2.0 framework. We can also use this collection to pass objects to usercontrols.

Note:

We can also use HttpContext objects item collection for this.

how to add dynamically add rows to grid view using jquery in asp.net

Description:-
In this example we explain that how to add dynamically add rows to grid view using jquery in asp.net. Or dynamically add rows to grid view when click on add button in asp.net.

Here we use explain dynamically add rows to grid view at client side without post back using jquery in asp.net.

Here we take three textbox in which you enter data and click on submit button then this data will be added as a row in a grid view using jquery without post back at client side.

how to validate checkbox is checked in a sequence order or not. Or validate checkbox selection in sequence order using jquery

Description:-

In this example we explain that how to validate checkbox is checked in a sequence order or not. Or validate checkbox selection in sequence order using jquery.or jquery getting sequence number from selected checkbox on checkbox list.or checkbox validation in asp.net using javascript or jquery.

 

I have faced real problem in my application like in my application one form contain four checkbox year1, year2, year3 and year4. In which condition is that user can select checkbox of the year must be in sequence order like 1,2,3,4. If user select year2 checkbox and year1 checkbox is not checked then alert message will be display like please select year checkbox in sequence order.

 

So how to achieve this at client side using JavaScript or jquery.

how to add dynamically add rows to grid view using jquery in asp.net

Description:-

In this example we explain that how to add dynamically add rows to grid view using jquery in asp.net. Or dynamically add rows to grid view when click on add button in asp.net.

Here we use explain dynamically add rows to grid view at client side without post back using jquery in asp.net.

Here we take three textbox in which you enter data and click on submit button then this data will be added as a row in a grid view using jquery without post back at client side.

how to load html page in div tag dynamically using jquery in asp.net

Description:-

In this example we explain that how to load html page in div tag dynamically using jquery in asp.net.or dynamically load page in DIV using jquery in asp.net.

Here we use jquery Load () method to load page dynamically inside the DIV tag using jquery. Generally Load () method load the data form the server and that data you can put inside any element in jquery.

Convert Text to Uppercase While Typing in Textbox

Description:-

In this example we explain that how to convert text to uppercase while typing or entering text in textbox. Or how to make character uppercase when you enter text in textbox.

We all show that in many websites there is a many field have a this facility like in your First name and Last name you fill up the form this two field automatically get uppercase text . So achieve this type of facility in your application you should follow the following code.

display Google maps inside the modal popup using jquery in asp.net.

Description:-

In this example we explain that how to display Google maps inside the modal popup using jquery in asp.net. Or display Google maps of any location inside jquery dialog modal popup.

Here we use Google API to display Google maps in a modal popup.

You can display Google maps of your Location by just adding your location Latitude and Longitude in a method.

You can easily find Latitude and Longitude of your location by using this link

http://universimmedia.pagesperso-orange.fr/geo/loc.htm

display multiple images preview before upload in fileuplaod in asp.net using JavaScript and jquery.

Description:-

In this example we explain that how to display multiple images preview before upload in fileuplaod in asp.net using JavaScript and jquery. Or display preview list of the selected images or browse images before upload in file upload control at client side using JavaScript/jquery.

In many website that provide preview facility before upload the file and that is really useful because user can easily show that which images or file that he/she was uploaded.

Here we provide multiple files preview facility before file upload without any post back using JavaScript and jquery.

how to display child record of the table in a single column as a CSV format in sqlserver

Description:-

In this example we explain that how to display child record of the table in a single column as a CSV format in sqlserver. Or how to display list of state under a country in a single column as a CSV format.

Sometime you have a real this type of requirement in your project in which you have to display data in grid like one column for country name and second column for state. But at that time in a single country there are multiple state under single country so better ways to display state is in single column separated by comma.

Capturing multiple IDENTITY values after inserting into SQL Server table

Description:-

In this example we explain that how to fetching or gets multiple IDENTITY values after inserting record in sql server table.

Generally we have a situation where we need get IDENTITY of the last inserted record and this is simply achieved by using SCOPE_IDENTITY(), @@IDENTITY and IDENT_CURRENT() functions provide by sql server.

But when we want to capturing multiple IDENTITY values after inserting multiple record at that time this all function will not satisfy our condition.so  how to achieve this follow the below post.

insert into demo(name) values('pavan')

you can easily fetch this last inserted  record id by following query.

SELECT @@IDENTITY

But after inserting multiple record how can you fetch or capture the IDENTITY of the last inserted records.

select * from demo

then fire this query like

DECLARE @DEMOTABLE TABLE ([id] INT,[name] VARCHAR(100));

INSERT INTO [DBO].[Demo]

(

[name]

)

OUTPUT INSERTED.[id],INSERTED.[name]

INTO @DEMOTABLE ([id],[name]) select name from demo

Now if you want to fetch all IDENTITY that inserted at last query then you can easily fetch by using this query.

SELECT [id],[name] FROM @DEMOTABLE

when you fire above query it will return Id 9 and 10 both.

How to validate end date greater than start date in asp.net using jquery.

Description:-

In this example we explain that how to validate end date should be greater than start date and allow user to select only dates within range of dates using jquery date picker in asp.net. Or how to validate End date should be greater than Start date when using two query Date Pickers

Here we explain that how to disable all previous dates from the date picker based on the start date selected by the user from the date picker. Here we disable the dates that is lower than the start date when user is select the end date from the jquery date picker.

Sometime you have requirement like you have two date pickers for select the start date and end date. Once you pick a start date, then you want to grey out or disable all previous dates on the date picker for the end date field.so how to achieve this thing.

Add /nsert Items to ASP.Net ListBox using JavaScript and jQuery

Description:-

In this example we explain that how to Add or Insert Items in List box using JavaScript or query in asp.net. Or how to add or Insert Items in list box at client side without postbox.

Here we have one tax box and one add button. When any item enter in textbox and click on add button then this items are inserted to the list box at client side without post back using JavaScript/query.

How to add /insert Items to ASP.Net List Box at client side using JavaScript and query. The value from the Textbox will be added to the ASP.Net List Box control using JavaScript and query.

How to create JQuery Auto Complete textbox in asp.net

Description:-

In this example we explain that how to create autocomplete textbox using jquery in asp.net. or how to populate JQuery UI Autocomplete TextBox.

Here we create autocomplete for textbox not from the database but create when user enter any value or words in textbox and click on save button then it will automatically bind this value to the textbox as an autocomplete item.

We also maintain autocomplete different from each browser means mozila’s autocomplete value not show in chrome and chrome autocomplete value not show in mozila.

We also explain that how to push or insert autocomplete item to the textbox and retrieve it.

Here below is code to create autocomplete textbox using jquery.

send email with read receipt and delivery notification in asp.net

Description:-

            In this example we explain that how to send email with read notification and delivery receipt or sending mail using read notification and delivery receipt in asp.net using c#.

What is Read Notification in email:-

            Read notification means when you send the mail anyone one and then it received but we cannot judge that our sent mail is read by receiver or not so when you send mail with mail Read Notification checked then it will direct ally resend mail to you that user is reading your mail.

What is Delivery Receipt in email:-

            Delivery receipt are used to know that our mail is send to the user successfully or not.