Results 1 to 6 of 6

Thread: Filling multiple listboxes from a database

  1. Oct 6th, 2003, 02:05 AM #1
    briancps
    briancps is offline

    Thread Starter
    Addicted Member
    Join Date
    Jun 2002
    Location
    Brisbane Australia
    Posts
    150

    Angry Filling multiple listboxes from a database

    I am in teach myself mode for VB.NET after many years of vb3-6. I am writing a Web Project and I am confused about why I can't loop around the same command and datareader to fill number of listboxes. I have to close the command and the dataset and dim as differnet defintiions. There is probably something terribly wrong with what I'm doing. The connection can stay open but nothing elseand the the connection can stay open. I know I'm appearing like a newbie but I am when it comes to this.
    Can anyone help ??
    thanks BH
    Reply With Quote Reply With Quote
  2. Oct 6th, 2003, 02:13 AM #2
    Lunatic3
    Lunatic3 is offline
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    I actually couldnt understand what you trying to do? you want to fill multiple listboxes from multiple tables? are you using datareader object or datasets as you mentioned both.
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979
    Reply With Quote Reply With Quote
  3. Oct 6th, 2003, 02:20 AM #3
    briancps
    briancps is offline

    Thread Starter
    Addicted Member
    Join Date
    Jun 2002
    Location
    Brisbane Australia
    Posts
    150

    multiple listboxes

    thenks - typo I am using datareaders. Some forms have 10-12 dropdowns so I thisnk what I am doing is too verbose. But it crashes if use the same defintion names

    thanks BH
    Reply With Quote Reply With Quote
  4. Oct 6th, 2003, 02:24 AM #4
    Lunatic3
    Lunatic3 is offline
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    whats the error when crashes?
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979
    Reply With Quote Reply With Quote
  6. Oct 6th, 2003, 02:33 AM #5
    briancps
    briancps is offline

    Thread Starter
    Addicted Member
    Join Date
    Jun 2002
    Location
    Brisbane Australia
    Posts
    150

    multiple lookups

    Hi
    I knew youd ask that. I cant remember. I tried to make the cmd and datareader declared only once in the routine and then just close and repoulate withe the new query. delending on what I tried I got build errors or I think it was dupicate definitons at run time. I scrapped it and went back to my last checkpoint,

    If you think you can help, I will recreate and record the errors like every good user should
    thanks for your help

    BH
    Reply With Quote Reply With Quote
  7. Oct 6th, 2003, 02:34 AM #6
    Lunatic3
    Lunatic3 is offline
    Frenzied Member
    Join Date
    Oct 2002
    Location
    Gammapolis
    Posts
    1,474
    I will do my best to help you.
    'Heading for the automatic overload'
    Marillion, Brave, The Great Escape, 1994

    'How will WE stand the FIRE TOMORROW?'
    Eloy, Silent Cries and Mighty Echoes, The Vision - Burning, 1979
    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