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

Farpoint Spread Sheet

                 Today , we will discuss about Farpoint Technology and his Merits and Demerits of Spreadsheet. 
Introduction:

                      It's just an Excel Sheet. It can support. Net Application windows, Web Application and VB6. Separate dll files for Windows, Web Applications and VB6. I hope, it's replacing for Datagridview. Because both are same.

 History of Farpoint Spread Sheet:

 1991 Spread released as a DLL control as the initial product offering from Farpoint Technologies, Inc.

1990s

Spread VBX released.[1]

Spread ActiveX released.

These components are now known as Spread COM.

2003 Spread for Windows Forms released as a completely new managed C# version prompted by the launch of Visual Studio .NET.

2003 Spread for Web Forms (now Spread for ASP.NET) released.

2006 Spread for BizTalk released.[2]

2009 Farpoint Technologies acquired by GrapeCity

FarPoint Spread History

 Merits and Demerits of Farpoint Spread:

Merits:

Easy to Access.

Lock Cells

Different types of Cell Type.  

Separate Celltypes for each Cell.

Support Regular Expression.

Support Charts Controls.

Copy and Paste cells.

Supports Windows Windows Azure AppFabric.

Cell Notes

Support Custom Cell Type.

Child Control.

Splitter Bar

Build in Custom Skin and Styles.

Floating Formula Bar.

Automatic Completion.

PDF Export  

Filter Option

Searching.

Validation

CellSpan.

Client Side Column and Row Resize.

Move Scrollbar (Horizontal and Vertical) with or without User interaction.

Bound and unbound mode.

 Demerits:

 One Event for General Cell Type (like Button Click Event)

Official Site--Farpoint Speard

Conclusion:

  Thanks for reading this Article. I hope, It is very useful to you. Tomorrow onwards, we will read to use Farpoint in .Net Applicaiton.