Cannot ALTER TABLE in MS SQL 2008/SQL2008 R2/SQL2012

Cannot ALTER TABLE in MS SQL After installing ms sql 2008/2012 you may face new problem which may protect you to alter any table. Something like following There is a new option added in SQL Server 2008/2012 for modifying tables while using the Table Designed in Management Studio which will prevent saving any changes to read more »

A curry of Dependency Inversion Principle (DIP), Inversion of Control (IoC), Dependency Injection (DI) and IoC Container

A curry of Dependency Inversion Principle (DIP), Inversion of Control (IoC), Dependency Injection (DI) and IoC Container using C#. Dependency injection using C#. Inversion of control using C#. IoC using C#. Download sample – 77 KB

Delegate in C#

Delegate in C# I am not going to write formal definition here because you will find lots of definition of delegate by googling. Most of the time, new developer faces problem with delegate. They think actually what it is and why they use it instead of method. In simple word: What is Delegate? Delegate is read more »

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 read more »

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 read more »

How to Solve If Crystal Report 13 does not show Printing Dialog or Export report dialog.

Sometimes it shows that Crystal Report runs properly but its printing dialog, export report dialog doesn’t work properly and also going next page doesn’t work. Doesn’t work means if i press print button it doesn’t perform any action. How to Solve If Crystal Report 13 does not show Printing Dialog or Export report dialog. Crystal read more »

Crystal Report Error: BOBJ is undefined

Last day i faced a problem with Crystal Report. It shows BOBJ is undefined. When i run my asp.net application using IE then it shows Java Script Error and the error is “BOBJ is undefined”. When i run my application using Fire fox then it doesn’t shows any crystal report. So here is solution: After read more »

Using Crystal Report in ASP.net MVC and creating generic report viewer

Download Project This article describes how to show crystal report in ASP.net MVC. Here I will describe two different ways for showing crystal report in MVC. 1. Showing crystal report using ASP.net web forms in MVC.     A. In same window     B. In different window 2. Showing crystal report from Controller/action (by read more »

Different types of SQL Command ( DDL, DML, DCL and TCL) // Difference between DML, DDL and DCL

DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:

How to solve ” Could not load file or assembly ‘…’ or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0×80070057″ Error

Last day I have faced an error when I am compiling my ASP.net MVC application and this is for illegal shutdown of my computer. Here is my Error: ” Could not load file or assembly ‘EntityFramework’ or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0×80070057 “ Similar types of Error: “Could read more »

Page 1 of 41234