如何在前端更改br/ [英] how to change br/ in front end

问题描述

我有一个gridview并从存储过程中获取记录.样本记录是

1 1 Medicine br/Medicine，Bayrocin br/LIvol PFS，10ml/100雏鸡br/1ml/1000chicks

我的问题是如何更改br/末尾.
现在我想要这样的记录
医药Bayrocin 10ml/100小鸡
药livolpfs 1ml/1000只小鸡


存储过程

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 + ','--  replace(left(scheduletype,len(scheduletype)-1),',','<br/>')

           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

推荐答案

我不认为有任何问题.只需从存储过程中将数据放入数据表中，然后将网格与该数据表绑定即可.
并且请确保网格列应与数据表的列相同！！

I Don''t think there is any kind of issue. Simply get the Data into datatable from the stored procedure and then bind the grid with that data table.
And pls make sure grid columns should be same as of data table!!.

这篇关于如何在前端更改br/的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！