Friday, December 30, 2016

Sql server TRIM function

Tuesday, December 20, 2016

Sql server reverse function

Thursday, December 15, 2016

Google chart: create chart in MVC

Sunday, December 4, 2016

how to create multiselect dropdown with checkbox using Bootstrap multiselect Jquery plugin

In this article I am going to explain how to create multiselect dropdown with checkbox using Bootstrap multiselect Jquery plugin.

how to create multiselect dropdown with checkbox using Bootstrap multiselect Jquery plugin


Description:
In previous article I have explained about Dropdowncheckboxes DLL to create multiselect dropdown. Here is another option to create the same, we can use the Bootstrap multiselect Jquery plugin.

Friday, December 2, 2016

How to populate and validate Dropdowncheckboxlist custom control in asp.net

Thursday, December 1, 2016

How to display default text and image instead of empty cell in Angular UI-Grid

In this article I am going to explain how to display default text and image instead of empty cell in Angular UI-Grid.

How to display default text and image instead of empty cell in Angular UI-Grid

Description:
I am using Angular UI-Grid to display data. I want to display default text and image if any field doesn’t have any data.

Wednesday, November 30, 2016

Sql server: Insert multiple data into single table using single insert statement

Monday, November 28, 2016

Create chart using highchart in MVC

Thursday, November 24, 2016

How to create chart with database data using MVC

In this article I am going to explain how to create chart with database using MVC


Description:
I want to show state wise population of Indian states on chart. We have lot of options like jquery based high charts and Jqplot, chart control, chart web helpers etc. You can create more than 30 types of charts like area, bar, column, bubble etc. using chart web helpers. In this tutorial I am going to implement chart using web helpers.

Tuesday, November 22, 2016

How to upload and download File using MVC

Friday, November 18, 2016

How to Show message in MVC

Sunday, November 13, 2016

Sql server: get Date, Time, Day, Month, Year, Hour, Minute and Second from date

Wednesday, November 9, 2016

AngularJs : read Json or txt file and display data

In this article I am going to explain how to read JSON or txt file data and display using AngularJs.


Description:
 I have a JSON file and want to display file’s data using angularjs. We will use the get method to display data.

Tuesday, November 8, 2016

How to generate and download Json file in MVC

Friday, November 4, 2016

Bootstrap multiselect jquery plugin

In this article I am going to explain how to create multiselect dropdown with checkbox using Bootstrap multiselect Jquery plugin.

Bootstrap multiselect jquery plugin


Description:
In previous article I have explained about Dropdowncheckboxes DLL to create multiselect dropdown. Here is another option to create the same, we can use the Bootstrap multiselect Jquery plugin.

Thursday, November 3, 2016

Dropdowncheckboxlist custom control: populate from database and validate

Wednesday, November 2, 2016

How to create Dropdownlist with checkboxes in asp.net

In this article I am going to explain how to create Dropdownlist with checkboxes in asp.net.

How to create Dropdownlist with checkboxes in asp.net


Description:
Recently while working on asp.net project, I have got requirement of checkboxes inside dropdownlist. I have did R&D on it and found a DLL of DROPDOWNCHCKBOXES. It’s a custom server control.

Tuesday, November 1, 2016

Show default text instead of empty cell in Angular UI-Grid

Wednesday, October 26, 2016

How to count number of words in column using sql server

In this article I am going to explain how to count number of words in column using sql server.


Implementation:

I want to count the number of words in a column. Run the below given query to get total number of words: 

DECLARE @words VARCHAR(250)
SET @words = 'article mirror, asp.net, sql server'

SELECT LEN(@words) - LEN(REPLACE(@words, ' ', '')) + 1 as 'total number of words'

Result:

S.No.
Total number of words
1
5




Wednesday, October 19, 2016

How to display image in Angular UI-Grid

Tuesday, October 18, 2016

How to add auto increment serial number column in RDLC report

Sunday, October 16, 2016

How to change text using CSS

How to create sub report using RDLC report

In this article I am going to explain how to create sub report using rdlc report.


Description:
I want to create sub report using RDLC.

Implementation:
I have created 2 tables [districtpopulation ,StatePopulation] and insert some dummy records.

How to create sub report using RDLC report


After that create store procedure to fetch data from database.

Create proc GetStatePopulation
as begin

Select * from StatePopulation
End

Saturday, October 8, 2016

Report Viewer Configuration Error [Solved]

While working with RDLC report I have faced an error “Report Viewer Configuration Error“. Here is the complete error message:

Report Viewer Configuration Error
The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file. Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.web/httpHandlers section of the web.config file, or add <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> to the system.webServer/handlers section for Internet Information Services 7 or later.

Friday, October 7, 2016

How to create pie chart in asp.net using chart control

In this article I am going to explain how to create pie chart in asp.net using chart control.

How to create pie chart in asp.net using chart control


Description:
I want to create a pie chart to show the state wise population in percentage. I am using asp.net chart control to create pie chart.

Sunday, October 2, 2016

Sorting, Filter and Pagination with Angular UI-Grid in MVC application

Thursday, September 22, 2016

How to implement pagination and sorting with Angular UI Grid in MVC application

In this article I m going to explain how to implement pagination and sorting with Angular UI Grid in MVC application.

How to implement pagination and sorting with Angular UI Grid in MVC application


Description:
In last article of UI grid I have explained how to display records. Now I want to sort the data ascending and descending order and implement pagination. For pagination you have to set page size and enable the sorting as
            paginationPageSizes: [5, 10, 15],
            paginationPageSize: 5,
            enableSorting: true, 

Tuesday, September 20, 2016

How to Display data with Angular UI Grid in MVC application

In this article I am going to explain how to Display data with Angular UI grid in MVC application.

How to Display data with Angular UI Grid in MVC application


Description:
Here I am going to retrieve the data from database and display in Angular UI grid. You can download the UI Grid Jquery and CSS from HERE.

Monday, September 12, 2016

Sql server: Convert total number of days into month(s) and day(s)

Sunday, September 4, 2016

How to generate barcode in asp.net

Thursday, September 1, 2016

Sql server query to get exact DOB in Years, months and days

Monday, August 29, 2016

Show and hide div on one button Click using jquery

Saturday, August 27, 2016

Remove special characters (-, _,) from string in SQL SERVER

Thursday, August 25, 2016

How to create tags using Jquery in asp.net

In this article I am going to explain how to create tags using Jquery plugin in asp.net with database.




Description:
I want to add tags to each article or post. To crate tag I am using Tag-it Jqery plugin.  You can see the working example and can download the plugin From here. 

Monday, August 22, 2016

How to set color for ODD and EVEN rows in HTML Table using CSS

In this article I am going to explain how to set alternate color for ODD and EVEN rows in HTML Table using CSS.

How to set color for ODD and EVEN rows in HTML Table using CSS




Description:
I want to set alternate color on rows in HTML table. We can set using odd and even nth child selector.




Saturday, August 20, 2016

Form validation example using AngularJs with Bootstrap in MVC application

Here in this article I am going to explain how to implement Angularjs form validation with Bootstarp in MVC application

Form validation example using AngularJs with Bootstrap in MVC application


Description:
I want to validate the form on submit button. To validate I am using bootstarp with Angularjs. 

Friday, August 19, 2016

Sort and filter Grid using AngularJs in MVC

Here in this article I am going to explain how to sort and search the data in grid and also highlight the searched matched text using Angularjs in MVC application.

Sort and filter Grid using AngularJs in MVC


Description:
I am displaying the data in table using ng-repeat. I want to sort and search the data in grid also highlight the searched text results. 

Thursday, August 18, 2016

AngularJs: Search and highlight matched text in MVC application

Here in this article I am going to explain how to search and highlight the matched text using Angularjs in MVC application.

AngularJs: Search and highlight matched text in MVC application


Description:
I am displaying the data in table using ng-repeat. I want to highlight the searched text results.

Implementation:

Sunday, August 14, 2016

How to insert, update, delete and show the data using AngularJs in asp.net MVC

In this article I am going to explain how to insert, update, delete and show the data using AngularJs in asp.net MVC.

How to insert, update, delete and show the data using AngularJs in asp.net MVC



Description:
In this angularjs tutorial I am going to perform create, read, update and delete (CRUD) operations.

Implementation:

Tuesday, August 9, 2016

Sql Server: Calculate Age in years from Date of Birth (DOB)

In this article I am going to explain how to calculate the age in years from given Date of Birth in Sql.


Implementation:

You can calculate the age from DOB using below given methods:

Monday, August 8, 2016

AngularJs: Show default image with asp.net mvc

In this article I am going to explain how to show default image if image is missing or not uploaded using angularjs with asp.net mvc.


Description:
I am displaying the employees detail like name, phone number, email, profile pic etc. in Grid using ng-repeat. If users do not upload profile pic or missing, in that case show default image.

Implementation: