About Rowstate and AutoIncrement

Discussion in 'ASP .Net' started by fatboycanteen, Dec 12, 2003.

  1. When I filled the db data to the dataset

    eg. (id_col is autoincrement)
    id_col field1
    97 100
    98 200
    99 15
    100 72
    ---

    when I add two rows to it (newrow-> table.add)

    id_col field1
    97 100
    98 200
    99 15
    100 72
    101 79 <- new row
    102 80 <- new row

    then I delete the first row (row.deleted)

    id_col field1
    97 100 <- marked deleted (rowstate)
    98 200
    99 15
    100 72
    101 79
    102 80

    then I add one row

    id_col field1
    97 100 <- marked deleted (rowstate)
    98 200
    99 15
    100 72
    101 79
    102 80
    104 77 <- new row

    The problem is that the id_col is 104, why not 103

    Anyone can solve the problem. Thank You
     
    fatboycanteen, Dec 12, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Munnki
    Replies:
    2
    Views:
    655
    Munnki
    Dec 18, 2003
  2. =?Utf-8?B?TmVpbA==?=

    Autoincrement / Rowstate problems

    =?Utf-8?B?TmVpbA==?=, Oct 15, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    499
    =?Utf-8?B?TmVpbA==?=
    Oct 15, 2004
  3. thomson
    Replies:
    1
    Views:
    956
    Brock Allen
    Jun 11, 2005
  4. =?Utf-8?B?SklNLkgu?=

    q; DataSet RowState unchanged

    =?Utf-8?B?SklNLkgu?=, May 24, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    2,202
    =?Utf-8?B?SklNLkgu?=
    May 24, 2006
  5. Jarod

    RowState how to check it ?

    Jarod, Jun 6, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    2,304
    Jarod
    Jun 6, 2006
  6. Arpan

    RowState V/s. DataViewRowState?

    Arpan, Aug 17, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    2,818
    =?Utf-8?B?QXVndXN0aW4gUHJhc2FubmE=?=
    Aug 17, 2006
  7. Adriano (arochax)
    Replies:
    0
    Views:
    442
    Adriano (arochax)
    Sep 19, 2006
  8. Marc

    RowState and DataRowVersion

    Marc, Jul 23, 2008, in forum: ASP .Net
    Replies:
    1
    Views:
    646
    Munna
    Jul 23, 2008
Loading...