Data reader Display issue

Question

Using c# with a windows form to read data from a data base.

     while (reader.Read())
                {
                    textbox1.Text += reader["Person"] + reader["Occur"].ToString() + "\n";                    
                }

Can somebody clear up why this displays like:

    John
     8

Instead of:

    John 8

EDIT: these are just an example of what's in my database table

are they stored as strings in the database ? are there trailing carriage returns at the end of values in the person column. — Eoin Campbell, Apr 30 '12 at 23:23
@user1353517: What Eoin Campbell wanted to say is that you probably have stored [carriage returns](http://en.wikipedia.org/wiki/Carriage) in your `Person` field. That would explain the word wrap after `reader["Person"]`. — Tim Schmelter, Apr 30 '12 at 23:29
@user1353517: You shouldn't store it. So before you store the person name, you should remove the carriage returns and line feeds from the end of the string: `name = name.TrimEnd('\r', '\n');` — Tim Schmelter, Apr 30 '12 at 23:36

score 1 · Accepted Answer · answered Apr 30 '12 at 23:33

1

I think that there is a carriage return stored with strings in the database. so you can easily get rid of it.

textbox1.Text += reader["Person"].ToString().Trim() + reader["Occur"].ToString();

answered Apr 30 '12 at 23:33

Sleiman Jneidi

22,907
14
56
77

Data reader Display issue

1 Answers1