c# - Non breaking spaces(160) instead of spaces (32) in tableadapter of strongly typed dataset -

c# - Non breaking spaces(160) instead of spaces (32) in tableadapter of strongly typed dataset -

i can not understand why replaced simple space in field of sql server table non-breaking space. have dataset, made visual c# designer, read info sql server table, , when field has many spaces (ascii 32) replace nonbreaking spaces (160).

from dataset: x_--/----xxx/x/_-

from sql server: x___/_____xxx/x_/__

"_" simple space (32)

"-" non breaking space.

can help me?

maybe related locale / cultureinfo? tried without success ...

i have searched , there lot of info how replace nbsp need recover info sql server in way how on it, spaces (ascii 32). of import me because field primary key , not working relation table.

thanks in advance. jorge.

i want add together 2 testing have made.

1- when utilize line code info sql server table, same error:

string query = "select * repuestos repuestoid < 40000"; using (sqlconnection sqlconn = new sqlconnection("data source=127.0.0.1;uid=sa;pwd=xxxx;database=base;")) using (sqlcommand cmd = new sqlcommand(query, sqlconn)) { sqlconn.open(); dt.load(cmd.executereader()); } datagridview1.datasource = dt;

2- , more important, when these things in machine code in right way. seems computer causing this.

computer error: windows xp sp3, visual express c# 2008, language spanish computer ok: windows 7 home edition sp1, visual express c# 2008, language english

please can help me? thanks!

c# sql-server visual-studio strongly-typed-dataset