我有一个回复我的sp：
Select 10 as Visits,5 as [Test_Drives],3 as Orders,'£5000' as [Profit_£],4 as Deliveries,'£6000' as [Delivered_Profit_£]
FOR XML PATH('CONTENT'),ROOT('SOMEROOT')
但是当我使用ouptut时
Dim dr As New sqlDataAdapter(sqlCmd) Dim tbl As New DataTable dr.Fill(tbl)
我收到一个错误
Column name ‘Profit_£’ contains an invalid XML identifier as required by FOR XML; ‘£'(0x00A3) is the first character at fault.
问题是我需要一个原始名称列.
我怎么能解决这个问题呢？
