count of rows

ashokparchuri · April 18th, 2005, 11:03 PM

hi,

  i am getting data from database upto that it is ok for me.i want to count the number of rows.if there are no rows present in the database i want to display some message in label... hoew to do that.

    note: please don't say we can do that by select count(*) method. please tell me any other method.with out using sql commands.

                                thanks in advance-Ashok Parchuri

ashu_from_india · April 18th, 2005, 11:18 PM

hi

if u dont want to use SQL command then, u can use a DataTable object.
u can get no. of rows by DataTable.Rows.Count

Ashu

Imar · April 19th, 2005, 01:12 AM

Hi there,

Check out this FAQ: http://Imar.Spaanjaars.Com/QuickDocId.aspx?QUICKDOC=356

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

cbrknight1 · April 19th, 2005, 11:19 AM

RS = clsSqlHelper.ExecuteDataset(clsSqlHelper.DBConnStr ing, CommandType.Text, strSQLQuery)

            If RS.Tables(0).Rows.Count > 0 Then
                Debug.WriteLine(RS.Tables(0).Rows.Count.ToString)
                Return RS
            Else
                 ......

i THINK IT WILL HELP

--Alex Z.