0

Here is my count. Trying to check row count at of dataset but getting the error:

Object reference not set to an instance of an object at if (ds.Tables["GetCaseInformationByCaseStatusANDCaseNumber"].Rows.Count != 0).

Please help.

 using (SqlCommand GetCaseInformationByCaseStatusANDCaseNumberSP = new SqlCommand("GetCaseInformationByCaseStatusANDCaseNumberSP", Apptestconn))
 {
     GetCaseInformationByCaseStatusANDCaseNumberSP.CommandType = CommandType.StoredProcedure;
     GetCaseInformationByCaseStatusANDCaseNumberSP.Parameters.AddWithValue("@UserName", "nguyenlc");
     GetCaseInformationByCaseStatusANDCaseNumberSP.Parameters.AddWithValue("@CaseStatus", TextBox1.Text);
     GetCaseInformationByCaseStatusANDCaseNumberSP.Parameters.AddWithValue("@CaseNumber", CaseNumberTextBox.Text);
     GetCaseInformationByCaseStatusANDCaseNumberSP.ExecuteNonQuery();

     SqlDataAdapter da = new SqlDataAdapter(GetCaseInformationByCaseStatusANDCaseNumberSP);
     DataSet ds = new DataSet();
     da.Fill(ds, "GetCaseInformationByCaseStatusANDCaseNumberTable");
     ReviewCaseStatusListView.DataSource = ds.Tables["GetCaseInformationByCaseStatusANDCaseNumberTable"];
     ReviewCaseStatusListView.DataBind();

     if (ds.Tables["GetCaseInformationByCaseStatusANDCaseNumberTable"] != null)
     {
         if (ds.Tables["GetCaseInformationByCaseStatusANDCaseNumber"].Rows.Count != 0)
         {
             CaseUploadHistoryLabel.Text = "Case Upload History:";
             CaseUploadHistoryLabel.Visible = true;
          }

      }
}
Roman Marusyk
  • 19,402
  • 24
  • 55
  • 90

0 Answers0