Click here to Skip to main content
15,891,841 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
I have a store procedure..that store procedure i called in a gridview ..now my grid view look like this.

id name key condition operator supplement
1 jana officialwork J = OR
1 jana officialwork Home = OR
1 jana personalwork J = OR
1 jana personalwork Home = OR

2 jana personainsure chemi = OR
2 jana officialainsure chemi = OR

now i want to display like this
1 If officaialwork = J oR Home or officeVisit = J OR Home then Dr.jain

i want to display my grid view look like the above..that is in id 4 i have four rows that i want to club it as one sentence same like all id.. how to this..i didnt have a idea..plz share ur ideas
Posted
Comments
Aswathi Narayan 16-Jul-11 1:19am    
i cant get u.. pls explain

1 solution

Using COALESCE would be one way to do this[^].
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900