Sep
24
2010

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

Consider following things for solving above problem. 1. Just go to web.config file 2. Add following code segment under configuration tag

Permalink | Comment (0)
Sep
20
2010

Cursor in MS SQL

Using Cursor in MS SQL Server 2005 or 2008 Consider following code for creating cursor declare db_cursor CURSOR for SELECT ItemSLNO FROM P_Return_ItemSLNOTraking where Com_PReturnId_ItemId = @Com_ReceiveId_ItemId OPEN db_cursor FETCH NEXT FROM db_cursor INTO @ItemSLNO WHILE @@FETCH_STATUS = 0 BEGIN SET @SLNO = @SLNO+ ‘,’+ @ItemSLNO FETCH NEXT FROM db_cursor INTO @ItemSLNO END CLOSE db_cursor read more »

Tags , | Permalink | Comments (2)
Sep
15
2010

Cannot access shared files and folders or browse computers

Most of the time I am unable to access shared files and folder from other pc. There is a service named Computer Browser stopped automatically I dont know why. But I found a solution from Microsoft site. Here is the solution:

Tags , | Permalink | Comments (2)
Sep
02
2010

ERDBManager

1. Introduction: Welcome to ER DBManager.NET®. This documentation helps you understand ER DBManager.NET® and how to integrate the library into your applications.

Tags , , , | Permalink | Comments (2)
Aug
05
2010

Split in MS SQL SERVER

Here I shall describe about split in MS SQL. There is no built in function for splitting your text, that’s why I am describing two customize function for performing split operation in MS SQL. Split function 1: This function returns table that’s why we can say it table valued function. –select * from fnSplit(’1,22,333,444,,5555,666′, ‘,’) read more »

Tags , | Permalink | Comments (3)
Aug
03
2010

STUFF IN MS SQL, Getting data from table in a single row separated by comma or other sign

Consider following SQL statement for MS SQL Select UserName from UserInfo It will return UserName Anis Hasibul If you want to get these record in following way

Permalink | Comment (1)
Aug
01
2010

The maximum report processing jobs limit configured by your system administrator has been reached

This is very common error (“maximum report processing jobs limit”) when crystal report printing job limit over We can solve this problem using two way: 1. Need to write following code on CrystalReportViewer Unload event a. Perform reportDocument Deispose b.Perform reportDocument Clone c.Perform reportDocument Close d. Perform CrystalReportViewer Dispose Code ============

Tags , | Permalink | Comments (5)
Jul
31
2010

Difference between Variable Table(@) and Temp(#) table

Table variables are Transaction neutral. They are variables and thus aren’t bound to a transaction. Temp tables behave same as normal tables and are bound by transactions. Consider Following Example —————————————–

Permalink | Comment (1)
Page 4 of 41234

« Previous Page