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