30 June 2014

Collections

›
using System; using System.Collections;  // for Collections using System.Collections.Generic;  // for Generics Collection classes are spec...
24 June 2014

Diff. b/w where and having in Sql Server

›
WHERE clause is used for filtering rows and it applies on each and every row, while HAVING clause is used to filter groups. We can use W...
13 June 2014

Get count of emp's under a manager in Sqlserver

›
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[emp]') AND type in (N'U')) BEGIN CREATE TABLE ...
14 May 2014

Cannot open database requested by the login. The login failed

›
This error occurs when you have configured your application with IIS, and IIS goes to SQL Server and tries to login with credentials that do...
02 April 2014

Register Framework 4 for IIS hosting

›
%windir%\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe -i
21 December 2013

Get factors of a number

›
int n = 10; List<int> factors = new List<int>(); int max = Convert.ToInt32(Math.Sqrt(n)); for (int i = 1; i <= max; i++) { ...

Difference between String and string

›
1. String stands for System.String and it is a .NET Framework type. 2. string is a type in C#. System.String is a type in the CLR. 3. string...
20 December 2013

default Timeouts in c#

›
SqlConnection.ConnectionTimeout - 15 sec - Gets the time to wait while trying to establish a connection before terminating the attempt. SqlC...

PrimaryKey vs UniqueKey

›
Primary Key: Primary Key enforces uniqueness of the column on which they are defined. Primary Key creates a clustered index on the column. P...

String Vs StringBuilder

›
System.String ------------- 1. String is immutable. It means that you can't modify string at all, the result of modification is new stri...
20 August 2013

Update alternate rows in sqlserver

›
update s set recstatus=’I’ from (select row_number() over (order by id) sno,* from mastertbl)s where sno%2=0 or with c as ( select row_numbe...
02 August 2013

Int range in .net

›
Int16 : The value of this constant is 32767 : hexadecimal 0x7FFF Int16 (or short) uses 16 bits to store a value, giving it a range from -32,...
10 February 2013

9 February

›
i). Machine. Config ii). Web.Config (For desktops app.Config) Common paints for confn files: These are simple text files & can be ed...
01 February 2013

SQL SERVER – Introduction to JOINs – Basic of JOINs

›
INNER JOIN This join returns rows when there is at least one match in both the tables. OUTER JOIN There are three different Outer Join metho...
25 January 2013

Create virtual files in asp

›
    private void virfile()     {         if (!Directory.Exists(Server.MapPath("download/")))             Directory.CreateDirectory...