Results 1 to 2 of 2

Thread: Empty Dataset

  1. Sep 16th, 2002, 04:52 AM #1
    tattenhoe
    tattenhoe is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2002
    Location
    Milton Keynes UK
    Posts
    27

    Question Empty Dataset

    How can I check whether the retreived dataset is empty? I've tried to do it with the code below but it generates an error

    Regards,

    John

    DsProfile1.Clear()
    OleDbDataAdapter1.Fill(DsProfile1)

    Dim iCnt As Integer
    iCnt = Me.BindingContext(DsProfile1, "profileid").Count

    if icnt = 0 etc etc
    Last edited by tattenhoe; Sep 16th, 2002 at 05:53 AM.
    Reply With Quote Reply With Quote
  2. Sep 16th, 2002, 06:01 AM #2
    tattenhoe
    tattenhoe is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2002
    Location
    Milton Keynes UK
    Posts
    27

    Resolved

    Not sure whether anyone is interested! The answer is below:

    DsProfile1.Clear()
    OleDbDataAdapter1.Fill(DsProfile1, "Combined")

    Dim iCnt As Integer

    iCnt = DsProfile1.Tables("Combined").Rows.Count
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width