Null dataset to asp.net datagrid

[born2program]

I have a small web application that reads from a sql server database and displays results in a data grid. Everything works fine until there is no data in the dataset. What is the best way around this. I have included the function below that reads from the dataset. Any help appreciated. Thanks.

Private Sub LoadChecksToPrint()
        Dim objDataHandler As New DataHandler
        Dim objGetChecksDataSet As New DataSet
        Dim objGetChecksDataView As New DataView


        objGetChecksDataSet = objDataHandler.getChecksToBePrinted(strDepartment)

        If objGetChecksDataSet.Tables(0).Rows.Count <> 0 Then
            objGetChecksDataView = objGetChecksDataSet.Tables.Item(0).DefaultView
            dgOverpay.DataSource = objGetChecksDataView
            dgOverpay.DataBind()
        Else
            Exit Sub
        End If
    End Sub

 

[jbenson001]

Everything works fine until there is no data in the dataset.

What do you mean by this..? Are you getting an error?

 

[born2program]

I'm sorry. Yes, I get the following error on the If statement line. Thanks.

Object reference not set to an instance of an object. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.


NullReferenceException: Object reference not set to an instance of an object.]
   WebApplication1.PrintChecks.LoadChecksToPrint() in C:\Inetpub\[URL unfurl="true"]wwwroot\WebApplication1\Default.aspx.vb:112[/URL]
   WebApplication1.PrintChecks.btnNumbExportedOK_Click(Object sender, EventArgs e) in C:\Inetpub\[URL unfurl="true"]wwwroot\WebApplication1\Default.aspx.vb:305[/URL]
   System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   System.Web.UI.Page.ProcessRequestMain()

 

[jbenson001]

By the looks of the trace, the error is in
btnNumbExportedOK_Click..

You will have to trace through you code and see where the error occurs.

 

[jshurst]

Try this.

If Not objGetChecksDataSet is Nothing Then

If objGetChecksDataSet.Tables(0).Rows.Count <> 0 Then...

End If

 

[born2program]

Thanks. That did it.

 

[jshurst]

NP.