Monday, 26 December 2011

Database for GridView

Create Database emp and Then Execute the tables
USE [emp]
GO
/****** Object:  Table [dbo].[empdetails]    Script Date: 12/27/2011 10:30:14 ******/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[empdetails](
    [empno] [int] IDENTITY(1,1) NOT NULL,
    [empname] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [empcode] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [department] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [salary] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [gender] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [skill] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [project] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF



USE [emp]
GO
/****** Object:  Table [dbo].[department]    Script Date: 12/27/2011 10:29:15 ******/

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[department](
    [department] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF


USE [emp]
GO
/****** Object:  Table [dbo].[projects]    Script Date: 12/27/2011 10:30:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[projects](
    [projectname] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
       

No comments:

Post a Comment