Handle NULL in datagrid

[eramgarden]

I have a datagrid that displays NULL when the field in the database is NULL. I want it to display blank.

 

I have searched Google for examples and whatever I've found talks about:

 

DataGridColumnStyle,TableStyle..etc.

 

The DataGridColumnStyle class allows you to change the "(null)" text. You

will have add a TableStyle to your datagrid, and add ColumnStyles to the

TableStyle. Look at the TableStyles property of the datagrid.

 

OR

 

Add a DataGridTableStyle to your grid. Then in the DataGridColumnStyle for

the column in question, set its NilLText property to whatever you want.

 

OR

One way to do this is by Using DataGrid Table Styles Collection . After

Setting Datasource and DataMember of Grid , Click on the TableStyles

Collection editor of DataGrid Add a new TableStyle and Set the Mapping name

to your TableName . Click on the GridColumnStlyes Collection Editor and Add

DataGridTextBoxColumns to Column Style Collection Editor. . Each

DataGridTextBoxCOlumn has a Property called Nul text , You can remove the

null there so that it will be shown as Empty .

 

But WHERE is this info..tablestyle, datagridtextboxcolumns...etc they're talking about. I cant add it thru HTML or code behind or GUI of my datagrid...

 

Going nuts..

[MorningZ]

is changing the SQL an option??

 

Instead of

SELECT Column FROM Table

say:

SELECT IsNull(Column,' ') As Column FROM Table

 

then you don't have to worry about the difference between NULL and Empty String

[eramgarden]

oh man, thanks so much, i spent so much time on this...bad day.