WPF

Private Sub BindData()

           Dim conn As SqlConnection = New SqlConnection
           Dim command As SqlCommand
           Dim dataadp As SqlDataAdapter = New SqlDataAdapter
           Dim dtTbl As Data123DataSet = New Data123DataSet
           Dim query As String = "SELECT EntityCode, Title, Name FROM dbo.Entity"
           Dim connstring As String = "Data Source=SRITANU;Initial Catalog=Data123;User ID=sa"
           conn = New SqlConnection(connstring)

           Try
               command = New SqlCommand(query, conn)
               conn.Open()
               dataadp.SelectCommand = command
               dataadp.Fill(dtTbl, "Entity")
               DataContext = dtTbl
           Catch ex As Exception
               conn.Close()
           End Try

       End Sub

<Window x:Class="Window1"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    Title="Window1" Height="300" Width="670" xmlns:c1grid="http://schemas.componentone.com/wpf/C1DataGrid" WindowState="Maximized">
    <Grid Width="574">
        <Grid.ColumnDefinitions>
            <ColumnDefinition Width="574*" />
            <ColumnDefinition Width="0*" />
        </Grid.ColumnDefinitions>
        <c1grid:C1DataGrid Margin="0,12,0,21" DataContext="{Binding dtTbl}"  Name="C1DataGrid1" ItemsSource="{Binding Path=Data123DataSet.dtTbl, ElementName= Window, Mode=Default}">
            <c1grid:C1DataGrid.Columns>
                <c1grid:Column Caption="CUSTID" ColumnName="EntityCode" PropertyName="EntityCode " />
                <c1grid:Column Caption="TITLE" ColumnName="Title" PropertyName=" Title"/>
                <c1grid:Column Caption="NAME" ColumnName="Name" PropertyName=" Name"/>
            </c1grid:C1DataGrid.Columns>
        </c1grid:C1DataGrid>
    </Grid>
</Window>

<Expander Grid.Column="3" Grid.RowSpan="2" Header="expander1" Margin="3,12,-83,18" Name="expander1" BorderBrush="Red" BorderThickness="2" Width="200" Height="400">
     <StackPanel>
       <Button Width="100">This is the button one</Button>
       <Button Width="100">This is the button two</Button>
       </StackPanel>

     <Expander.Triggers>
       <EventTrigger RoutedEvent="Expander.Expanded">
         <BeginStoryboard>
           <Storyboard>
             <DoubleAnimation Storyboard.TargetName="expander1" Storyboard.TargetProperty="Width"
                              From="0" To="200" Duration="0:0:0.25" />
             <DoubleAnimation Storyboard.TargetName="expander1" Storyboard.TargetProperty="Height"
                              From="0" To="400" Duration="0:0:0.25" />
           </Storyboard>
         </BeginStoryboard>
       </EventTrigger>
     </Expander.Triggers>
   </Expander>