I am particularly interested in keeping a linebreak between paragraphs and the only way I can think to do that is to put each paragraph in its own row. But I want some input before I undertake that substantial task.
Thanks for any help provided.
You can use char(10) which is the hard break in SQL.
eg.
Code Snippet
Print 'Microsoft' + char(10) + 'Website'
The Output is like below:Microsoft
Website
You can as many as char(10) to provide line break in your query.
Even the below syntax will also work.
Code Snippet
select 'Microsoft' + char(10) + 'Website'
|||Hi Vidhya. Thanks for your advice.I am trying to understand how to insert the data into a table and retrieve to a control on a VB form. In Visual Basic Express I tried including the char(10) with the data by pasting it into my table like this:
Paragraph 1 text here. + char(10) + Paragraph 2 text here. + char(10) + Paragraph 3 text here.
But all I get for output in my datagrid control is the literal string as one block of text.
I use a similar technique with html tags (
) if I am outputing to a webcontrol and it seems to work okay if the control renders html (ie.,
Paragraph 1 text here
Paragraph 2 text here
Paragraph 3 text here
). But this doesn't work for Windows forms unless I am using a webbrowser control and html controls (which I don't want to do).So I opened up SQL Server Management Studio Express and created a database with a table (text) and column (paragraph) and ran these scripts:
INSERT INTO Text (Paragraph)
VALUES ('Paragraph 1 text here.' + char(10) + 'Paragraph 2 text here.' + char(10) + 'Paragraph 3 text here.')
SELECT *
FROM Text
select 'Microsoft' + char(10) + 'Website'
From Text
But my output is still a single line of text without paragraph formatting.
When I run the code you provided (Print 'Microsoft' + char(10) + 'Website'), that works perfectly. But I don't know how to insert and retrieve the formatted text data in my db.
I am relatively new to SQL, so I realize that I am missing something simple in my implementation of your advice. Any suggestions on how to apply this concept is greatly appreciated.|||To Insert into table jus insert as usual
insert into <tablename> values('col1','col2')
To select from the table with char(10) you can use
select col1,char(10),col2 from <tablename>
Run the above query in text format(ctrl+t)
|||Thanks for the follow-up. I have had some success (I think). Here is what I have tried:
CREATE TABLE Paragraph
(ID int Primary Key IDENTITY(1,1) NOT NULL,
FormattedText nvarchar(500) NOT NULL)
INSERT INTO Paragraph (FormattedText)
VALUES ('Paragraph 1 text here.' + char(10) + 'Paragraph 2 text here.' + char(10) + 'Paragraph 3 text here.')
select FormattedText from Paragraph
If I have the "Results to Text" button clicked, the output looks great, like this:
Paragraph 1 text here.
Paragraph 2 text here.
Paragraph 3 text here.
If I output with "Results to Grid" clicked, it loses the format and looks like this:
Paragraph 1 text here. Paragraph 2 text here. Paragraph 3 text here.
So I think I am making progress. I am getting the data into my table ok. Getting it out in the proper paragraph format is the challenge, which is easy in Management Studio.
But when I use the same table in Visual Basic and output the row of data to a datagrid, it comes out like this, without the paragraph formatting:
Paragraph 1 text here. Paragraph 2 text here. Paragraph 3 text here.
So my problem now is how to get it to display properly on my Windows Form. Any thoughts on this, or do I need to switch to the VB forum?|||Im not sure abt VB. But i think there is a command "Break" in VB. Pls check
|||I will look into it further. There is a break property for creating menus, but I am not sure if it can be applied to datagrids or other controls for displaying formatted data.
Thanks again for your helpl.
