Select statement To display each row as colum for Gridview control

[User 4005525]

Hi, I Have two tables. Table1 has the following columns: TableID FieldID FieldName FieldValue DateAdded and Table2 has the following Columns FieldID TableID Dataadded And I want to display Each FieldName as a Column name for Dridview control and FieldValue as Value for each column. How can i form SELECT Statement To Achieve this ? Thanks in advance sri

[Ashfield]

Your select will give you the column names and data in the format you are looking for, you just need to bind the result to your gridview

Bob Ashfield Consultants Ltd

[Atif Ali Bhatti]

Assalam-0-alaikum, quite strange question. n e way, would u mind elaborating a bit more as the question is not clear. Regards Atif Ali Bhatti.