how can I count Number of records in dataset

Discussion in 'C#' started by kharearch, Sep 7, 2008.

0
  1. #1
    please tell me How can I count number of records in dataset ? Thanks.
     
    kharearch, Sep 7, 2008 IP
  2. 50plus

    50plus Guest

    Messages:
    234
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Select * from table

    Response.write rs.RecordCount
     
    50plus, Sep 7, 2008 IP
  3. justkidding

    justkidding Active Member

    Messages:
    937
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #3
    select count(*) as count from table

    response.write rs.fields("count")
     
    justkidding, Sep 8, 2008 IP
  4. gramyla

    gramyla Peon

    Messages:
    71
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    first you have to select the table then count it by query you can do it easily.
     
    gramyla, Sep 16, 2008 IP
  5. vihutuo

    vihutuo Well-Known Member

    Messages:
    1,511
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    180
    #5
    In asp.net
    dataset.tables(0).rows.count
     
    vihutuo, Sep 16, 2008 IP