Rowcount from ObjectDatasource

Last post 07-09-2009 10:10 AM by amit.jain. 3 replies.

Sort Posts:

  • Rowcount from ObjectDatasource

    07-08-2009, 1:50 PM
    • Participant
      1,567 point Participant
    • craigbtx
    • Member since 10-01-2004, 4:50 PM
    • Posts 675

    How do I get the number of rows returned from an objectdatasource?

    e.AffectedRows doesn't seem to work.

    Thanks

    Protected Sub PrintCouponsObjectDataSource_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceStatusEventArgs) Handles PrintCouponsObjectDataSource.Selected

    intAffectedRows = e.AffectedRows

    End sub

  • Re: Rowcount from ObjectDatasource

    07-08-2009, 2:19 PM
    • Star
      7,932 point Star
    • amit.jain
    • Member since 10-06-2008, 1:09 AM
    • Delhi India
    • Posts 1,264

    try like this

    Protected Sub ObjectDataSource_Selected(ByVal sender As Object, ByVal e As ObjectDataSourceStatusEventArgs)
        
        Dim dt As DataTable = DirectCast(e.ReturnValue, DataTable)
        
            
        Dim count As Integer = dt.Rows.Count
    End Sub


    Don't say thanks rather mark my reply as "Answer" if it helps you ,Doing so u'll get points too
    amiT jaiN

    ASP.NET C#.NET Articles
  • Re: Rowcount from ObjectDatasource

    07-09-2009, 8:46 AM
    • Participant
      1,567 point Participant
    • craigbtx
    • Member since 10-01-2004, 4:50 PM
    • Posts 675

     That worked great. Thanks

    Do you have any idea why intAffectedRows = e.AffectedRows does not work even though its a valid syntax?

  • Re: Rowcount from ObjectDatasource

    07-09-2009, 10:10 AM
    Answer
    • Star
      7,932 point Star
    • amit.jain
    • Member since 10-06-2008, 1:09 AM
    • Delhi India
    • Posts 1,264

    It will return number of Rows affected when you are inserting or Updating records

    Don't say thanks rather mark my reply as "Answer" if it helps you ,Doing so u'll get points too
    amiT jaiN

    ASP.NET C#.NET Articles
Page 1 of 1 (4 items)