DataGird replace <NULL> value

This may be an alternate way not sure if it works with e arguments or not, but I assume it will

  If IsDbNULL(e.Item.Cells(0).Text) Then
                e.Item.Cells(0).Text = "Not defined"
  End If

The way I've to do sometimes is with checking out for "" (empty string) and &nbsp; (space)...
Following is the code for that..
----------------------------------------------------------------------------------------------------------------
private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
     switch( e.Item.ItemType )
     {
          case ListItemType.Item:
          case ListItemType.AlternatingItem:

          if( e.Item.Cells[0].Text == "" || e.Item.Cells[0].Text == "&nbsp;" )
                {
                     e.Item.Cells[0].Text = "0";
                }

          break;
     }
}
----------------------------------------------------------------------------------------------------------------

-tushar

or alternately you could specify this in your SQL before you bind the grid.

Thanks, do you know what the C# code would be like

If have tried

if (e.items.cells[0].text == DbNull) >>> error that DbNull is an class also tried DbNull.value ..cannot compare string to bool


also tried

if (e.items.cells[0].text == null)  >> nothing  so to if i replace null with ""..


When i do a len on the text it is = 6 , this point to the fact that that the system does get "<NULL>"  from database

if (IsDbNULL(e.Item.Cells(0).Text)) {
 e.Item.Cells(0).Text = "Not defined";
}

The C# code for checking DBNull would be like following:

if (IsDbNULL(e.Item.Cells(0).Text)) {
 e.Item.Cells(0).Text = "Not defined";
}

-tushar

ahh.. too quick Aeros..

hehe;)

Correction...

The C# code for checking DBNull would be like following:

if (IsDbNULL(e.Item.Cells[0].Text)) {
 e.Item.Cells[0].Text = "Not defined";
}

-tushar

square brackets I should have notice that

IsDbNull does not exsits for c#!

hehe yay vb;)

The C# equivalent is as follows:

if (e.Item.Cells[0].Text != null)
{
 e.Item.Cells[0].Text = "Not defined";
}


Best, Nauman.

You can put it right in your SQL query if you want, post the code and I'll show you how.

The SQL function COALESCE(a,b) will return the first non-null response.
An example:
SELECT
  COALESCE(Name,'Not Given'),
  COALESCE(Age,0),
  COALESCE(Date,'9/9/99')
FROM table