Re: [Firebird-net-provider] Whitespaces in Datagridview/Dataset

[nieurig <ni...@ya...>]

Hello Daniel,
use varchar instead of char at the create statement of your table. That 
should solve the problem.

Niels

Daniel Hahn schrieb:

>Hello all.
>
>I’m using Firebird .NET Provider 1.7, fembedded.dll and Visual Basic 
>Express 2005, and I have the following problem: I use a datagrid to show 
>the content of my datatables (datagridview <> fbdataadapter <> 
>fbconnection) – and the values in the fields of the datagrid get 
>filled up with whitespaces.
>
>Example:
>
>Table “cars”
>ID | NAME | COLOR
>1     FORD    RED
>2     GOLF    GREEN
>3     JETTA   YELLOW
>
>ID – unique, primary, int
>NAME – char(100)
>COLOR – char(20)
>
>
>The values of the table are shown correctly in the DGV but with 
>whitespaces after the text, so “FORD” is shown as 
>“FORD                                                                          “.
>
>Does someone have an idea why this happens?
>
>Thank you!
>
>Regards,
>Daniel
>
>-------------------------------------------------------------------------
>Take Surveys. Earn Cash. Influence the Future of IT
>Join SourceForge.net's Techsay panel and you'll get the chance to share your
>opinions on IT & business topics through brief surveys - and earn cash
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>_______________________________________________
>Firebird-net-provider mailing list
>Fir...@li...
>https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>  
>




	
		
___________________________________________________________ 
Der frgel ft den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: http://mail.yahoo.de