StrataFrame Forum » .NET Forums » General .NET Discussion » dataset showing count as 1 when should be 0

dataset showing count as 1 when should be 0

Diu King,Tiong — Thu, 27 Jan 2011 06:18:21 GMT

Hi all,

I query the data and fill into my dataset, there is 0 record found but my dataset.table(0).rows.count = 1.
Please advice how do i detect if no record find with the dataset?

Thanks

RE: dataset showing count as 1 when should be 0

Trent L. Taylor — Thu, 27 Jan 2011 06:18:21 GMT

Well, you would be mistaken in regards to performance. We have an extremely large medical application that deals with massive databases including an online portion of our product that deals with insurance formularies and over 400 million records, and we use business objects.

RE: dataset showing count as 1 when should be 0

Diu King,Tiong — Wed, 26 Jan 2011 22:05:30 GMT

Yes Trent, I'm not using strataframe in my blackbox's processing, I scare to use object will delay my processing time from my experience with other framework before.

RE: dataset showing count as 1 when should be 0

Trent L. Taylor — Wed, 26 Jan 2011 16:28:05 GMT

In this example, you are not using StrataFrame at all. Why aren't you using a business object to manage your connections, query, etc.? I am just trying to understand as the code you provided has nothing to with StrataFrame, so before we go to the next step, I just wanted to make sure that I wasn't missing something here.

RE: dataset showing count as 1 when should be 0

Diu King,Tiong — Wed, 26 Jan 2011 16:08:09 GMT

Hi Trent,

My coding like,

                            Dim ds5 As Data.DataSet = New Data.DataSet
                            Dim sqlcmd5 As SqlCommand = New SqlCommand("select max(cPybRefDoc) as maxno from hrptpaybat where iPybPeriod_FK = " & _
                                                                       tiPeriod_PK & " and left(cPybRefDoc,3) = 'SYS'", db.sqlconn)
                            sqlcmd5.Connection = db.sqlconn
                            sqlcmd5.Transaction = tran
                            sqlcmd5.ExecuteNonQuery()
                            Dim da5 As SqlDataAdapter = New SqlDataAdapter(sqlcmd5)
                            da5.Fill(ds5)
                            If ds5.Tables(0).Rows.Count = 0
                            ................................
                            ................................

even though there is no record queried but my dataset still showing 1 record with null value.

Regards

RE: dataset showing count as 1 when should be 0

Trent L. Taylor — Wed, 26 Jan 2011 09:01:52 GMT

Do you have a filter applied to your BO or did you call the Add or NewRow of the BO? If not, then what does your query look like and code that is retrieving the data?