Local Temp Table vs Global Temp Table

Local Temp Table vs Global Temp Table

S.No	Particulars	Local Temp Table	Global Temp Table
1	Available	SQL Server session or connection (means single user)	all SQL Server sessions or connections (means all the user).
2	deleted	These are automatically deleted when the session that created the tables has been closed	These can be created by any SQL Server connection user and these are automatically deleted when all the SQL Server connections have been closed.
3	stared with sign	Local temporary table name is stared with single hash ("#") sign.	Global temporary table name is stared with double hash ("##") sign.

Object Oriented vs Object based Language

Object Oriented vs Object based Language

S.No	Particulars	OOL[Object Oriented Language]	OBL[Object Based Language]
1	Support	All Features of OOPS	All feature of OOPS
2	Built Object	No	Yes
3	Languages	C,C#,Java	VB,Javascripts

ASP.Net Web API vs ASP.NET MVC

ASP.Net Web API vs ASP.NET MVC

S.No	Particulars	ASP.NET WebAPI	ASP.NET MVC
1	Create Web App	create full blown HTTP services with easy and simple way that returns only data not view.	returns both views and data
2	support content-negotiation	Yes	No
3	returning data	JSON,XML or any other based upon the Accept header in the request and you don't worry about that.	JSON format using JsonResult.
4	request are mapped	actions based on HTTP verbs	mapped to actions name.
5	assembly	System.Web.Http	System.Web.Mvc
6	mixed MVC and Web API controller	Web API since boths are different.	implement the authorization then you have to create two filters one for MVC

Split Web Page Extention using C#.Net

Split Web Page Extention using C#.Net
using System.Text.RegularExpressions;

string  splitWebPageExtension(string webPage, string extension,int idx)
        {

            Regex Splitter = new Regex(extension);
            String[] Parts = Splitter.Split(webPage);
            string st = Parts[idx];
            return st;
        }
     string webPage = "http://dotnettechrocks.blogspot.in/ ";
     string str = splitWebPageExtension(webPage, ".in", 0);
     MessageBox.Show(str);

Result :http://dotnettechrocks.blogspot

Cluster vs NON-Cluster Index

Cluster vs NON-Cluster Index

S.No	Particulars	Cluster	NON-Cluster
1	data rows	sort and store the data rows in the table or view based on their key values.	have a structure separate from the data rows.
2	Read	Faster to read than NON-Cluster
3	Store	Physically, Store Index Order
4	Faster Insert/Update		Qucikly Insert and Update Data than a Cluster Index.
5	Table	Only One Per Table	can be used many time per Table
6	Order	Data is in Physical Order	Logical Order

Function vs Methods

Function vs Methods

S.No	Particulars	Funciton	Methods
1	independent existence	they can be defined outside of the class	they are always defined with in class
2	languages	Structure languages	object oriented languages
3	independently	called independently.	called using instance or object.
4		Functions are self describing unit of code.	Methods are used to manipuate instance variable of a class

Web Services vs WCF

Web Services vs WCF

S.No	Particulars	Web services	WCF
1	Support SOAP	Yes	Yes
2	Support	HTTP	TCP, HTTP, HTTPS, Named Pipes, MSMQ.
3	Return Data	XML	XML
4	Open Source	No, can be consumed by any client that understands xml.	No, can be consumed by any client that understands xml.
5	Host	only IIS	IIS or Windows Services

Create Directory Date Format in C#.Net

This is a Code for "Create Directory Date Format in C#.net"

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.IO;
 namespace GetOfficeVersion
 {
class ClsDirectory
 {
 public static void CreateDirectory(string DesignationPath)
 {
 if (!Directory.Exists(DesignationPath))
 {
 Directory.CreateDirectory(DesignationPath);
 }
 }
 public static string currentYear()
 {
 string Year = string.Empty;
DateTime dt = DateTime.Now;
string format = "yyyy";
 Year = dt.ToString(format);
 return Year;
 }
 public static string currentMonth()
{
 string Month = string.Empty;
 DateTime dt = DateTime.Now;
 string format = "MM";
 Month = dt.ToString(format);
 return Month;
 }
 public static string currentDate()
 {
string day = string.Empty;
 DateTime dt = DateTime.Now;
string format = "dd";
day = dt.ToString(format); return day;
}
}
}

Model View Controller

Today, we see What is mean by MVC [Model View Control]
Model:

1.  Model is basically a C# or VB.Net Class.
2.  Model is accessible by Both Controller and View.
3.  Model can be used to pass data from Controller to View.
4.  View can use model to display data in Page.

View:

1.   View is an ASPX Page without having a Code Behide file.
2.   All Pate specific HTML generation and formatting can be done inside view.
3.   One can use inline Code(Server tags) to develop dynamic pages.

Controller:

1.   Controller is a basically a C# or VB.net class which inherits System.MVC.Controller.
2.   controller is a Heart of Entire MVC Architecture.
3.   Inside Controller's Class action methods can be implemented which are responsible to responding to browser or calling views.
4.   Controller can access and use model class to pass data to views
5.   Controller uses ViewData to pass any data to view.

MVC Artchitecture :

Understanding-ASP-NET-MVC-Model-View-Controller-ArInterview Question and Answers for MVC
Model-view-controller-MVC-Interview-questions-and
difference-between-aspnet-webforms

Comparison Artchitecture:

Comparison-of-Architecture-presentation-patterns

Mandatory Label

Introduction:
     Today , we discussed about Mandatory Label in C#.Net.  This label intimate to user ,It is a Mandatory Field.
 

 using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Windows.Forms;
 using System.Drawing;
 namespace StaffingSolutionV1.UtilityLayer
 {
 class MandatoryLable :Label
 {
 public enum StatusManLabel
 {
 False,
True
 };
 private StatusManLabel m_Status;
 public string AddSymbol
{
 get;
set;
 }
 public StatusManLabel StatusLabel
 {
 get
 {
return m_Status;
 }
 set
 {
 if (value == StatusManLabel.True)
 {
 this.Text = AddSymbol + " " + this.Text; }
 else
 {
 AddSymbol = ""; this.Text = "";
 }
 m_Status = value;
 }
 }
}
}