Dear Sir,

Need your urgent basis help. I want to display 5-table data values in a GridView. This is possible form join statement but i unable to do this. Please help me sir.

CREATE TABLE [dbo].[emp] (
    [Id]         INT           IDENTITY (1, 1) NOT NULL,
    [emp_id]     NCHAR (10)    NULL,
    [emp_nm]     VARCHAR (50)  NULL,
    [dept]       VARCHAR (20)  NULL,
    [mbl_no]     NCHAR (12)    NULL,
    [PROJECT_ID] NVARCHAR (10) NULL,
    [password]   NVARCHAR (50) NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

CREATE TABLE [dbo].[nmr] (
    [Id]           INT           IDENTITY (1, 1) NOT NULL,
    [emp_id]       VARCHAR (10)  NULL,
    [emp_nm]       VARCHAR (50)  NULL,
    [dept]         VARCHAR (20)  NULL,
    [agncy]        VARCHAR (500) NULL,
    [lcn]          VARCHAR (500) NULL,
    [dsc]          VARCHAR (500) NULL,
    [dt]           VARCHAR (50)  NULL,
    [mnth]         VARCHAR (50)  NULL,
    [closing_date] VARCHAR (5)   NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

CREATE TABLE [dbo].[pptlk] (
    [Id]      INT           IDENTITY (1, 1) NOT NULL,
    [emp_id]  VARCHAR (10)  NULL,
    [emp_nm]  VARCHAR (50)  NULL,
    [dept]    VARCHAR (20)  NULL,
    [agncy]   VARCHAR (500) NULL,
    [lcn]     VARCHAR (500) NULL,
    [prtcpnt] NCHAR (10)    NULL,
    [dt]      VARCHAR (50)  NULL,
    [mnth]    VARCHAR (50)  NULL,
    [cls_flg] VARCHAR (5)   DEFAULT ('N') NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

CREATE TABLE [dbo].[sdor] (
    [Id]     INT           IDENTITY (1, 1) NOT NULL,
    [emp_id] VARCHAR (10)  NULL,
    [emp_nm] VARCHAR (50)  NULL,
    [dept]   VARCHAR (20)  NULL,
    [agncy]  VARCHAR (500) NULL,
    [lcn]    VARCHAR (500) NULL,
    [dsc]    VARCHAR (500) NULL,
    [cmplnc] VARCHAR (10)  NULL,
    [dt]     VARCHAR (50)  NULL,
    [mnth]   VARCHAR (50)  NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);