asked
Dynamic new line to be inserted in data of text file that is exported through asp.net,database is sql server
I have a table A structure is given below where in If I export said table data to notepad or a file format .123,It should be exported in said file format ,according to column, I need to export data table a(col1,col2,col3,col4,col5,) For Ex-> I need to export data of col1,col2 and col3 in one line and data of col4 and col5 in next line Note -> Data between col1,col2 and col3 should not contain space in between them. Data is -> col1 col2 col3 col4 col5 1 2 3 4 5 Exported file should contain data as below-> 123 45 Thanx in advance Immediate reply would be apreciated
you can use query like SELECT ISNULL(CAST(col1 as VARCHAR(50)),'')+ISNULL(CAST(col2 as VARCHAR(50)),'')+ISNULL(CAST(col3 as VARCHAR(50)),'')+ CHAR(13) + CHAR(10) +ISNULL(CAST(col4 as VARCHAR(50)),'')+ISNULL(CAST(col5 as VARCHAR(50)),'') FROM yourtable
