Tech Treasure

JQuery selector tutorial

2010-11-12T00:46:00.001+05:30

Today I read another god article about JQuery selector tutorial. Here is a link for that. Two great articles about JQuery in one day, amazing !!! Happy Programming !!! Chirag Darji ASP.NET Consultant & Trainer

JQuery Selector, JQuery Event Binding, JQuery “this” keyword

2010-11-12T00:39:00.001+05:30

Today while reading about JQuery I came across really helpful and well narrated article about JQuery Selector, JQuery Event Binding and use this key word in JQuery by Elijah Manor. You can read it here. Happy programming !!! Chirag Darji ASP.NET Consultant & Trainer

Find Second Saturday and Fourth Saturday of Month

2010-08-23T15:44:00.001+05:30

While analyzing Payroll management system, I came across an interesting question that how can we find second and fourth Saturday of every month. As in India we still do not have five days a week in most of organization, bad humm……:( . Most of organizations offer only second and fourth Saturday off. Below is the code to find particular day of week and its occurrence in given month and year,

Complete Installation guide for CRM 4.0 / Step by Step guide to install CRM 4.0

2010-08-07T00:16:00.001+05:30

Last week I installed Microsoft Dynamic 4.0 on my virtual machine and I found that it will be helpful for beginner like me, if there is a step by step installation guide. Lets start with OS selection. 1. You can use Windows Server 2003 or later server version. I had Windows Server 2003 R2. 2. Install latest service pack for OS you installed. 3. Install Internet Information Service.

SQL Server Date Format and Convert DateTime to particular format

2010-07-30T18:05:00.001+05:30

I was playing with different date format in SQL Server as need to display date in YYYY-MM-DD HH:MI:SS.MMM format. I knew there is a CONVERT function which can do this however I did not have the exact parameter value to convert my date to mentioned format. I got really use full chart on internet which provides different option and parameter value for CONVERT function. For my case syntax is

SQL Server – Maximum columns in Table, Maximum Columns in Group By, Cluster Index Per Table, Max Database Size, Maximum characters in NTEXT, NVARCHAR(MAX) and all maximum in SQL SERVER

2010-03-06T12:20:00.001+05:30

While reading MSDN today I came across very interested topic. This is very use full specially in interview. Link shows maximum character allow in NVARCHAR(MAX), NTEXT, VARCHAR(MAX), Maximum cluster index per table, maximum columns per table, Maximum columns per Foreign Key, Maximum Columns in Group By and so on. Here is the link from MSDN Happy Programming !!! Chirag Darji

XML Parsing Error: no element found

2010-02-17T14:38:00.001+05:30

Today while working with JQuery-Ajax, I found an interesting error. I have used $.ajax() function to retrieve data from remote page. While testing I found that the page always show error : XML Parsing Error: no element found. Error does not contain specific information about the source of error. The common reason for XML Parsing Error: no element found is missing closing tag for one or

JQuery Conflict with Mootool and other libraries !!! Use JQuery.noConflict()

2010-01-28T18:01:00.000+05:30

We all may have use JQuery in our application to build rich UI. While working with JQuery today I found that JQuery is not working on some pages where I have user mootool scripts. I search on net and found a very descriptive solution at JQuery site. According to this article the reason for JQuery conflict is the use of $ function. mootool and prototype.js files have their

Set Full Image Path in FCK Editor

2009-10-09T13:08:00.001+05:30

We have used FCK editor as an HTML editor for our recent project. It is one the best and easy to integrate HTML editor available free. When I test the editor on local server and it works fine. However when we add image using FCK editor the image path is relative to tour webpage. So if you have created an email template using FCK editor and you sends email to your customers they will not

AJAX UpdatePanel and UpdateProgress to show please wait

2009-08-21T01:34:00.001+05:30

While refreshing the AJAX skill today I wrote a simple code to display please wait message while asynchronous postback. I added one Update Panel, one Update Progress panel and a button control and registered button as Asynchronous Postback Trigger control. I assign my UpdatePanel’s id as AssociatedUpdatePanelID to UpdateProgress panel. I ran the code found that Progress panel is not

Context.RewritePath and Images

2009-08-20T01:11:00.001+05:30

I was reading articles on URL Rewriting in ASP.NET and I found the most common way suggested is to use Context.RewritePath either in global.asax file or in HttpHandler with Application_BeginRequest method. The most common found code is Context.RewritePath(NewURL). When you the application you find it works like a charm and yes it does so!!!!. However sometime Images and CSS are not

How to detect page is loaded

2009-08-13T00:34:00.001+05:30

Sometime we need to find when the page is loaded or page is completely loaded before specific java script function is called. As we all know if try to access DOM element using document.getElementBtId() before page is loaded or page is completely loaded we get error. So to prevent the error we can user following java script to detect page is loaded? 1: var body =

How to set multiple default button in ASP.NET

2009-08-11T15:28:00.003+05:30

In my previous post I mentioned the one way to set default button in ASP.NET. There are few other methods also. One of them is to use asp panel and set its DefaultButton property. When we need to set multiple default buttons on single page we can do it by using asp panels. Lets consider that you have login control and search control on same page. User must be redirect to proper page

Maintain Viewstate for Dynamic controls across the postback

2009-05-20T14:43:00.001+05:30

Most of us have faced the case when we have to load the controls dynamically. We can load user control by calling LoadControl method. To load inbuilt server controls we can use Page.Form.Controls.Add() method or we can user any container like panel or place holder and call Controls.Add() method. Upto this it looks very easy and works fine. However at first postback you either find the

Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc

2009-05-14T11:50:00.001+05:30

You may receive "Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc" while connection to database. I got the error when I tried to connect to SQL Server 2005 from Visual studio 2008 using server explorer. The exact error is, Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or

Happy Holi

2009-03-12T01:37:00.001+05:30

HOLI , a festival of color!!!!!!. This holi is the best holi I enjoyed so far. I was with my friends for whole day and we colored one another. These are my college friends Mihir - Binal, Piyush – Apeksha. We missed our two friends who are in US. SHAILESH and DIPAK. See few snaps…… Its me (Chirag Darji) !! Happy Holi !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

The current build operation (build key Build Key[Microsoft.Practices.EnterpriseLibrary.Data.Database, null]) failed: The value can not be null or an empty string. (Strategy type ConfiguredObjectStrategy, index 2)

2009-01-07T18:08:00.001+05:30

You may find this error while working with Data Application block in enterprise library. When you look into the inner exception you will find the message "The value can not be null or an empty string.". This message does not give proper information to user. When enterprise library does not find default database than it will show this error. You need to add "defaultDatabase" in

An error occurred creating the configuration section, 'Microsoft.Practices.EnterpriseLibrary,The located assembly's manifest definition does not match the assembly reference

2009-01-05T17:04:00.001+05:30

Today I was exploring Enterprise Library 4.1 and encounter this error. I created a sample application and added reference to few DLL from "EntLib41Src\bin" folder to my application. When I hit F5 to run the application I got following error, "An error occurred creating the configuration section handler for exceptionHandling: Could not load file or assembly '

Page Methods is undefined

2008-10-22T15:02:00.001+05:30

You may receive "Page Methods is undefined while calling Server Side function from Client Side Code using PageMethods in AJAX. The possible cause can be, 1. You may have not added EnablePageMethods="true" in ScriptManager tag. 1: 3: 2. You have a pre-release version of

Integrate Youtube in ASP.NET

2008-09-16T16:58:00.001+05:30

I will discuss how to integrate youtube video in asp.net. Youtube provides the API to access the its huge database of videos. It also provides search facility and customized player for integration. First thing you need is to get developer key for accessing youtube service. You can get it from here. Once you get the developer you can use the API URL to retrieve youtube videos. The

GROUP BY, CUBE, ROLLUP and SQL SERVER 2005

2008-09-09T17:59:00.001+05:30

I learn about CUBE and ROLLUP function today and I found it really usefull for generating reports. For more detail visit here. Happy Programming !!!!

How to detect browser using JavaScript

2008-09-02T17:27:00.001+05:30

As a software developers we must have to deal with javascript every now and than. There are some scripts which is browser dependent. You need to write different functions for different browsers. To achieve this you must require to detect the browser. Below code may helps you, 1: var isIE = false; 2: var isFF = false; 3: var isOP = false; 4: var isSafari = false; 5: 6:

How to Encrypt connection string in web.config

2008-08-11T15:55:00.001+05:30

The most sensitive information stored in web.config file can be the connection string. You do not want to disclose the information related to your database to all the users where the application is deployed. Every time it is not possible to have a private machine for your sites, you may need to deploy the site in shared host environment. To encrypt the connection string in above situation is

How to find duplicate values from List<> ?

2008-07-25T00:52:00.001+05:30

I have generic list say, List and I want to find the duplicate values from the List and store it in new List. There are many ways to achive this. One can loop through all the elements of List and store the duplicate in other list OR can use anonymous method to acieve same. I love the anonymous method. Here is the code to get duplicate value from List<>. 1: List

RegisterStartupScript and RegisterClientScriptBlock

2008-07-18T00:58:00.001+05:30

There two powerful methods available in dotnet two include JavaScript on page from code behind. Normally we write the JavaScript functions on aspx page however in some case we have to dynamic script which we can not write on aspx page for many reasons like the script require some data which we have to fetch from database or require some operations that can only be done from code behind.

Access Cache object of one application from another application OR share Cache object between Applications

2008-06-25T01:02:00.001+05:30

Recently while reading some forum I found an interesting question Can we share the cache object between two different applications ? More specifically can we access cache data of one application from another application ? I thought its a good topic to study and share. The answer is yes you can share the cache data between two application or you can access cache data of one

Internet Explorer contains Dipak Bhattarai in title

2008-05-14T17:58:00.001+05:30

Recently I found many pcs affected by this. You can see Dipak Bhattarai in title of every Internet explorer window. The simples solution I found to remove this is change the registry value. I am not sure that this has also added some malicious entry some where and maybe stilling or sniffing the data. However to remove name from title , Go to Start - Run - type regedit. Now go to

Generate Image from text using C# OR Convert Text in to Image using C#

2008-05-09T18:17:00.001+05:30

Today I learn a new thing, how to generate and image form given text or how to convert text in to image? Dotnet framework provides System.Drawing and System.Drawing.Graphics class which helps us to generate image from text or convert text into image. Below is the code, 1: private Bitmap CreateBitmapImage(string sImageText) 2: { 3: Bitmap objBmpImage = new Bitmap(1, 1); 4: 5

Missing templates in Visual Studio installed templates

2008-05-06T10:13:00.001+05:30

Today, when I start visual studio and click on Add new Item I found that WebForm option is missing from visual studio templates. Thanks to Eric Hammersley who gave the perfect solution. To add missing templates you need to run following command on visual studio command prompt. Close all instance of Visual Studio. Open visual studio command prompt and type,

How to Serialize Object in Dot Net

2008-05-05T11:00:00.001+05:30

What is Serialization? Serialization is the process of storing the state of an object to the stream of bytes. Using serialization one can store the object in to memory stream or file system in such a way that the original object can be retrieve from persistent medium using DeSerialization. One can make the class serialize by adding [Serializable] attribute at the top of class and the

Using CASE with ORDER BY in SQL Server

2008-04-04T13:00:00.001+05:30

Today I came to know that we can use CASE with ORDER BY clause. Its a nice functionality which helps you to avoid UNIOUN when you have to display the records in some specific order and still you need to sort them. As shown below I have created an Employee table with ID (Primary key),Name, Address and Phone columns. 1: SET ANSI_NULLS ON 2: GO 3: SET QUOTED_IDENTIFIER ON 4:

ASP.NET Internals: Viewstate and Page Life Cycle

2008-04-01T12:12:00.001+05:30

During the free time today, I was looking for some articles on ASP.NET internals. I found an awesome article about page life cycle and viewstate. Author has explained a viewstate in very detail and simple manner. You can read the article here. Happy Programming!!

IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY()

2008-03-17T23:01:00.003+05:30

A very common question during the interview is to provide difference between IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY(). All are used to retrieve the value of identity column after DML statement execution. All three functions return last-generated identity values. However, the scope and session on which last is defined in each of these functions differ: IDENT_CURRENT returns the

CLR Stored Procedure in SQL Server 2005

2008-03-12T13:15:00.001+05:30

As we all know SQL Server 2005 has CLR integrated with it. This means one can write a code in manage application and execute it SQL Server. I read about this since Microsoft has launched SQL Server 2005, however I have never used it practically till last week. Here is a complete article.

Service Unavailable error while connecting to team foundation server.

2008-02-29T17:28:00.001+05:30

You may receive "Service Unavailable" error while connecting to Team Foundation Server(TFS). I was getting this error from yesterday whenever I was trying to connect to TFS. Finally today I found the reason and solution. I had changed the password of Administrator user which I had used to configure TFS Application Pool. This has stopped the application pool as the account which is

The media set has 2 media families but only 1 are provided.

2008-02-15T12:44:00.001+05:30

You get this error while restoring the database backup file in SQL Server 2005. This is because when you took the backup your backup file is divided in more than one part and at the time of restoring the database you have not added all the parts. Lets do this practically so that you can have better idea. Take the backup of any database you have. To take the backup right click on

Query to find all the tables and columns in selected database.

2008-02-08T16:18:00.001+05:30

As a developer, it is really important for us to understand database design and underlying tables used in application. Sometime we do not have direct access to database server so that we can not open the server console and look in to the database. In this case we can take help of SysObjects, SysColumns, SysTypes tables of SQL Server 2005. These tables stores the information

Internet explorer was not able to open the Internet site. The requested site is either unavailable or can not be found.Please try again later.

2008-01-28T15:38:00.001+05:30

You may receive this error when you write a code that allows user to download a file instead of opening it in IE other browser. In my code I have to show Open/Save dialog for PDF file. I wrote the following code. 1: Response.Clear(); 2: Response.Buffer = true; 3: Response.ContentType = "application/pdf"; 4: Response.Cache.SetCacheability(HttpCacheability.NoCache); 5:

Add new document to Document Library in SharePoint using C#

2007-10-19T18:09:00.001+05:30

We are exploring SharePoint 2007 from last few days. Here is the code for adding new document to document library using C#. I have created a page with a file upload control and a button. When user clicks on button the selected document will be uploaded to specific document library. You need to add reference to Microsoft.SharePoint DLL to make this code running. if (FileUpload1.

Add aspx page to SharePoint 2007

2007-10-12T17:39:00.001+05:30

This post will show how to create aspx (web page) page to SharePoint 2007. You can find a really good article to add custom page in SharePoint 2007 site. I have shown one approach describe in above article. Create a new Web Application Project from Visual Studio 2005. You need to download web application project extension for this. Open Visual Studio 2005 and select Web

Page Ghosting & UnGhosting And effect of PageGhosting on Performance in SharePoint 2007

2007-10-12T10:50:00.001+05:30

The WSS team created a virtual path provider named SPVirtualPathProvider that is integrated into every Web application. The SPVirtualPathProvider class is integrated into the ASP.NET request handling infrastructure by the SPRequestModule. More specifically, the SPRequestModule component contains code to register the SPVirtualPathProvider class with the ASP.NET Framework as it does its

Parameter Sniffing and SQL Server

2007-09-27T16:54:00.001+05:30

Today I came to know about an interesting point "Parameter Sniffing". I search on net and found some good material and facts about it. First, what is parameter sniffing? Below is the definition which I got from here. "Parameter sniffing refers to a process whereby SQL Server's execution environment "sniffs" the current parameter values during compilation or recompilation, and passes it

HTTP could not register URL http://+:8000/. Your process does not have access rights to this namespace (see http://go.microsoft.com/fwlink/?LinkId=70353 for details)

2007-09-27T00:33:00.001+05:30

You may find this error when you try to register WCF service host using HTTP binding in windows vista. I had the same problem and I found the perfect solution here.

Value does not fall within the expected range exception while using ReportDataSource

2007-09-01T16:14:00.001+05:30

Here is my code which produce "Value does not fall within the expected range" exception. ReportDataSource objReportDataSource = new ReportDataSource("CategoryProduct"); objReportDataSource.Name = "NewDataSet_CategoryProducts"; // dsDataSet is DataSet object objReportDataSource.Value = dsData; After doing some try and error method I found that this exception

Storing and Retrieving doc/pdf/xls files in SQL Server

2007-08-31T19:14:00.001+05:30

I have explained how to store and retrieve image file in SQL Server in my previous post. I received many comments mentioning that how can we store and retrieve doc or pdf or excel (or any type of file) in SQL Server. Few friends (developers) have also posted comment that they receive only 13 byte when they retrieve stored image or doc or xls or pdf or rtf file. So I thought let be write

Great tool for LINQ Query

2007-08-30T14:41:00.001+05:30

Joseph Albahari has created a great tool for LINQ query expression. You can dwnload it from here. Happy Programmig !!

How to use transaction in LINQ using C#

2007-08-25T15:33:00.001+05:30

I installed VS 2008 beta 2 before few days and started exploring it. I looked in to the LINQ and found very interesting. LINQ generates DataContext class which provides classes and methods which is used in OR-Mapping. You can also use your own stored procedures and views with LINQ. You may require to use transaction with your own SPs for Insert, Delete or Update operations.

Raise event from user control to main page / Event delegation from user control to aspx page in ASP.NET,C#

2007-08-23T16:55:00.001+05:30

"What is delegate?" we all have faced this question in one or more interview. :) and the most common answer is "Function pointer". Here I am showing a simple example of delegate. I have one user control and one aspx page. The user control contains one button. When user click on this button I will call a method on main page using delegate. Here is my user control, <%@ Control Language="C

Application failed to initialize properly(0xcC000142). Press OK to terminate the application

2007-08-21T18:39:00.001+05:30

Hi, I am having a small issue. I am calling a console application from ASP.NET 2.0 website. Below is my code, string strPassword = Convert.ToString("Password");System.Security.SecureString ssPassword = new System.Security.SecureString();foreach (char chr in strPassword){ ssPassword.AppendChar(chr);} System.Diagnostics.ProcessStartInfo info = new

Hide console window in console application

2007-08-21T17:06:00.001+05:30

As you all know when you execute an console application it will load command prompt and shows out put. There are amny situation in which you do not want this console window to be dislayed to user while your application runing. You can do that by calling some unmanaged functions. I have used following method to do that which is posted by Brendan Grant on MSDN. using

Viewpoint content is not displayed OR Mime type for Viewpoint content

2007-08-16T12:21:00.001+05:30

We are using Viewpoint 3-D content in our LMS (Learning Management System). The content is working fine in my local machine. However when I uploaded the LMS on deployment server the contect stopped working. The content loads perfectly. User can listen the sound and can change the step and steps, however 3-D content is not visible. After doing dome google search I found about Mime type

Generate thumbnail image in dotnet

2007-08-08T17:23:00.001+05:30

If you have created any e-commerce site, you must have used thumbnail image to display product. You may have seen many sites which display thumbnail image and product description and when user click on image it shows large image of the product. You can do this by uploading two different images for each product OR by uploading a single image and runtime generate thumbnail image from

Get height and width of image / Generate image object from byte array

2007-08-08T15:56:00.001+05:30

We are storing image in database in our recent project. We do not store height and width for that image in database. After few months of deployment the client wants to display the height and width of each image while we display image. As we do not store height and width in database we need to find that runtime when we load the image from database. Below is the code that we used to

Using the inserted and deleted Tables in SQL Sever

2007-08-01T18:16:00.001+05:30

DML trigger statements use two special tables: the deleted table and the inserted tables. SQL Server 2005 automatically creates and manages these tables. You can use these temporary, memory-resident tables to test the effects of certain data modifications and to set conditions for DML trigger actions. You cannot directly modify the data in the tables or perform data definition language

Triggres in SQL Sever

2007-08-01T17:00:00.001+05:30

A trigger is single or multiple SQL statements that fires as an actionwhen event (like INSERT, DELETE,UPDATE, CREATE, ALTER, DROP) occures. You can devide tringgers in to two parts. DDL Triggers and DML Triggers. DDL (Data Defenition Language) Triggers DDL Triggers are a special kind of trigger that fire in response to Data Definition Language (DDL) statements. These

Debugging JavaScript in MAC Safari / Tool to debug JavaScript in Safari

2007-07-30T11:12:00.001+05:30

Safari has inbuilt debug menu for java script. By default it is hidden. Safari's "Debug" menu allows you to turn on the logging of JavaScript errors. To display the debug menu in Mac OS X, open a Terminal window and type: defaults write com.apple.Safari IncludeDebugMenu 1 To display the debug menu in Safari 3.0 for Windows, use a text editor to add the following to the

Session.SessionID is not unique

2007-07-28T17:17:00.001+05:30

I have seen many forums in which users are asking that Session.SessionID is not unique. You also have seen forums saying that "I am getting different value for SessionID on every page or in each post back." Yes they are correct !!!! "This is not possible. How can it be?", I know this is your reaction. We have read in all the books and seen practically that SessionID is unique, until user logs

Dispose and Finalize in Dot Net OR Maemory Management using Dispose and Finalize

2007-07-24T17:37:00.001+05:30

You can find article here Happy Programming !!

Delete single row from duplicate rows in SQL Server 2005 and 2000

2007-07-23T12:50:00.001+05:30

Lets assume that you are using SQL Server 2005 for your current project. You found that you have few rows which have duplicate data in all the columns. Lets consider that you have table name "Example" which has two columns ID and Name. CREATE TABLE [dbo].[Example]([ID] [int] NOT NULL,[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) ON [PRIMARY] Fig - (1) Create Statement

Anonymous Type in C#

2007-07-03T19:51:00.001+05:30

Anonymous types are a convenient language feature of C# and VB that enable developers to concisely define inline CLR types within code, without having to explicitly define a formal class declaration of the type. Anonymous types are particularly useful when querying and transforming/projecting/shaping data with LINQ. C# "Orcas" introduces a new var keyword that

Color Picker control in ASP.NET

2007-06-25T14:18:00.001+05:30

Recently I have to use color picker control in my project so that each user has its own UI. The best color picker example I found on blogger.com. This inspired me to create my own color picker control. You can find the user control here. Happy Programming !!

Create/Delete/View Virtual Directory or Website in IIS using C#

2007-06-20T15:28:00.001+05:30

Hi, in my previous atrlicle I show how to create virtual directory. Here I have attched the code for creating , deleteing or listing virtual directories or website in IIS using ASP.NET and C#. Code uses DirectoryService name space which allows access to Internet Information Services (IIS). The System.DirectoryServices namespace also provides access to the Active Directory. The classes

PNG issue in IE 6 or previous version

2007-06-19T16:27:00.001+05:30

In my recent project, I found a starnge behaviour of PNG file. We have created PNG files with transparent back ground for logo. Everything is working fine in IE 7 , Opera, Firefox and even in Safari. However when we saw the image in IE 6 we found a problem that it does not display as transparent back ground. Here is the PNG file with transparent back ground. Just save it to your PC and

Moving Options/values up and down in list box using javascript

2007-06-13T11:32:00.001+05:30

Recently I found a really good article on moving options up and down in list box using javascript. Here is the link. Happy Programming !!

Moving value from one list box to other list box using javascript

2007-06-13T11:27:00.001+05:30

Recent ly I found a really good article on moving value from one list box to another list box using javascript. Here is the link. Happy Programming !!

Shadow Copying

2007-06-06T14:39:00.001+05:30

A fantastic feature of ASP.NET is that the code for a Web site can be changed on the fly without shutting down the Web server. When a Web site's file is changed on the hard disk, ASP.NET detects this, unloads the AppDomain that contains the old version of the files (when the last currently running request finishes), and then creates a new AppDomain, loading into it the new

Add items in Drop Down List or List Box using Javascript

2007-06-06T13:15:00.001+05:30

I have seen lots of questions in diffrent forums for adding items in drop down list or list box using javascript. Below is the script for the same.