如何以这种格式显示gridView [英] how to display gridView In this format

问题描述

嗨
我有一个存储过程..该存储过程是我在gridview中调用的..现在我的网格视图看起来像这样.

id名称关键条件运算符补充
1个jana公事J = OR
1个Jana Officialwork主页= OR
1个贾纳(Jana)个性作品J = OR
1个jana personalwork主页= OR

2 jana personainsure chemi = OR
2 Jana Officialainsure chemi = OR

现在我要这样显示
1如果办公室工作= J oR Home或officeVisit = J OR Home，则Dr.jain

我想显示我的网格视图如上..那是在id 4我有四行，我想把它像所有id一样用一句话表达出来..如何做到这一点..我没有一个主意..plz分享您的想法

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

推荐答案

使用COALESCE 将是执行 ^ ].

这篇关于如何以这种格式显示gridView的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！