Monthly Archives: April 2013

How to increase the performance of Stored Procedure

To increase the performance of stored procedure we need follow certain steps Ref:http://www.SqlAuthority.com 1. Include SET NOCOUNT ON statement CREATE PROC dbo.ProcName AS SET NOCOUNT ON; –Procedure code here SELECT column1 FROM dbo.TblTable1 — Reset SET NOCOUNT to OFF SET NOCOUNT OFF; GO 2. Use schema name with object name SELECT * FROM dbo.MyTable — […]

Compression of ViewState

View State is a client side state management.The View state will maintain all controls data on your application with respect to subsequent postback made to server by your application.As per as you have a limited amount of controls on your page vewstate is not a problem but when you have more server controls on your […]

Why we can’t create object for static class?

When i was attending my first interview in my current company this question was asked by my technical manager to me.I answered like others because the class has static keyword so we can’t create object for the class. Again he asked but why we can’t create object to the class declared as static.Then later i […]

What To Adopt — Veg or Non-Veg

Now a days I am finding some common debut is going on amongst the people that what should we adopt too either veg or non-veg. Many people are now and then migrating themselves from non-vegetarian to vegetarian I don’t know what making them to do like this but they are doing. I observed people those who are […]

I Love Books

One day actually I was watching one Hindi movie named “Ajab prem ki ghazab kahani” I think many of you might have known about this movie acted by Katrina Kaif and Ranbir Kapoor. In this movie I liked one dialogue said by Katrina on books let me translate the dialogue in English “The books are […]

Bind Data to ASP.Net gridview using MongoDB

I have created a simple demonstration program to show how we can bind data from Mongo to gridview. Here we go through code… Create Database Connection /*create separate for connection object */ using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Configuration; using System.Data.SqlClient; using MongoDB.Driver; using MongoDB.Driver.Builders; using MongoDB.Bson; namespace Gridcontrol.Mongodb { public static […]