Buscar este blog

martes, 11 de febrero de 2014

Examen Final - Programacion Visual - VB.NET 2012 - 2013.

Programar un formulario que permita agregar y buscar elementos de la tabla Alumnos(codalu, nomalu, apealu, ciclo, turno, codcar). 
Usando la tabla carreras para seleccionar la carrera respectiva. 
Carreras(codcar, nomcar).

Script de la base de datos en SQL Server:
USE [master]
GO
CREATE DATABASE [BDUNIVERSIDAD]
GO
USE [BDUNIVERSIDAD]
GO
CREATE TABLE [dbo].[ALUMNOS](
[CODALU] [nchar](5) NOT NULL,
[NOMALU] [nvarchar](150) NULL,
[APEALU] [nvarchar](150) NULL,
[CICLO] [nchar](10) NULL,
[TURNO] [nvarchar](50) NULL,
[CODCAR] [nchar](10) NULL,
CONSTRAINT [PK_ALUMNOS] PRIMARY KEY CLUSTERED
(
[CODALU] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CARRERAS](
[CODCAR] [nchar](10) NOT NULL,
[NOMCAR] [nvarchar](150) NULL,
CONSTRAINT [PK_CARRERAS] PRIMARY KEY CLUSTERED
(
[CODCAR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

Solicitar código fuente a:
cgprognet@hotmail.com
cgprognet@gmail.com
 

1 comentario: