Insert carriage return/line feed with C# and ADO.NET

[Torsten Zachert]

I would like to insert some text with embedded carriage return/line feed
into a MS Access text field with OleDb and C# ADO.NET. I tried to use "\n"
in combination with "\r". If I display the input in a text field I only see
quads.

Tia

Torsten

 

[Dirk Goldgar]

I would like to insert some text with embedded carriage return/line
feed into a MS Access text field with OleDb and C# ADO.NET. I tried
to use "\n" in combination with "\r". If I display the input in a
text field I only see quads.

What do you mean by "quads"? I'm not familiar with C#, but I know C, so
if you post your code I may be able to dope it out. How are you
checking your results? If you're looking in a table datasheet, you may
not see a second line in the field unless you enter the cell and use the
arrow or End key. If you're looking in a text box on a form, make sure
the text box is tall enough to show multiple lines.

 

[Torsten Zachert]

What do you mean by "quads"? I'm not familiar with C#, but I know C, so
if you post your code I may be able to dope it out. How are you
checking your results? If you're looking in a table datasheet, you may
not see a second line in the field unless you enter the cell and use the
arrow or End key. If you're looking in a text box on a form, make sure
the text box is tall enough to show multiple lines.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Hi Dirk,

yes I have a multiline text box, but instead of the CRLF I see quadrats (non
visible character) between two words, where I inserted for instance "\n".

The code in nothing special:

string insertString = "thisString\n\r";
string query = string.Format("UPDATE tableXYZ SET textfield='{0}' WHERE
id=0", insertString);
oleDb1.ExecuteOleDbQuery(query, conn);

T.

 

[Dirk Goldgar]

yes I have a multiline text box, but instead of the CRLF I see
quadrats (non visible character) between two words, where I inserted
for instance "\n".

The code in nothing special:

string insertString = "thisString\n\r";
string query = string.Format("UPDATE tableXYZ SET textfield='{0}'
WHERE id=0", insertString);
oleDb1.ExecuteOleDbQuery(query, conn);

Access recognizes CR+LF as a new-line, but not LF+CR. Try reversing the
order of the escape sequences:

string insertString = "thisString\r\n";

 

[Torsten Zachert]

I would like to insert some text with embedded carriage return/line feed

into a MS Access text field with OleDb and C# ADO.NET. I tried to use "\n"
in combination with "\r". If I display the input in a text field I only see
quads.

These 3 variants ar possible:

1.) Convert.ToChar(13).ToString() + Convert.ToChar(10).ToString()

2.) "\r\n"

3.) Environment.NewLine

I think the last one is the best one.

 

[Dirk Goldgar]

These 3 variants ar possible:

1.) Convert.ToChar(13).ToString() + Convert.ToChar(10).ToString()

2.) "\r\n"

3.) Environment.NewLine

I think the last one is the best one.

Do I take it that they all work? Not knowing C#, I could only guess at
the second one.