i have a gridview of months in that gridview column name is month and records are like 1 6 0 7 etc. i want "month" after every record for eg 1 month 6 month 0 month 7 month etc. how to do code for the above ? thanks subin

Hello, If you get the record from sql query, you can add your string after the number. And if datatype is int than you have to convert it into nvarchar() . i.e. SELECT CONVERT(NVARCHAR(10),MONTH) + ' Month' as Months FROM

i am getting an error of Conversion failed when converting the varchar value 'Month' to Data type int sql ↓ select case when (DATEDIFF(MONTH,SYSDATETIME(), a.[Project enddate]))

Hi Subin, As Piyush told you can format data in query and bring in UI But in future if you want to do DML operation like update month values then you take two different lable in single column of gridview.