WPF Canvas layout panel

Canvas

Canvas provides absolute positioning to its contained controls. Canvas provides four properties to contained controls. Those are Canvas.Top, Canvas.Bottom, Canvas.Left and Canvas.Right.

  <Canvas Background="LightBlue">

        <TextBlock Canvas.Top="30" Canvas.Left="70">My first control</TextBlock>

        <TextBlock Canvas.Top="60" Canvas.Left="200">Other TextBlock control</TextBlock>

        <TextBox>Default location</TextBox>

        <TextBox Canvas.Top="140" Canvas.Left="100">Other textbox location</TextBox>

  </Canvas>

In above canvas example, added 4 controls and for few controls assigned attached property of canvas. If you not assigned attached property to contained controls, its default position is (0,0). i.e. Top and Left property value is 0.

Back to WPF Layout panels

WPF Layout panels

WPF Layout panels

1.       Canvas
2.       DockPanel
3.       StackPanel
4.       WrapPanel
5.       Grid
6.       UniformGrid

How to get list of table columns information in Sql Server

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME='TableName'

The above query will gives except primary key information.

Below query included primary key information also

SELECT COLS.COLUMN_NAME, COLS.DATA_TYPE, COLS.CHARACTER_MAXIMUM_LENGTH,

              (SELECT 'PRIMARY KEY' FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU

                              ON COLS.TABLE_NAME = TC.TABLE_NAME

                             AND TC.CONSTRAINT_TYPE = 'PRIMARY KEY'

                             AND KCU.TABLE_NAME = TC.TABLE_NAME

                             AND KCU.CONSTRAINT_NAME = TC.CONSTRAINT_NAME

                             AND KCU.COLUMN_NAME = COLS.COLUMN_NAME) AS PRIMARY_KEY

        FROM INFORMATION_SCHEMA.COLUMNS COLS WHERE TABLE_NAME = 'TableName' ORDER BY PRIMARY_KEY DESC, COLUMN_NAME