In grid view in more than one table values should bind in one column in GridView1.

See more:

ASP.NET

SQL-Server

1.fileInfo

CREATE TABLE [dbo].[fileInfo](
    [fileId] [bigint] IDENTITY(1,1) NOT NULL,
    [userId] [bigint] NULL,
    [fileName] [nvarchar](50) NOT NULL,
    [fileType] [nvarchar](50) NOT NULL,
    [fileSize] [nvarchar](100) NOT NULL,
    [filePath] [nvarchar](200) NOT NULL,
    [createdOn] [datetime] NULL,
    [statusId] [bigint] NULL,
    [lastModifiedOn] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
    [fileId] 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

In grid View it will display ..
Combine with fileType and fileSize in same columns in GridView1..


This Output File:
fileName fileType fileSize filepath createdOn
Asp notes.docx .docx 13539 2013-04-04-05-52\ 4/4/2013 5:52:20 PM
Asp.net.docx .docx 14041 2013-04-04-05-52\ 4/4/2013 5:52:20 PM

I want Display Output like this in GridView1.Combine with fileType and fileSize in same columns in GridView1..

fileName fileType&fileSize filepath createdOn
Asp notes.docx .docx 13539 2013-04-04-05-52\ 4/4/2013 5:52:20 PM
Asp.net.docx .docx 14041 2013-04-04-05-52\ 4/4/2013 5:52:20 PM

display in the gridView1
filename,fileType&filesize,filepath,CreatedOn.

please say
 correct solution Friends!

Advance Thanks Friends!