Char (#13) not work in gridview

Question

1.00/5 (1 vote)

See more:

Hi ,
i use

SQL

SELECT @columns=STUFF((SELECT DISTINCT ',    '+QUOTENAME(examid)+' AS '+ QUOTENAME(DayName +  CHAR(13)  + CONVERT(Nvarchar(10),(exammonth)) +'/'  + CONVERT(Nvarchar(10),(examday)) )
 FROM  examsTB  where act =1  GROUP BY DayName,examday,exammonth,examid  for XML Path(''),Type).value('.','Nvarchar(MAX)'),1,2,'') ;

to view the header in gridview two line

But not work .

What I have tried:

C#

RowHeaderColumn="2"

Posted 25-Dec-17 3:23am

Member 12857222

Updated 28-Dec-17 2:04am

Add a Solution

Comments

Nakhia_ind 26-Dec-17 4:09am

give the details code like funcion QUOTENAME

Karthik_Mahalingam 26-Dec-17 8:53am

QUOTENAME (Transact-SQL) | Microsoft Docs[^]

Member 12857222 27-Dec-17 6:02am

I am sorry i not understand

Richard MacCutchan 26-Dec-17 7:20am

What does "not work" mean?

Member 12857222 27-Dec-17 6:01am

It is mean:
The header of gridview is supposed to appear on two lines
But the header of gridview appears on only one line

Nakhia_ind 27-Dec-17 10:42am

In header templete make wrap text

Sinisa Hajnal 28-Dec-17 2:39am

You want CHAR(10)+CHAR(13) (wild guess :) )

1 solution

Add a Solution

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

ZurdoDev · Accepted Answer · 2017-12-28T02:04:00

Solution 2

Depends on what type of gridview so you need to provide more information. If this is a windows forms gridview then the answer is in the comments, use Chars 10 and 13. If this is a webgridview you need to use the code for a new line in html which is <br/>.

Posted 28-Dec-17 2:04am

ZurdoDev

Char (#13) not work in gridview

1 solution

Solution 2

Add your solution here

Preview 0

Char (#13) not work in gridview

1 solution

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us