well that's neither here nor there. there are many reasons why i chose to take the route i have taken. my main concern is how to add a unique id for the value of my column that i have designated as my primary key in my dataset when i insert a new row. any help with this would be greatly appreciated. thanks!
--- In [EMAIL PROTECTED], shannon hall <[EMAIL PROTECTED]> wrote: > 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/
