Supporting Namespace in Dotnet 4.5

S.No	Particular	.Net 3.0	.Net 3.5	.Net 4.0	.Net 4.5
1	Microsoft.Build.Tasks.Windows	Y	Y	Y	Y
2	Microsoft.Win32	Y	Y	Y	Y
3	Microsoft.Windows.Themes	Y	Y	Y	Y
4	System.Collections.ObjectModel	Y	Y	Y	Y
5	System.Collections.Specialized	Y	Y	Y	Y
6	System.ComponentModel	Y	Y	Y	Y
7	System.Diagnostics	Y	Y	Y	Y
8	System.IO	Y	Y	Y	Y
9	System.IO.Package	Y	Y	Y	Y
10	System.Printing	Y	Y	Y	Y
11	System.Printing.IndexedProperty	Y	Y	Y	Y
12	System.Printing.Interop	Y	Y	Y	Y
13	System.Security.Permissions	Y	Y	Y	Y
14	System.Security.RightsManagement	Y	Y	Y	Y
15	System.Windows	Y	Y	Y	Y
16	System.Windows.Annotations	Y	Y	Y	Y
17	System.Windows.Annotations.Storage	Y	Y	Y	Y
18	System.Windows.Automation	Y	Y	Y	Y
19	System.Windows.Automation.Peers	Y	Y	Y	Y
20	System.Windows.Automation.Provider	Y	Y	Y	Y
21	System.Windows.Automation.Text	Y	Y	Y	Y
22	System.Windows.Controls	Y	Y	Y	Y
23	System.Windows.Controls.Primitives	Y	Y	Y	Y
24	System.Windows.Converters	Y	Y	Y	Y
25	System.Windows.Data	Y	Y	Y	Y
26	System.Windows.Documents	Y	Y	Y	Y
27	System.Windows.Documents.DocumentStructures	Y	Y	N	Y
28	System.Windows.Documents.Serialization	Y	Y	Y	Y
29	System.Windows.Forms.Integration	Y	Y	Y	Y
30	System.Windows.Ink	Y	Y	Y	Y
31	System.Windows.Input	Y	Y	Y	Y
32	System.Windows.Input.StylusPlugIns	Y	Y	Y	Y
33	System.Windows.Interop	Y	Y	Y	Y
34	System.Windows.Markup (shared)	Y	Y	Y	Y
35	System.Windows.Markup.Localizer	Y	Y	Y	Y
36	System.Windows.Markup.Primitives	Y	Y	Y	Y
37	System.Windows.Media	Y	Y	Y	Y
38	System.Windows.Media.Animation	Y	Y	Y	Y
39	System.Windows.Media.Converters	Y	Y	Y	Y
40	System.Windows.Media.Effects	Y	Y	Y	Y
41	System.Windows.Media.Imaging	Y	Y	Y	Y
42	System.Windows.Media.Media3D	Y	Y	Y	Y
43	System.Windows.Media.Media3D.Converters	Y	Y	Y	Y
44	System.Windows.Media.TextFormatting	Y	Y	Y	Y
45	System.Windows.Navigation	Y	Y	Y	Y
46	System.Windows.Resources	Y	Y	Y	Y
47	System.Windows.Shapes	Y	Y	Y	Y
48	System.Windows.Threading	Y	Y	Y	Y
49	System.Windows.Xps	Y	Y	Y	Y
50	System.Windows.Xps.Packaging	Y	Y	Y	Y
51	System.Windows.Xps.Serialization	Y	Y	Y	Y
52	UIAutomationClientsideProviders	Y	Y	Y	Y

Supporting Namespace for Sliverlight in Net

S.No	Particular	Sliverlight
1	Microsoft.Win32	Y
2	Microsoft.Windows.Themes	Y
3	System.Collections.ObjectModel	Y
4	System.Collections.Specialized	Y
5	System.ComponentModel	Y
6	System.Diagnostics	Y
7	System.IO	Y
8	System.Security.Permissions	Y
9	System.Windows	Y
10	System.Windows.Automation	Y
11	System.Windows.Automation.Peers	Y
12	System.Windows.Automation.Provider	Y
13	System.Windows.Automation.Text	Y
14	System.Windows.Controls	Y
15	System.Windows.Controls.Primitives	Y
16	System.Windows.Data	Y
17	System.Windows.Documents	Y
18	System.Windows.Documents.DocumentStructures	Y
19	System.Windows.Documents.Serialization	Y
20	System.Windows.Forms.Integration	Y
21	System.Windows.Ink	Y
22	System.Windows.Input	Y
23	System.Windows.Interop	Y
24	System.Windows.Markup (shared)	Y
25	System.Windows.Media	Y
26	System.Windows.Media.Animation	Y
27	System.Windows.Media.Effects	Y
28	System.Windows.Media.Imaging	Y
29	System.Windows.Media.Media3D	Y
30	System.Windows.Navigation	Y
31	System.Windows.Resources	Y
32	System.Windows.Shapes	Y
33	System.Windows.Threading	Y

Calling Constructor from another Constructor

Yes , it is possible. Please check this link

http://www.codeproject.com/Articles/7011/An-Intro-to-Constructors-in-C

Constructor in C#.net

              A constructor is a method in the class which gets executed when its object is created. Usually, we put the initialization code in the constructor. 

Validate Text Box

Introduction:
      Today, we discussed about How to validate Text Box with Error Provider in C#.Net? .
Conditions:
    TextBox should enter only integer.
    create one validation event for integer

Here the Code:

protected void textBox1_Validating (object sender,
   System.ComponentModel.CancelEventArgs e)
{
   try
   {
      int x = Int32.Parse(textBox1.Text);
      errorProvider1.SetError(textBox1, "");
   }
   catch (Exception ex)
   {
      errorProvider1.SetError(textBox1, "Not an integer value.");
   }
}

Call this event in constructor
this.textBox1.Validating += new

System.ComponentModel.CancelEventHandler(this.textBox1_Validating);

Valdating data in Dataset

• Validating data is the process of confirming that the values being entered into data objects conform to the constraints within a dataset's schema, as well as the rules established for your application.
• Validating data prior to sending updates to the underlying database is a good practice that reduces errors as well as the potential number of round trips between an application and the database.
• You can confirm that data being written to a dataset is valid by building validation checks into the dataset itself.
• The dataset can check the data no matter how the update is being performed — whether directly by controls in a form, within a component, or in some other way. Because the dataset is part of your application, it is a logical place to build application-specific validation (unlike building the same checks into the database backend).

TableAdapter in Windows Application

TableAdapter Overview:

1. TableAdapters provide communication between your application and a database.
2. TableAdapters are also used to send updated data from your application back to the database.
3. ADO.NET Data Adapters were used for communicating between an application and a       database.
4. TableAdapters typically contain Fill and Update methods to fetch and update data in a database.
5. TableAdapters are created with the Dataset Designer inside of strongly typed datasets. 

Fill a dataset with data

• The phrase "filling a dataset with data" refers to loading data into the individual DataTable objects that make up the dataset.
• You fill the data tables by executing TableAdapter queries or by executing data adapter (for example, SqlDataAdapter) commands.

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;
 }
 }
}
}

Number TextBox

Hi All,
   Today ,we see how to Create Number TextBox?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Text.RegularExpressions;
namespace LaksUserControl.UtilityLayer
 {
 class NumberTextBox : TextBox
 {
 CustomErrorProvider objCEP = new CustomErrorProvider();
 public enum CheckStatus { True, False, };
 public enum CheckStatusBlank { True, False, };
 enum ValidatieonType { BLANK, CHARACTER, BLANKWITHCHARACTER, };
 private CheckStatus m_CheckStatus;
 private CheckStatusBlank m_CheckStatusBlank;
 public CheckStatus CheckErrorProvider
 {
 get
 {
 return m_CheckStatus;
 }
 set
 {
 m_CheckStatus = value;
 }
 }
 public CheckStatusBlank CheckEmptyBox
 {
 get
 {
 return m_CheckStatusBlank;
 }
 set
 {
 m_CheckStatusBlank = value;
 }
 }
 private bool CheckBlankTextBox()
 {
 if (string.IsNullOrEmpty(this.Text))
 return true;
 else
 return false;
 }
 private bool ValidateNumber(string str)
 {
 Regex regexAlphaNum = new Regex(@"^[0-9]*$");
 return regexAlphaNum.IsMatch(str);
 }
 bool checkBlank;
 private bool CheckBlankTextBox(ValidatieonType Mode)
 {
 switch (Mode)
 {
 case ValidatieonType.BLANK:
 if (string.IsNullOrEmpty(this.Text))
 checkBlank = true;
 else
 checkBlank = false;
 break;
 case ValidatieonType.CHARACTER:
 if (!ValidateNumber(this.Text))
 checkBlank = true;
 else
 checkBlank = false;
 break;
 case ValidatieonType.BLANKWITHCHARACTER:
 if (string.IsNullOrEmpty(this.Text) | !ValidateNumber(this.Text))
 checkBlank = true;
 else checkBlank = false;
 break;
 }
 return checkBlank;
 }
 bool chkdisplayEP;
 protected internal bool DisplayErrorProvider(string CheckErrorProvider, string CheckEmptyBox, string Message)
 {
 if (CheckErrorProvider == "true" && CheckEmptyBox == "true")
 {
 if (CheckBlankTextBox(ValidatieonType.BLANKWITHCHARACTER))
 {
 objCEP.SetError(this, Message);
 chkdisplayEP = true;
 }
 else
 {
 objCEP.SetError(this, "");
 chkdisplayEP = false;
 }
 }
 else if ((CheckErrorProvider == "true" && CheckEmptyBox == "false"))
 {
 if (CheckBlankTextBox(ValidatieonType.CHARACTER))
 {
 objCEP.SetError(this, Message);
 chkdisplayEP = true;
 }
 else
 {
 objCEP.SetError(this, "");
 chkdisplayEP = false;
 }
 }
 return chkdisplayEP;
 }
 }
 }


 using System;
using System.Collections.Generic;
using System.Linq;
 using System.Text;
using System.Windows.Forms;
 namespace LaksUserControl.UtilityLayer
{

 class CustomErrorProvider : ErrorProvider
 {
 public List GetControls()
 {
 return this.GetControls(this.ContainerControl);
 }
 public List GetControls(Control ParentControl)
 { 
 List ret = new List(); 
 if (!string.IsNullOrEmpty(this.GetError(ParentControl)))
 ret.Add(ParentControl); 
 foreach (Control c in ParentControl.Controls)
 {
 List child = GetControls(c);
 if (child.Count > 0)
 ret.AddRange(child);
 }
 return ret;
 }
 }
 }
</div>

Get DataBase Exists or not using DataContext

   This is code for Get DataBase Exists or not using DataContext

DataContext context = new DataContext(GetConnectionString("YourSErverName"));
bool dbExists = context.DatabaseExists();
 if (dbExists)
{
MessageBox.Show("Database Exists");
 }
 else
 {
 MessageBox.Show("Database doesn't Exist");
}
 static string GetConnectionString(string serverName)
 {
 System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
 builder["Data Source"] = serverName; builder["integrated Security"] = true;
 builder["Initial Catalog"] = "Sample2"; Console.WriteLine(builder.ConnectionString); Console.ReadKey(true); return builder.ConnectionString;
 }

Base Directory vs Current Directory

 Base Directory vs Current Directory

S.No	Base Directory	Current Directory
1	returns the path where the executable file exists.	returns the path that the current working directory from the executable file.

Managed Resource vs Unmanaged Resource

Managed Resource vs Unmanaged Resource

S.No	Managed Resource	Unmanaged Resource
1	Managed resources are those that are pure .NET code and managed by the runtime and are under its direct control.	Unmanaged resources are those that are not. File handles, pinned memory, COM objects, database connections etc.

LINQ -- I

1.      Difference between First vs FirstOrDefault in LINQ

•    First: Gives first record from the collection, if collection doesn't have any object then throws error.
• FirstOrDefault: FirstOrDefault extension method is used to retrieve the first element from the collection, if not then gives null.

2.      Difference between Last vs LastOrDefault in LINQ?

• Last:Last extension method gives last element from the collection. If there is no element in the collection, it throws error.
• LastOrDefault:LastOrDefault extension method gives the last element form the collection, if not gives null.

3.     When will we use ThenBy in LINQ?

               ThenBy is used with OrderBy or OrderByDescending. It is used to apply sorting on already sorted collection using OrderBy or OrderByDescending.

4.     Where to Use SequenceEqual ?

                   SequenceEqual extension method is used to determine if both collections sequence are equal.

5.     what is mean by SkipWhile?

            SkipWhile extension method is used to skip the elements that satisfies the given filter criteria till it doens't get any element that doesn't satisfy.

6.     How to use Take Method in LINQ?

          Take extension method is used to take specified number of elements from the collection.

7.     What is mean by Lambda expression?

• A lambda expression is an function that contain many expressions and statements.
• Lambda expression used to create delegates or expression tree types.
• All lambda expressions use the lambda operator =>, which is read as "goes to".
• The left side of the lambda operator specifies the input parameters.
• The right side holds the expression or statement block.

8.     What is ORM?

         ORM stands for Object-Relational Mapping. Sometimes it is called O/RM, or O/R mapping. It is a programming technique that contains a set of classes that map relational database entities to objects in a specific programming language.

9.     What is ODBC?

        ODBC (Open Database Connectivity) was developed to unify all of the communication protocols for various RDBMSs. ODBC was designed to be independent of programming languages, database systems, and Operating Systems. So with ODBC, an application could communicate with different RDBMSs by using the same code, simply by replacing the underlying ODBC drivers.

10. What is LINQ To SQL?

•  LINQ to SQL is a component of the .NET Framework version 3.5 that provides a run-time infrastructure for managing relational data as objects.
• LINQ to SQL fully supports transactions, views, Stored Procedures, and user-defined functions. It also provides an easy way to integrate data validation and business logic rules into your data model, and supports single table inheritance in the object model.
• LINQ to SQL, ADO.NET SqlClient adapters are used to communicate with real SQL Server databases.

11. Difference between LINQ To SQL and LINQ To Object?

·        LINQ to SQL needs a Data Context object. The Data Context object is the bridge between LINQ and the database. LINQ to Objects doesn’t need any intermediate LINQ provider or API.

·        LINQ to SQL returns data of type IQueryable<T> while LINQ to Objects returns data of type IEnumerable<T>.

·        LINQ to SQL is translated to SQL by way of Expression Trees, which allow them to be evaluated as a single unit and translated to the appropriate and optimal SQL statements. LINQ to Objects does not need to be translated.

·        LINQ to SQL is translated to SQL calls and executed on the specified database while LINQ to Objects is executed in the local machine memory.

12. What is mean by Entity Framework?

·        ADO.NET Entity Framework (EF) was first released with Visual Studio 2008 and .NET Framework 3.5 Service Pack 1. So far, many people view EF as just another ORM product from Microsoft, though by design it is supposed to be much more powerful than just an ORM tool.

·        The conceptual data model schema is expressed in the Conceptual Schema Definition Language (CSDL), the actual storage model is expressed in the Storage Schema Definition Language (SSDL), and the mapping in between is expressed in the Mapping Schema Language (MSL).

13. Difference between LINQ To SQL and LINQ To Entities?

·        LINQ to Entities applications work against a conceptual data model (EDM). All mappings between the languages and the databases go through the new EntityClient mapping provider. The application no longer connects directly to a database or sees any database-specific construct; the entire application operates in terms of the higher-level EDM model.

14. What are all the Operator Type  in LINQ To Object?

·        Aggregation Aggregate, Average, Count, LongCount, Max, Min, Sum

·        Conversion Cast, OfType, ToArray, ToDictionary, ToList, ToLookup, ToSequence

·        Element DefaultIfEmpty, ElementAt, ElementAtOrDefault, First, FirstOrDefault, Last, LastOrDefault, Single, SingleOrDefault

·        Equality EqualAll

·        Generation Empty, Range, Repeat

·        Grouping GroupBy

·        Joining GroupJoin, Join

·        Ordering OrderBy, ThenBy, OrderByDescending, ThenByDescending, Reverse

·        Partitioning Skip, SkipWhile, Take, TakeWhile

·        Quantifiers All, Any, Contains

·        Restriction Where

·        Selection Select, SelectMany

·        Set Concat, Distinct, Except, Intersect, Union

HTML Tag with Support Browsers

											S.No Tag Description IE FF Opera Chorme Safari Difference Support Remarks Solution 1 <!...> Comment Tag Y Y Y Y Y N ****** ****** ****** 2 Instructs to the WebBrowser (HTML 5) Y Y Y Y Y Y HTML 5.0 ****** ****** 3 Hyperlink(One Page to another Page) Y Y Y Y Y N ****** ****** ****** 4 Abbraviation or acronym Y Y Y Y Y N ****** ****** ****** 5 Abbraviation ****** ****** ****** ****** ****** Y HTML 4.01 ****** ****** 6 Contact information Y Y Y Y Y N ****** ****** ****** 7 applet Embedded applet ****** ****** ****** ****** ****** Y HTML 4.01 ****** ****** 8 Inside an Image-Map Y Y Y Y Y Y HTML 5.0 attributes are difference(nohref --Not supported in HTML 5.0).New attributes in HTML 5.0 :type,media rel,hreflang) ****** 9 Independent,self contained content Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 10 some content aside from the content it is placed it Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 11 audio strams,sound and music Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 12 makes text Bold Y Y Y Y Y N ****** ****** ****** 13 default url/target for all element with a Url(Hyperlink,Image) Y Y Y Y Y N ****** Inside the ****** 14 used to define default font color,size and family Y Y Y Y Y Y HTML 4.01 ****** ****** 15 bidirectional override Y Y Y Y Y N ****** ****** ****** 16 text is bigger Y Y Y Y Y Y HTML 4.01 ****** ****** 17 takes from a another Source Y Y Y Y Y N ****** ****** ****** 18 Document's Body Y Y Y Y Y Y HTML 5.0 specific attributes are removed, while in HTML 4.01 they were deprecated. ****** 19 single line a break Y Y Y Y Y N ****** ****** ****** 20 Push Button Y Y Y Y Y Y HTML 5.0 Attributes:autofocus,form, formaction, formenctype, formmethod, formnovalidate, and formtarget. ****** 21 Display Graphics Y Y Y Y Y Y HTML 5.0 ****** ****** 22 defines a table caption Y Y Y Y Y Y HTML 5.0 The "align" attribute which was deprecated in HTML 4.01, is not supported in HTML5. Use CSS instead. Use CSS 23 center align text Y Y Y Y Y Y HTML 5.0 ****** ****** 24 defines a citation Y Y Y Y Y N ****** ****** ****** 25 defines a Computer Code Y Y Y Y Y N ****** ****** ****** 26 One or More Columns in a table Y Y Y Y Y Y HTML 5.0 Most of the attributes from 4.01 are not supported in HTML5.(Attributes are :align,char,charoff,valign,width[Not supported in HTML 5.0]) ****** 27 Group Columns in a Table Y Y Y Y Y Y HTML 5.0 Most of the attributes from 4.01 are not supported in HTML5.(Attributes are :align,char,charoff,valign,width[Not supported in HTML 5.0]) ****** 28 command button like Radio buttton,Check Box or a Button Y N N N Y Y HTML 5.0 New in HTML 5.0 ****** 29 Defines list of options  N N Y N N Y HTML 5.0 New in HTML 5.0 ****** 30 describe the Items in a Definition list Y Y Y Y Y N ****** ****** ****** 31 Text has been deleted from a Documents Y Y Y Y Y N ****** ****** ****** 32 spcified additional details or controls which can be hidden or shown on demand N N N Y N Y HTML 5.0 New in HTML 5.0 ****** 33 Defines a definition terms Y Y Y Y Y N ****** ****** ****** 34 define a directory Y Y Y Y Y Y HTML 5.0 Not supported Use CSS 35 Define a Division or section in an HTML Document Y Y Y Y Y Y HTML 5.0 The "align" attribute is deprecated in HTML 4.01, and not supported in HTML5. Use CSS to align the div's content. ****** 36 Define a Definition list Y Y Y Y Y N ****** ****** ****** 37 define a start of a term in the Difintion list Y Y Y Y Y N ****** ****** ****** 38 deifne a Emphasized Text Y Y Y Y Y N ****** ****** ****** 39 defines Embedded content ,such as a plug in Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 40 group together elements in a form Y Y Y Y Y Y HTML 5.0 HTML5 has the attributes disabled, form, and name, which was not supported in HTML 4.01. ****** 41 contain a caption for a Tag Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 42 Self contained flow content Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 43 Specify font family,size and color of text Y Y Y Y Y Y HTML 5.0 Not supported Use CSS 44 footer of the section or Document Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 45 create an HTML Form for an user input Y Y Y Y Y Y HTML 5.0 New Attributes are in the HTML 5.0 (autocomplete and novalidate) ****** 46 One Particulare window within a Frameset Y Y Y Y Y Y HTML 5.0 Not supported ****** 47 org Mulitiple Window Y Y Y Y Y Y HTML 5.0 Not supported ****** 48 to define headers Y Y Y Y Y Y HTML 5.0 Not supported Use CSS 49 contains all head elements.Inside the Y Y Y Y Y Y HTML 5.0 The profile attribute is not supported in HTML5 ****** 50 specifies an introduction ,or a group of navigation elementsofr the Documents Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 51 heading of a section or a Documents Y Y Y Y Y Y HTML 5.0 New in HTML 5.0 ****** 52 Horizonal line in an HTML Page Y Y Y Y Y Y HTML 5.0 tag displays a horizontal rule, and defines a change in the content.All attributes in HTML 4.01 (align, noshade, size, and width) are deprecated in HTML 4.01, and not supported in HTML5. You should use CSS to style the hr element. Use CSS 53 tells the browser that this is an HTML Document Y Y Y Y Y Y HTML 5.0 New Attribute is in the HTML 5.0(Manifest) ****** 54 renders test in Italics Y Y Y Y Y N ****** ****** ****** 55

Character Textbox in C#.Net

Introduction:
        Today, we discussed about Character TextBox in C#.Net.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Text.RegularExpressions;
namespace LaksUserControl.UtilityLayer
{
 class NCharacterTextBox :TextBox
 {
 CustomErrorProvider objCEP = new CustomErrorProvider();
public enum CheckStatus { True, False, };
 public enum CheckStatusBlank { True, False, };
 public enum ValidatieonType { BLANK, CHARACTER, BLANKWITHCHARACTER, };
 private CheckStatus m_CheckStatus;
 private CheckStatusBlank m_CheckStatusBlank;
 public CheckStatus CheckErrorProvider
 { get { return m_CheckStatus; } set { m_CheckStatus =value; }
 }
public CheckStatusBlank CheckEmptyBox
 { get { return m_CheckStatusBlank; } set { m_CheckStatusBlank = value; }
 }
 private bool ValidateAlphabet(string str)
 {
 Regex regexAlphaNum = new Regex(@"^[a-zA-Z]*$"); return regexAlphaNum.IsMatch(str); }
bool checkBlank;
 private bool CheckBlankTextBox(ValidatieonType Mode)
 {
 switch (Mode)
 {
 case ValidatieonType.BLANK:
 if (string.IsNullOrEmpty(this.Text)) checkBlank= true; else checkBlank=false;
 break;
case ValidatieonType.CHARACTER:
 if (!ValidateAlphabet(this.Text)) checkBlank=true; else checkBlank=false;
break;
case ValidatieonType.BLANKWITHCHARACTER:
 if (string.IsNullOrEmpty(this.Text) | !ValidateAlphabet(this.Text)) checkBlank=true; else checkBlank=false; break;
}
 return checkBlank;
 }
 bool chkdisplayEP;
 protected internal bool DisplayErrorProvider(string CheckErrorProvider, string CheckEmptyBox, string Message)
 {
 if (CheckErrorProvider == "true" && CheckEmptyBox == "true")
 {
 if (CheckBlankTextBox(ValidatieonType.BLANKWITHCHARACTER))
 {
 objCEP.SetError(this, Message);
 chkdisplayEP=true;
 }
 else
 {
 objCEP.SetError(this, ""); chkdisplayEP=false;
 }
 }
 else if ((CheckErrorProvider == "true" && CheckEmptyBox == "false"))
 {
 if (CheckBlankTextBox(ValidatieonType.CHARACTER))
 {
 objCEP.SetError(this, Message); chkdisplayEP = true;
 }
 else
 {
 objCEP.SetError(this, ""); chkdisplayEP = false;
 }
 }
 return chkdisplayEP;
 }
 }
 }

Error Provider Class

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
 namespace LaksUserControl.UtilityLayer
 {
 class CustomErrorProvider : ErrorProvider
 {
 public List GetControls()
 {
 return this.GetControls(this.ContainerControl);
 }
 public List GetControls(Control ParentControl)
 {
 List ret = new List();
 if (!string.IsNullOrEmpty(this.GetError(ParentControl)))
 ret.Add(ParentControl);
 foreach (Control c in ParentControl.Controls) 
 {
 List child = GetControls(c); if (child.Count > 0) ret.AddRange(child);
 }
 return ret; 
 }
 }
 }

Validation TextBox with Error Provider in C#.Net

HI All,
    Today, We discussed about TextBox Validation with Error Provider in C#.Net

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Windows.Forms;
 using System.Text.RegularExpressions;
 namespace LaksUserControl.UtilityLayer
{
 class NCharacterTextBox :TextBox
 {
 CustomErrorProvider objCEP = new CustomErrorProvider();
 public enum CheckStatus { True, False, };
 public enum CheckStatusBlank { True, False, };
 public enum ValidatieonType { BLANK, CHARACTER, BLANKWITHCHARACTER, };
 private CheckStatus m_CheckStatus;
 private CheckStatusBlank m_CheckStatusBlank;

public CheckStatus CheckErrorProvider
 {
 get { return m_CheckStatus; } set { m_CheckStatus =value; }
 }
 public CheckStatusBlank CheckEmptyBox { get { return m_CheckStatusBlank; } set { m_CheckStatusBlank = value; }
 }
 private bool ValidateAlphabet(string str)
 {
 Regex regexAlphaNum = new Regex(@"^[a-zA-Z]*$"); return regexAlphaNum.IsMatch(str);
}
 bool checkBlank;
 private bool CheckBlankTextBox(ValidatieonType Mode)
 {
 switch (Mode)
 {
 case ValidatieonType.BLANK:
 if (string.IsNullOrEmpty(this.Text))
 checkBlank= true;
 else checkBlank=false;
 break;
 case ValidatieonType.CHARACTER:
 if (!ValidateAlphabet(this.Text))
 checkBlank=true;
 else
 checkBlank=false;
 break;
 case ValidatieonType.BLANKWITHCHARACTER:
 if (string.IsNullOrEmpty(this.Text) | !ValidateAlphabet(this.Text))
 checkBlank=true;
 else
 checkBlank=false;
 break;
 }
 return checkBlank;
 }
 bool chkdisplayEP;
 protected internal bool DisplayErrorProvider(string CheckErrorProvider, string CheckEmptyBox, string Message)
 {
 if (CheckErrorProvider == "true" && CheckEmptyBox == "true")
 {
 if (CheckBlankTextBox(ValidatieonType.BLANKWITHCHARACTER))
 {
 objCEP.SetError(this, Message);
 chkdisplayEP=true;
 }
 else
 {
 objCEP.SetError(this, "");
 chkdisplayEP=false;
 }
 }
 else if ((CheckErrorProvider == "true" && CheckEmptyBox == "false"))
 {
 if (CheckBlankTextBox(ValidatieonType.CHARACTER))
 {
 objCEP.SetError(this, Message);
 chkdisplayEP = true;
 }
 else
 {
 objCEP.SetError(this, "");
 chkdisplayEP = false;
 }
 }
 return chkdisplayEP;
 }
 }
 }

Error Provider

using System;
using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Windows.Forms;
 namespace LaksUserControl.UtilityLayer
 {
 class CustomErrorProvider : ErrorProvider
 {
 public List GetControls()
 {
 return this.GetControls(this.ContainerControl); 
 }
 public List GetControls(Control ParentControl)
 { 
 List ret = new List();
 if (!string.IsNullOrEmpty(this.GetError(ParentControl))) ret.Add(ParentControl);
 foreach (Control c in ParentControl.Controls) 
 {
 List child = GetControls(c); if (child.Count > 0) ret.AddRange(child); } return ret;
 }
 }
 }

ComboBox Vs ListBox

S.No		ComboBox	ListBox
1	Select	One Data	Multiple Data.
2	Facility	Drop Down Facility.	Drop up and Drop Down Facility
3	check Box	can't Use CheckBox.	Can use Check Box.

LINQToSQL Vs Entity Framework

S.No		LINQTOSQL	Entity Framwork
1	Used	rapid application development	enterprise application development.
2	Support	MS SQL Server database.	supports all existing ADO.NET data providers.
3	Relationship	One to One.	Many to Many.

IEnumerable Vs IQuerable

S.No		IEnumerable	IQuerable
1	namespace	Sysem.Collection	System.LINQ
2	query data	in-memory collections like List, Array etc.	out-memory (like remote database, service) collections.
3	suitable	LINQ to Object and LINQ to XML queries.	LINQ to SQL queries
4	supports	custom query.	custom query using CreateQuery and Execute methods
5	Extension methods	IEnumerable takes functional objects.	expression objects means expression tree.

INTERSECT vs INNER JOIN

 Both gave a same result. But One difference that is Column value is Null. Please see the Examples:
First create a temp Table in the Sql Server.
Example :1

Declare @m_table1 table (id int, firstName varchar(50))
Declare @m_table2 table (id int, firstName varchar(50))

-- Insert the Value

Insert into @m_table1 values (1,NULL)
Insert into @m_table2 values (1,NULL)

-- Inner Join

Select t1.*
from @m_table1 t1
inner join @m_table2 t2
On
t1.id=t2.id and t1.firstName=t2.firstName

-- INTERSECT

Select * from @m_table1

INTERSECT

Select * from @m_table2

Result for Example 1:
  Inner Join -- No data displays.
 INTERSECT -- Row displays.

Example --2:

Declare @m_table1 table (id int, firstName varchar(50))
Declare @m_table2 table (id int, firstName varchar(50))

-- Insert the Value

Insert into @m_table1 values (1,1)
Insert into @m_table2 values (1,NULL)

-- Inner Join

Select t1.*
from @m_table1 t1
inner join @m_table2 t2
On
t1.id=t2.id and t1.firstName=t2.firstName

-- INTERSECT

Select * from @m_table1

INTERSECT

Select * from @m_table2

Result for Example 1:
 Inner Join -- No data displays.
 INTERSECT -- No data displays.

I hope , you understand the difference between INTERSECT vs INNER JOIN

Function Name Format

Introduction:
    Today, we discussed about function name format.

CREATE FUNCTION FNNameformat(@colName varchar(max))
RETURNS VARCHAR(1000)
AS
BEGIN
DECLARE @IntNumbers VARCHAR(MAX)
BEGIN
SET @IntNumbers = UPPER(LEFT(@colName ,1)) + LOWER(SUBSTRING(@colName,2,LEN(@colName)-1))
END
RETURN @IntNumbers
END

Extract Character from string in SQL

          Today, we see the Extract character from String in SQL Server

Alter FUNCTION ExtractCharacter(@String VARCHAR(2000)) RETURNS VARCHAR(1000) AS BEGIN DECLARE @Count INT DECLARE @IntNumbers VARCHAR(1000) SET @Count = 0 SET @IntNumbers = '' WHILE @Count <= LEN(@String) BEGIN IF SUBSTRING(@String,@Count,1) <> '0' AND SUBSTRING(@String,@Count,1) <> '1' AND SUBSTRING(@String,@Count,1) <> '2' AND SUBSTRING(@String,@Count,1) <> '3' AND SUBSTRING(@String,@Count,1) <> '4'AND SUBSTRING(@String,@Count,1) <> '5' AND SUBSTRING(@String,@Count,1) <> '6' AND SUBSTRING(@String,@Count,1) <> '7' AND SUBSTRING(@String,@Count,1) <> '8' AND SUBSTRING(@String,@Count,1) <> '9' BEGIN SET @IntNumbers = @IntNumbers + SUBSTRING(@String,@Count,1) END SET @Count = @Count + 1 END RETURN @IntNumbers END GO

Split Year,Month and Day from DateTime Column in SQL Server

Split Year,Month and Day from DateTime Column in SQL Server
Select YEAR(iddate) as [Year],Month(iddate) as [Month],Day(iddate) as date from Excel_Table where iddate!='' order by date Or Select DATEPART(YEAR,iddate) as [Year],DATEPART(Month,iddate) as [Month],DATEPART(Day,iddate) as date from Excel_Table where iddate!=''

Extract Number from string in SQL

Extract number from string in SQL

CREATE FUNCTION ExtractInteger(@String VARCHAR(2000))
 RETURNS VARCHAR(1000)
 AS
BEGIN DECLARE
@Count INT
DECLARE @IntNumbers VARCHAR(1000)
SET @Count = 0
SET @IntNumbers = '' WHILE @Count <= LEN(@String) BEGIN IF SUBSTRING(@String,@Count,1) >= '0' AND SUBSTRING(@String,@Count,1) <= '9' BEGIN SET @IntNumbers = @IntNumbers + SUBSTRING(@String,@Count,1)
 END SET @Count = @Count + 1
END RETURN @IntNumbers
END
GO

Display relationship tables in the SQL Database

Query for Display relationship tables in the SQL Database

SELECT f.name AS ForeignKey,SCHEMA_NAME(f.SCHEMA_ID) SchemaName,OBJECT_NAME(f.parent_object_id) AS TableName, COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName,SCHEMA_NAME(o.SCHEMA_ID) ReferenceSchemaName,OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnNameFROM sys.foreign_keys AS f INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id INNER JOIN sys.objects AS o ON o.OBJECT_ID = fc.referenced_object_id

IEnumerable Vs Ilist

S.No		IEnumerable	List
1	Add/Remove Items	doen’t support add or remove items from the list.	Supports add or remove items from the list.
2	Further Filtering	doesn’t support further filtering.	Supports further filtering.

CSS Code -- Browser

S.No	Property Name	Description	IE	FF	Opera	Chorme	Safari	Remarks
1	animation	shorthand property for six of the animation properties[animation-name, animation-duration, animation-timing-function, animation-delay, animation-iteration-count, and animation-direction.]	N	N	N	N	N	In FireFox (-moz).Safari,chorme(-webkit)
2	apperance	ou to make an element look like a standard user interface element.	N	N	N	N	N	In FireFox (-moz).Safari,chorme(-webkit)
3	back-side	defines whether or not an element should be visible when not facing the screen.	N	N	N	N	N	Safari(-webkit)
4	background	shorthand property sets all the background properties in one declaration.	Y	Y	Y	Y	Y
5	border	sets all the border properties in one declaration.	Y	Y	Y	Y	Y
6	bottom	For absolutely positioned elements, the bottom property sets the bottom edge of an element to a unit above/below the bottom edge of its containing element.For relatively positioned elements, the bottom property sets the bottom edge of an element to a unit above/below its normal position.	Y	Y	Y	Y	Y
7	Box	Create a Box	N	N	N	N	N	In FireFox (-moz).Safari,chorme(-webkit)
8	Caption side	specifies the placement of a table caption.	Y	Y	Y	Y	Y
9	clear	which sides of an element where other floating elements are not allowed.	Y	Y	Y	Y	Y
10	clip	What happens if an image is larger than its containing element? - The clip property lets you specify the dimensions of an absolutely positioned element that should be visible, and the element is clipped into this shape, and displayed.	Y	Y	Y	Y	Y
11	color	specify color for a Text	Y	Y	Y	Y	Y
12	Column	To specify columns	N	N	Y	N	N	In FireFox (-moz).Safari,chorme(-webkit)
13	Content	used with the :before and :after pseudo-elements, to insert generated content.	Y	Y	Y	Y	Y
14	Counter Increment	increments one or more counter values.	Y	Y	Y	Y	Y
15	Counter-reset	creates or resets one or more counters.	Y	Y	Y	Y	Y
16	Cursor	type of cursor to be displayed when pointing on an element.	Y	Y	Y	Y	Y
17	Direction	specifies the text direction/writing direction.	Y	Y	Y	Y	Y
18	display	specifies the type of box an element should generate.	Y	Y	Y	Y	Y
19	empty-cell	whether or not to display borders and background on empty cells in a table (only for the "separated borders" model).	Y	Y	Y	Y	Y
20	float	specifies whether or not a box (an element) should float.	Y	Y	Y	Y	Y
21	font	sets all the font properties in one declaration.	Y	Y	Y	Y	Y
22	grid-column	specifies the width of each column in the grid.	N	N	Y	N	N
23	grid-row	specifies the Height of each row in the grid.	N	N	Y	N	N
24	hanging-punctuation	whether a punctuation mark may be placed outside the line box at the start or at the end of a full line of text.	N	N	Y	N	N
25	height	sets the height of an element.	Y	Y	Y	Y	Y
26	icon	the author the ability to style an element with an iconic equivalent.	N	N	Y	N	N
27	Keyframe	you can create animations.gradually changing from one set of CSS styles to another.During the animation, you can change the set of CSS styles many times.	N	N	N	N	N	In FireFox (-moz).Safari,chorme(-webkit)
28	left	For absolutely positioned elements, the left property sets the left edge of an element to a unit left/right the left edge of its containing element.For relatively positioned elements, the left property sets the left edge of an element to a unit left/right its normal position.	Y	Y	Y	Y	Y
29	letter-spacing	increase or decrease the space between character in a text	Y	Y	Y	Y	Y
30	line-height	specifies the line height.	Y	Y	Y	Y	Y
31	list-style	sets all the list properties in one declaration.	Y	Y	Y	Y	Y
32	margin	sets all the margin properties in one declaration. This property can have from one to four values.	Y	Y	Y	Y	Y
33	max-height	sete the max height of the elements	Y	Y	Y	Y	Y
34	max-width	sete the max width of the elements	Y	Y	Y	Y	Y
35	min-height	sete the min height of the elements	Y	Y	Y	Y	Y
36	min-width	sete the min width of the elements	Y	Y	Y	Y	Y
37	nav	specifies where to navigate	N	N	N	N	N
38	opacity	opacity level of the element	Y	Y	Y	Y	Y
39	outline	a line that is drawn around elements (outside the borders) to make the element "stand out".	Y	Y	Y	Y	Y
40	overflow	what happens if content overflows an element's box.	Y	Y	Y	Y	Y
41	overflow-x	specifies whether or not to clip the left/right edges of the content - if it overflows the element's content area.	Y	Y	Y	Y	Y
42	overflow-y	specifies whether or not to clip the top/button edges of the content - if it overflows the element's content area.	Y	Y	Y	Y	Y
43	padding	sets all the padding properties in one declaration. This property can have from one to four values.	Y	Y	Y	Y	Y
44	page-break	sets the page-breaking behavior after an element.	Y	Y	Y	Y	Y
45	perspective	how many pixels a 3D element is placed from the view. This property allows you to change the perspective on how 3D elements are viewed.	N	N	N	N	N	Safari(-webkit)
46	perspective-origin	where a 3D element is based in the x- and the y-axis. This property allows you to change the bottom position of 3D elements.	N	N	N	N	N	Safari(-webkit)
47	position	type of positioning method used for an element (static, relative, absolute or fixed).	Y	Y	Y	Y	Y
48	punctuation-trim	specifies whether a punctuation character should be trimmed if it appears at the start or end of a line, or adjacent to another fullwidth punctuation character.	N	N	N	N	N
49	quotes	sets the type of quotation marks for embedded quotations.	Y	Y	Y	Y	Y
50	resize	specifies whether or not an element is resizable by the user.	N	Y	Y	N	Y
51	right	For absolutely positioned elements, the right property sets the right edge of an element to a unit to the left/right of the right edge of its containing element.For relatively positioned elements, the right property sets the right edge of an element to a unit to the left/right to its normal position.	Y	Y	Y	Y	Y
52	rotation	rotates a block-level element counterclockwise around a given point defined by the rotation-point property.	N	N	N	N	N
53	rotation-point	The rotation-point property is a pair of values that defines a point as an offset from the top left border edge.	N	N	N	N	N
54	table-layout	sets the table layout algorithm to be used for a table.	Y	Y	Y	Y	Y
55	target	shorthand property for setting the target-name, target-new, and target-position properties.	N	N	N	N	N
56	text	create a text in an element.	Y	Y	Y	Y	Y
57	top	For absolutely positioned elements, the Top property sets the Top edge of an element to a unit above/below the Top edge of its containing element.For relatively positioned elements, the Top property sets the Top edge of an element to a unit above/below its normal position.	Y	Y	Y	Y	Y
58	transform	applies a 2D or 3D transformation to an element. This property allows you to rotate, scale, move, skew, etc., elements.	N	N	N	N	N	In FireFox (-moz-transform).Safari,chorme(-webkit-transform) ,IE(-ms-transform )
59	transition	property for the four transition properties:transition-property, transition-duration, transition-timing-function, and transition-delay.	N	N	N	N	N	In FireFox (-moz-transition).Safari,chorme(-webkit-transition) ,Opera(-o-transition )
60	vertical-align	vertical alignment of an element.	Y	Y	Y	Y	Y
61	visibility	specifies whether or not an element is visible.	Y	Y	Y	Y	Y
62	width	sets the width of an element.	Y	Y	Y	Y	Y
63	white-space	specifies how white-space inside an element is handled.	Y	Y	Y	Y	Y
64	word-spacing	increases or decreases the white space between words.	Y	Y	Y	Y	Y
65	word-break	specifies line breaking rules for non-CJK scripts.	Y	N	N	N	Y
66	word-wrap	allows long words to be able to be broken and wrap onto the next line.	Y	Y	Y	Y	Y
67	Z-index	specifies the stack order of an element.An element with greater stack order is always in front of an element with a lower stack order.	Y	Y	Y	Y	Y