Checking for Null in Function ?

  • Thread starter Thread starter luqman
  • Start date Start date
L

luqman

How can I check if dv recordcount isNull ?

Best Regards,

Luqman

Function showRecords(byVal ItemID as Int16) as String
Dim SqlArg as New DataSourceSelectArguments
Dim dv As New System.Data.DataView
dv=sqlDatasource.Select(SqlArg)

If dv.Item(0).Rows.Count.Equals(System.DBNull.Value) then Exit Function

Dim drRow asSystem.Data.DataRow=dv.Item(0).Row <---- Null Exception Error
in this Line

if drRow(0)>0 then
showRecords="yes"
End If

End Function
 
How can I check if dv recordcount isNull ?

Best Regards,

Luqman

Function showRecords(byVal ItemID as Int16) as String
Dim SqlArg as New DataSourceSelectArguments
Dim dv As New System.Data.DataView
dv=sqlDatasource.Select(SqlArg)

If dv.Item(0).Rows.Count.Equals(System.DBNull.Value) then Exit Function

Dim drRow asSystem.Data.DataRow=dv.Item(0).Row <---- Null Exception Error
in this Line

if drRow(0)>0 then
showRecords="yes"
End If

End Function
Click to expand...

dv.Item(0).Rows.Count cannot be null

A dataview I suppose can be a null

but just check if number of rows is more than 0

If dv.Item(0).Rows.Count = 0 then Exit Function
 
Hi,

I also checked using If dv.Item(0).Rows.Count = 0 then Exit Function but
still its raising Null Exception.

Best Regards,

Luqman
 
Hi David,

Thanks a lot, I just figured out that I was not passing a parameter value to
my Sql Data Source.

Best Regards,

Luqman
 
That can happen if you have no tables in your dataview.

You need to check earlier than your DV, or you could stick a try/catch
around this line.

--
Best regards,
Dave Colliver.http://www.AshfieldFOCUS.com
~~http://www.FOCUSPortals.com- Local franchises available








- Show quoted text -
Click to expand...

Try to add this

If IsNothing(dv.Table) Then Exit Function

Note, that Exit Function will return nothing from your function.
Maybe it is better to Return String.Empty or any other value...
 
Back
Top