Hi to all,

I have table student in which I inserting first name,middle name, last name in 3 different columns. but when i want to show it in gridview I want to join three columns into only one heading "Name".
Is it possible...?
or any other way to show it..?

Recommended Answers

All 2 Replies

have u tried playing around with the smart tag arrow on the gridview? u should be ble to get an option which prompts u to select those fields u want displayed, i dont have ASP.net on my machine,therefore rilly cabt say much but just a pinch of what i had done before.
Hala back

Hi to all,

I have table student in which I inserting first name,middle name, last name in 3 different columns. but when i want to show it in gridview I want to join three columns into only one heading "Name".
Is it possible...?
or any other way to show it..?

why dont you try to manipulate the sql query

Select FirstName + ' ' + MiddleName + ' ' + LastName As [Name] From Student
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.