How to ...

  • Thread starter Thread starter Jacek Jurkowski
  • Start date Start date
J

Jacek Jurkowski

Im using table adapter to retrieve some data
from clients table (Vs.Net 2005). There is
a column "Name" char(50) with value "Mark".
Table adapter is filling a data table but the value
isn't just "Mark" but "Mark"+46 white spaces ...
How to specify that ADO net should parse string
values with Trim() executed on that?
 
You may want to change the datatype of the SQL table to varchar(50) so that
the name values are not padded. This assumes you have ANSI_PADDING turned
on.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Im using table adapter to retrieve some data
from clients table (Vs.Net 2005). There is
a column "Name" char(50) with value "Mark".
Table adapter is filling a data table but the value
isn't just "Mark" but "Mark"+46 white spaces ...
How to specify that ADO net should parse string
values with Trim() executed on that?
 
Back
Top