system.DBNULL

[Romain TAILLANDIER]

hi group

I use sqlCE in an application. I use dataGrid to print some data of my
database. when fields are empty, the datagrid print "(null)" at screen (wich
is i guess the .to string of a system.dbnull). i want it to print ""
(nothing or a space)

how can i do ?
thanks guys

ROM

 

[Michel Renaud]

I use sqlCE in an application. I use dataGrid to print
some data of my

database. when fields are empty, the datagrid print "(null)" at screen (wich
is i guess the .to string of a system.dbnull). i want it to print ""
(nothing or a space)

You need to use a DataGridTableStyle and set each
properties for each column using DataGridTextBoxColumn
(the "nulltext" property of DataGridTextBoxColumn is what
will allow you to display nothing instead of "(null)")

The help for DataGridTableStyle/DataGridTextBoxColumn
should get you started. It's a bit tedious at first, but
once it's done, it's done.

 

[Alex Feinman [MVP]]

Set CoulmnStyle.NullText to ""

 

[Romain TAILLANDIER]

thanks you guys

this is exactly what i needed a simple and rapid reponse !

ROM