Richtext control characters "@"

[Lee]

Hi,

When reading a number richtext strings back from a database c# adds
the @ operator to the string, the effect being all the control
characters are ignored and the string cannot be added to a richtextbox.
I'm using a stored procedure to get the data and the data type is
varchar in the database and stored procedure.

Any assistance on suppress c# from adding the @ operator would be much
appreciated. Code shown below:

Thanks
Lee

SqlCommand sqlComm = new SqlCommand();
SqlDataReader sqlData = null;

sqlData = sqlComm.ExecuteReader ();

/ Obtain all the data.
while (sqlData.Read())
{
if (sqlData["Text"] != DBNull.Value)
{
m_text = sqlData["Text"].ToString(); // m_text has @
preceeding the string.
}
}

[Dave Sexton]

Hi,

C# isn't adding anything to your strings.

In the debugger, you may see the verbatim literal string character, @, added
outside of the string. That @ character tells C# (and the debugger) to
ignore escape sequences in the string that follows, such as, \n, instead of
processing them.

The value of your m_text variable is what was retrieved from
sqlData["Text"].ToString() regardless of the way it's being presented to you
in the debugger.

--
Dave Sexton

"Lee" <le*******@handbag.comwrote in message
news:11*********************@45g2000cws.googlegrou ps.com...

Hi,

When reading a number richtext strings back from a database c# adds
the @ operator to the string, the effect being all the control
characters are ignored and the string cannot be added to a richtextbox.
I'm using a stored procedure to get the data and the data type is
varchar in the database and stored procedure.

Any assistance on suppress c# from adding the @ operator would be much
appreciated. Code shown below:

Thanks
Lee

SqlCommand sqlComm = new SqlCommand();
SqlDataReader sqlData = null;

sqlData = sqlComm.ExecuteReader ();

/ Obtain all the data.
while (sqlData.Read())
{
if (sqlData["Text"] != DBNull.Value)
{
m_text = sqlData["Text"].ToString(); // m_text has @
preceeding the string.
}
}

[Jon Skeet [C# MVP]]

Lee <le*******@handbag.comwrote:

When reading a number richtext strings back from a database c# adds
the @ operator to the string, the effect being all the control
characters are ignored and the string cannot be added to a richtextbox.

No, it doesn't. What you're seeing is the debugger trying to help you.

See http://www.pobox.com/~skeet/csharp/s....html#debugger

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too