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...
22 January 2013

WCF Tutorial

›
                              WCF(WINDOWS COMMUNICATION FOUNDATION ) Introduction to WCF: Windows Communication Foundation (Code named Indig...

WCF Tutorial

›
                              WCF(WINDOWS COMMUNICATION FOUNDATION ) Introduction to WCF: Windows Communication Foundation (Cod...
20 January 2013

Image binary format c#

›
source:     <div>         <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"    ...
06 January 2013

Row to Column conversion separated delimiter in sql

›
declare @str1 varchar(max)=',,sql,,,asp,technique,yield,ado,,' declare @str2 varchar(max)='' create table #tbl1 (id varchar(...
02 January 2013

Reset Identity for the table in sqlserver

›
CREATE TABLE IdentTest (Ident INT NOT NULL IDENTITY (1,1), varfield varchar(100)) INSERT INTO IdentTest VALUES ('abc') DBCC CHECKIDE...