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: CREATE – to create objects in the database ALTER – alters the structure of the database DROP – delete objects from the database TRUNCATE – remove all records from a table, including all spaces allocated for the records

Read More

How to solve ” Could not load file or assembly ‘…’ or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057″ 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: 0x80070057 “ Similar types of Error: “Could

Read More

Master Detail CRUD Operations using ASP.net MVC 3 and EF

Master Detail CRUD Operations using ASP.net MVC 3 and EF. Master detail in asp.net mvc Introduction In this post I will discuss about how we can perform Master Detail CRUD Operations using ASP.net MVC 3 and Entity Framework (Code First).  Here I have used JSON (json2.js)  for data passing, Ajax for posting and DataTables (datatables.js) for

Read More

Achived Microsoft Community Contributor Award – 2011

I am very glad and honored to share this with all of you that my community contributions have been recognized by Microsoft. I(Mohammad Hasibul Haque) have received the Microsoft Community Contributor Award 2011. Details about Microsoft Community Contributor Award Through the Microsoft Community Contributor Award, we express our thanks to individuals who freely volunteer their

Read More

Calculate Execution and Cpu Time in SQL 2005

SET STATISTICS TIME ON Select * from TableName — Or Any Query SET STATISTICS TIME OFF It Results: =============== SQL Server parse and compile time: CPU time = 31 ms, elapsed time = 141 ms. SQL Server Execution Times: CPU time = 0 ms, elapsed time = 1 ms. (49 row(s) affected) SQL Server Execution

Read More

Dynamically add and delete row from html table using jQuery

Here we will use jQuery for Row insertion and deletion. Adding New row: Consider we have following HTML table with ID=”tbl” ID Name Age Action ID Name Age If we want to insert row then we have to add new row to the table. We can add table row in following way. var nrow =

Read More

Saving change is not permitted MS SQL 2008/ SQL 2008 R2

By default saving changes on a table is is blocked. When we want to change or alter any Table Then it shows following message Saving change is not permitted. the changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that cant be re-created

Read More