Merge Columns in a Row in SQL Server

Sumeet

I am getting result as below:

I want to display it as below in Repeater :

Should I have to modify query to get required output? how should I do this?

dharmend...

0 3

Use GridView. Refer below article.

Sumeet

0 4

Sir can't we get this result set via query?

dharmend...

0 5

No, SQL result set shows in tabular form. You can't merge columns.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Add RowSpan to GridView in ASP.Net