How to trap null value

[ch3ri3ja80n]

Hi All,

I have a datagrid which has few columns that are of the datetime type. I wanted to format these columns so that it will only display the date. The code below works fine when there is dates in the sql database, however it prompts an error if the field is null.. Please help..

Private Sub dgRecords_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles dgRecords.ItemDataBound

Dim str10 As String = e.Item.Cells(10).Text.Trim
Dim str11 As String = e.Item.Cells(11).Text.Trim

If e.Item.ItemType = ListItemType.AlternatingItem Or _
e.Item.ItemType = ListItemType.Item Then

If e.Item.Cells(10).Text <> "1/01/1900 12:00:00 AM" Then
e.Item.Cells(10).Text = str10.Substring(0, 10)
Else
e.Item.Cells(10).Text = " "
End If

If e.Item.Cells(11).Text <> "1/01/1900 12:00:00 AM" Then
e.Item.Cells(11).Text = str11.Substring(0, 10)
Else
e.Item.Cells(11).Text = " "
End If
End If
End Sub

[radcaesar]

Whats the DB u r using?

Is it SQLServer or Access.

Since the column is DateTime type, Set ssome default value if u have no problem.

Set the Required field to NO (Access). I Thought that Allow NULL is not available here.

How did u get the date from the user ? Using DateTime Picker?

[ch3ri3ja80n]

Whats the DB u r using?

Is it SQLServer or Access.

Since the column is DateTime type, Set ssome default value if u have no problem.

Set the Required field to NO (Access). I Thought that Allow NULL is not available here.

How did u get the date from the user ? Using DateTime Picker?

Hi!

I'm using sql database. I didn't use DateTimePicker, instead i use a textbox for user input and a compare validator to validate the 'date' format.

I got the solution d.. The code is as below..

If e.Item.Cells(18).Text <> "1/01/1900 12:00:00 AM" _
And e.Item.Cells(18).Text <> "&nbsp;" Then
e.Item.Cells(18).Text = str18.Substring(0, 10)
Else
e.Item.Cells(18).Text = " "
End If

The trick is that, you have to trap an empty space in datagrid using the html format and not " " or Null or DBNull..

Neway thanks for sharing...

[anaphaxeon]

When I run a query and assign database values to members in a class I do the following

foreach(DataRow dr in dr.Rows)
{
strProperty =
Convert.ToString
(
(dr[0] == DBNull.Value)
?""
:dr[0].ToString()
);
}

I hope this helps!

[anaphaxeon]

Sorry, didn't notice your syntax is VB

[cadaha]

Hi

This is what I use:

If Not IsDBNull(dataField) Then
'do something
else
'do something else
end if

Regards

Carl