V
VMI
In my datatable, I'm retrieving three fields from an Access table and I
concatenate them into one string. Then I put this information in another
datacolumn that I added to the datatable (with DataColumn.Expression).
Unfortunately, when one's a Null, apparently it makes the whole string a
Null and that's what's seen in the grid.
This is what I use:
DataColumn col_input = new DataColumn("Input");
col_input.DataType = System.Type.GetType("System.String");
col_input.Expression = "InFBU + ' \r\n' + InDel + '\r\n' + InCity + ' '" +
"+ InState + ' ' + InZIP + '-' + InAddon";
But in most cases, InAddon will be null so, when I display col_input in my
grid, it only displays the value null.
What can I do to avoid this?
concatenate them into one string. Then I put this information in another
datacolumn that I added to the datatable (with DataColumn.Expression).
Unfortunately, when one's a Null, apparently it makes the whole string a
Null and that's what's seen in the grid.
This is what I use:
DataColumn col_input = new DataColumn("Input");
col_input.DataType = System.Type.GetType("System.String");
col_input.Expression = "InFBU + ' \r\n' + InDel + '\r\n' + InCity + ' '" +
"+ InState + ' ' + InZIP + '-' + InAddon";
But in most cases, InAddon will be null so, when I display col_input in my
grid, it only displays the value null.
What can I do to avoid this?