Datagrid null value

Question

I am using .net 2003....

I am fetching record from oracle server using sp bind it to my datagrid...

In DB table some textboxes are null(blank).Its shows[null] in the datagrid how to i remove this null from my datagrid.Can anyone help with code?

Answer 1

in the Designer view, click on the grid, then click on the little arrow at the top right of the control.  This will open a "pop-up" window.  Choose "Edit Columns".  For the columns that you will have null, there is a property called "DefaultCellStyle".  click that and open the next window and you will see a property for "Null Value".  this value is what will show if the value is null.

or, the simpler method, don't allow nulls to come from the database.  Use Oracle's NVL() method to set a "default" value to if there is a null value.

ex.

SELECT
NVL(Customer_Name, ' ') AS 'Customer Name'
FROM Customer

that will return a blank space if the customer name is null. 

It's never good practice to have null values coming from a database query.