Results 1 to 2 of 2

Thread: [2005] Error with column

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2003
    Location
    Auckland
    Posts
    1,139

    [2005] Error with column

    Okay, I need to add somehow these rows to my dataset...
    It's asking for something in the first column... being the auto number.. I can not just add i because it might not be the first row...

    How can I add something so the DB will give it the auto number?
    Or is there a way to empty the dataset so I can add everything from 1 to XX


    Code:
    For i As Integer = 0 To records.Length - 1
                ScreenSaverDataSet.Photos.Rows.Add("", records(i))
            Next
    Input string was not in a correct format.Couldn't store <> in PhotoID Column. Expected type is Int32.

  2. #2

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2003
    Location
    Auckland
    Posts
    1,139

    Re: [2005] Error with column

    why does this not work??

    Code:
     ScreenSaverDataSet.Clear()

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