eVNiAP8J

1CREATE TABLE IF NOT EXISTS `ABC`.`Socio` (
2    `idSocio` INT NOT NULL,
3    `SocioNome` VARCHAR(45) NULL,
4    `SocioDataNasc` DATE NULL,
5    PRIMARY KEY (`idSocio`))
6    ENGINE = InnoDB;
7	
8INSERT INTO `ABC`.`Socio` (`idSocio`, `SocioNome`, `SocioDataNasc`) VALUES (1, 'Trampa', '1946-06-14');
9INSERT INTO `ABC`.`Socio` (`idSocio`, `SocioNome`, `SocioDataNasc`) VALUES (2, 'Bill', '1955-10-28');
10INSERT INTO `ABC`.`Socio` (`idSocio`, `SocioNome`, `SocioDataNasc`) VALUES (3, 'Cristiano', '1985-02-05');
11INSERT INTO `ABC`.`Socio` (`idSocio`, `SocioNome`, `SocioDataNasc`) VALUES (4, 'Francisco', '1936-12-17');
12INSERT INTO `ABC`.`Socio` (`idSocio`, `SocioNome`, `SocioDataNasc`) VALUES (5, 'Obama', '1961-08-04');
13	
14<DataGrid AutoGenerateColumns="False" Height="Auto" Width="Auto" HorizontalAlignment="Left" Name="dataGridProdutos" ItemsSource="{Binding Path=carregarDados}" CanUserResizeRows="True" AlternatingRowBackground="GhostWhite"  AlternationCount="2" CanUserAddRows="False">
15                <DataGrid.Columns>
16                    <DataGridTextColumn Binding="{Binding Path=idSocio}" Header="Número de Sócio" Width="Auto" IsReadOnly="True" />
17                    <DataGridTextColumn Binding="{Binding Path=SocioNome}" Header="Nome" Width="Auto" IsReadOnly="True" />
18                    <DataGridTextColumn Binding="{Binding Path=SocioDataNasc}" Header="Data de Nascimento" Width="*" IsReadOnly="True" />
19                </DataGrid.Columns>
20            </DataGrid>