Hi,
I have one gridview and get the records from stored procedure. The sample record is
1 1 Medicine br/ Medicine , Bayrocin br/ LIvol PFS , 10ml/100 chicks br/ 1ml/1000chicks
My problem is how to change the br / in frond end.
Now i want records like this
medicine bayrocin 10ml/100chicks
medicine livolpfs 1ml/1000chicks
stored procedure
select age,replace(left(type,len(type)-1),',','<br/>') as scheduletype,
replace(left(name,len(name)-1),',','<br/>') as name,
replace(left(dose,len(dose)-1),',','<br/>') as dose from
(SELECT p1.age,
( SELECT scheduletype + ','
FROM k_Master_Scheduletype p2
WHERE p2.age = p1.age
ORDER BY scheduletype
FOR XML PATH('') ) AS type,
( SELECT name + ','
FROM k_Master_Scheduletype p2
WHERE p2.age = p1.age
ORDER BY name
FOR XML PATH('') ) AS name,
( SELECT dose + ','
FROM k_Master_Scheduletype p2
WHERE p2.age = p1.age
ORDER BY dose
FOR XML PATH('') ) AS dose
FROM k_Master_Scheduletype p1
GROUP BY age) a
END
GO