SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 04:33 PM
| ||||
| ||||
 Trailing spaces in char fields with ADO.Net and OleDB I use the ado.net IdxConnection to connect to an informix database. Unfortunately every field of type char in the dataset has trailing blanks. How can I get rid of them? (In DbExpress I could put "trim char=true" in the connectionstring.)      |
|
04-20-2008, 04:33 PM
| ||||
| ||||
| Re: Trailing spaces in char fields with ADO.Net and OleDB On Feb 14, 2:14*am, "Philippe Requilé" <Philippe.Requ...@falcon.be.nospamplease> wrote: > I use the ado.net IdxConnection to connect to an informix database. > Unfortunately every field of type char in the dataset has trailing blanks. > How can I get rid of them? > > (In DbExpress I could put "trim char=true" in the connectionstring.) Depending on the size and scope of your application, you might want to look at the DevForce framework from IdeaBlade (www.ideablade.com). It is fantastic for building Windows forms applications and works just fine with Informix (using OleDB and ADO.Net, if you wish). They have an express version (without the Business Objects Server) that is free. They are sharp folks who understand good application architecture and are on top of the most important technologies from Microsoft. The OR-mapping part of the framework will handle trimming and also nulls. You need to dig into the framework to see all the benefits. Too many to list here. Read the Concepts Guide from their web site to get the best overview. |
Linear Mode
