CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Posts
    12

    Adding Multiple Row at once.

    I am trying to do a multiple add on one save. like "Entry1,Entry2,Entry3," i split them and put them into a array string and add them on one DB query. here is the code

    http://tinyurl.com/r3b4nc

    thanks.
    Attached Images Attached Images

  2. #2
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Adding Multiple Row at once.

    It's telling you the most likely solution as #1

    Code:
    = NEW ...()
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  3. #3
    Join Date
    Dec 2008
    Posts
    12

    Re: Adding Multiple Row at once.

    nope its not possible DSAdd is already defined. when i put a new before DSAdd.Tables a syntax error would appear.

    i have a similar code. and its working. http://tinyurl.com/r2ut7h

  4. #4
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Adding Multiple Row at once.

    x=x & new x should work
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  5. #5
    Join Date
    Dec 2008
    Posts
    12

    Re: Adding Multiple Row at once.

    nope it does not work i get a syntax telling me that it requires a end statement.

  6. #6
    Join Date
    Nov 2008
    Location
    Cairo , Egypt
    Posts
    24

    Re: Adding Multiple Row at once.

    you need to add the new table in order to add the rows
    add this line before the For statement DSAdd.Tables.Add("AddDB2")

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured