Crystal report shows a blank page in ASP.net

Sometimes asp.net web page shows blank page although it is consist of Crystal report viewer.

Cause of Problem

  • Using client tools (debug window of your browser) or server tool (IIS log) you will find that some files (crv.js , style.css ) are not served;
  • these files are placed by CR installer in wwwroot\aspnet_client folder but they cannot be reached;
  • If you installed your application in a website different from Default WebSiteaspnet_clientfolder is not placed inside that website
Solution

Continue reading

Creating generic method or extension for searching through all the columns in DataTable in C#

Few days ago I worked on a project where database table has more than 80 columns. My client asked to create a search so that it can search through all the columns. So I have decided to create an extension method which will search through all the columns in DataTable. Creating generic method or extension for searching through all the columns in DataTable in C#.

It is difficult to write a SQL query (when table has many columns) which will search through all the columns.

Continue reading