If you are already using a dataadapter then why not use the functionality it provides? Otherwise slam your data into a data table and fire off an insert stored procedure on the server and refresh the data table after complete.
If this is a web application I would suggest using sp's and data reader's. --- Trevor Thompson <[EMAIL PROTECTED]> wrote: > i'm not using the dataAdapter to insert, update, or > delete. i'm just > using it to select and fill. and then i'm taking > care of the rest > myself. > > --- In [EMAIL PROTECTED], > shannon hall > <[EMAIL PROTECTED]> wrote: > > Not only will the table have to have a Identity > insert > > but you should havea data table derived from a > data > > adapter with the appropriate select, insert, > update > > and delete statements. This way, your data > integrity > > is insurred. > > > > > > --- Onur Bozkurt <[EMAIL PROTECTED]> wrote: > > > > > why don't use use "Identity Insert" ? Create a > > > column and make its Identity property to true. > > > ----- Original Message ----- > > > From: Trevor Thompson > > > To: [EMAIL PROTECTED] > > > Sent: Monday, August 16, 2004 9:42 PM > > > Subject: [AspNetAnyQuestionIsOk] finding > largest > > > primary key value in my DataSet > > > > > > > > > i need to insert a new row in my dataset > > > datatable. my datatable has > > > a primary key. i need to assign a unique value > for > > > my primary key > > > column in my newly inserted row. how can i do > > > this? i need to figure > > > out how to find the max value of primary key > in my > > > dataset and add a > > > 1 to it to have an unused unique value. > > > > > > tks! > > > > > > > > > Yahoo! Groups Sponsor > > > ADVERTISEMENT > > > > > > > > > > > > > > > > > > > > > -------------------------------------------------------------------- > ---------- > > > Yahoo! Groups Links > > > > > > a.. To visit your group on the web, go to: > > > > > > > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > > > > > b.. To unsubscribe from this group, send an > > > email to: > > > > > > > [EMAIL PROTECTED] > > > > > > c.. Your use of Yahoo! Groups is subject to > the > > > Yahoo! Terms of Service. > > > > > > > > > > > > [Non-text portions of this message have been > > > removed] > > > > > > > > > > > > > > > > _______________________________ > > Do you Yahoo!? > > Express yourself with Y! Messenger! Free. Download > now. > > http://messenger.yahoo.com > > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
