C# - Difference between Array and Arraylist in C# with Example

Introduction:

Here I will explain difference between array and arraylist in c#.net with example.  

Description:

In previous posts I explained difference between wcf and web application, interview questions in asp.net, sql server, c#, Difference between functions and stored procedures in SQL Server, difference between len and datalength in sql server and many articles relating to interview questions. Now I will explain difference between array and arraylist in c#.net with example.

SQL Server - Can Function Return Multiple Values in SQL Server 2008

Introduction:

Here I will explain how SQL Server function will return multiple values in SQL Server 2008 or return multiple values from SQL user defined function in SQL Server 2008.    

Description:

In previous posts I explained SQL Server difference between view and stored procedure, SQL Server split function example to split comma separated string, SQL Server update statement with inner joins, interview questions in asp.net, sql server, c# and many articles relating to SQL Server. Now I will explain how SQL Server function will return multiple values in SQL Server 2008.

SQL Server- Difference between View and Stored Procedure

Introduction:

Here I will explain difference between SQL SERVER view and stored procedure in SQL Server 2008.  

Description:

In previous posts I explained difference between wcf and web application, interview questions in asp.net, sql server, c#, Difference between functions and stored procedures in SQL Server, difference between len and datalength in sql server and many articles relating to SQL Server. Now I will explain the differences between SQL view and stored procedures.

Difference between Asp.net SessionState and ViewState in C#, VB.NET

Introduction:

Here I will explain what is the difference between viewstate and sessionstate in asp.net using c#.net and vb.net.

Description:

In previous posts I explained convert.tostring() VS .tostring(), web application VS website, difference between datareader, dataadapter and dataset, difference between tinyint, smallint, int, bigint and many articles relating to asp.net, SQL Server. Now I will explain the difference between viewstate and sessionstate in asp.net using c#.net and vb.net.

C# - What is the Difference between Const and Readonly

Introduction:

Here I will explain what are the differences between const and readonly in c#.net and vb.net.

Description:

In previous posts I explained convert.tostring() VS .tostring(), web application VS website, difference between datareader, dataadapter and dataset, difference between tinyint, smallint, int, bigint and many articles relating to asp.net, SQL Server. Now I will explain the difference between const and readonly in c#.net and vb.net.

C# - Difference between Webservice and WCF in Asp.net

Introduction:

In this article I will explain difference between webservice and wcf in asp.net.

Description:

In previous post I explained Difference between convert.string and .tostring(), difference between web application and website and many articles relating to Interview Questions in asp.net, SQL Server. Now I will explain difference between webservice and wcf in asp.net.

C# - Difference between Convert.tostring and .tostring() method Example

Introduction:

In this article I will explain differences between .tostring() and Convert.tostring() in asp.net.

Description:

In previous post I explained difference between web application and website, difference between datareader, dataadapter and dataset, difference between tinyint,smallint,int,bigint and many articles relating to asp.net, SQL Server. Now I will explain differences between .tostring() and Convert.tostring() in asp.net.

Asp.net Difference between Website and Web Application in C#, VB.NET

Introduction:

Here I will explain the differences between website and web application in asp.net.

Description:

In previous posts I explained Difference between appsettings and connectionstrings, Difference between datareader,dataset and dataadapter and many articles relating Interview Questions in asp.net. Now I will explain the differences between website and web application in asp.net.

Generally whenever we are trying to create new web project in visual studio we will fund two options ASP.NET Web Application and WebSite. What is the difference between these two which one we need to select to create project in asp.net?

Asp.net Difference between DataReader and DataSet and DataAdapter in C#, VB.NET

Introduction:

In this article I will explain difference between datareader, dataset and dataadapter in asp.net.

Description:

In previous posts I explained Interview Questions in asp.net,C#,SQL, difference between Executereader, ExecuteNonQuery and ExecuteScalar, difference between Len and DataLength functions, difference between int,tinyint and bigint and differences between char, varchar and nvarchar in SQL Server. Now I will explain difference between datareader, dataset and dataadapter in asp.net

Asp.net Difference between appSettings and Connection Strings in web.config

Introduction:

In this article I will explain the differences between appsettings and connection strings in web.config using asp.net.

Description:

In previous posts I explained Read or Write appsettings from web.config, Read/Write connection strings in web.config. Now I will explain differences between appsettings and connection strings in web.config using asp.net.

In many cases, we need to use some data string throughout the application simple example for this database connection string. Instead of writing the same connection string wherever required, it is easy to maintain if we store it in one place that is web.config file.

SQL Server - Differences between Functions and Stored Procedures

Introduction:

Here I will explain the difference between stored procedure and function in SQL Server.

Description:

In previous posts I explained difference between Left Join and Left Outer Join, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between stored procedure and function in SQL Server.

SQL Server- Difference Between Full Outer Join and Cross Join

Introduction:

Here I will explain what is the difference between cross join and full outer join in SQL Server.

Description:

In previous posts I explained difference between Left Join and Left Outer Join, difference between ExecuteNonQuery, ExecuteReader, ExecuteScalar, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between cross join and full outer join in SQL Server.

SQL Server- Difference Between Left Outer Join and Right Outer Join

Introduction:

Here I will explain differences between left outer join and right outer join in SQL Server.

Description:

In previous posts I explained difference between ExecuteNonQuery, ExecuteReader, ExecuteScalar, Difference between Len and DataLength and many articles relating to SQL Server. Now I will explain the difference between left outer join and right outer join in SQL Server.

SQL Server- Difference Between Left Join and Left Outer Join

Introduction:

Here I will explain the difference between LEFT JOIN and LEFT OUTER JOIN in SQL Server.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain the difference between left join and left outer join in SQL Server.

Actually this one is very simple question but many of beginners are asking the same question that’s why I decided to write an article on it. Basically there is no difference between LEFT JOIN and LEFT OUTER JOIN both are same. Whenever we use LEFT JOIN keyword in SQL Server that is the LEFT OUTER JOIN only  

Difference between Left Join,Right Join,Cross Join,Inner Join,Full Outer Join,Self Join in SQL Server

Introduction:

Here I will explain the differences between Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server.

Description:

In previous posts I explained many articles relating to SQL Server. Now I will explain the differences between Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server. To know about the difference between all the joins check this article

Left Join, Right Join, Cross Join, Inner Join, Self Join, Full Outer Joins in SQL Server

Differences between ExecuteReader, ExecuteNonQuery AND ExecuteScalar

Introduction:

In this article I will explain differences between executereader, executenonquery and executescalar in asp.net.

Description:

In previous posts I explained difference between Len and DataLength functions, difference between int,tinyint and bigint and differences between char, varchar and nvarchar in SQL Server. Now I will explain difference between executereader, executenonquery and executescalar in asp.net

Difference Between LEN and DATALENGTH Functions in SQL Server

Introduction:

In this article I will explain differences between Len() and DataLength() functions in sql server.

Description:

In previous post I explained differences between char, varchar and nvarchar, difference between tinyint,smallint,int,bigint and many articles relating to SQL Server. Now I will explain differences between Len() and DataLength() functions in SQL Server.

Difference between bit tinyint smallint int and bigint datatypes in SQL Server

Introduction:

In this article I will explain what is the difference between bit, tinyint, smallint, int and bigint datatypes in SQL Server.

Description:

In previous post I explained Differences between char, varchar and nvarchar in SQL Server and many articles relating to SQL Server. Now in this article I will explain what is the difference between bit, tinyint, smallint, int and bigint datatypes in SQL Server.

how to return multiple values from stored procedure in sql server

Introduction:

In this article I will explain how to create a stored procedure to return value or multiple values in SQL server.

Description:

In previous post I explained how to write stored procedure to return output parameter values in sql server and many articles relating to SQL Server. Now I will explain how to create a stored procedure to return values in SQL Server. To implement this concept first design table in database and give name as UserDetails as shown below

Difference between char varchar and nvarchar in sql server

Introduction:

In this article I will explain what is the difference between char, varchar and nvarchar in SQL Server.

Description:

In previous post I explained many articles relating to SQL Server. Now I will explain the differences between char, varchar and nvarchar in SQL Server. Actually one of blog reader has asked me question regarding differences between varchar and nvarchar at that time I decided it’s better to write article on this topic.

Char DataType

Char datatype which is used to store fixed length of characters. Suppose if we declared char(50) it will allocates memory for 50 characters. Once we declare char(50) and insert only 10 characters of word then only 10 characters of memory will be used and other 40 characters of memory will be wasted.