i don't know what that means. --- In [EMAIL PROTECTED], "Mischa Kroon" <[EMAIL PROTECTED]> wrote: > use a guid: > > System.GUID.NewGuid().ToString() > > > > ----- Original Message ----- > From: "Trevor Thompson" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, August 16, 2004 11:11 PM > Subject: [AspNetAnyQuestionIsOk] Re: finding largest primary key value in my > DataSet > > > > To be clear, I want to add a new row to my DataTable, not to my > > actual database. The problem i am running into is that when I attempt > > to do the following.. > > > > DataRow dr= ds.Tables[0].NewRow(); > > dr["pay_adjust_id"] = //needs unique value here for primary key > > dr["pay_adjust_vers_id"] = add_pay_adjust_vers_id; > > dr["ctype_grp_cd"] = add_ctype_grp_cd; > > dr["pay_adjust_type_cd"] = "P"; > > dr["proj_fy"] = add_proj_fy; > > dr["proj_fm"] = add_proj_fm; > > dr["prcnt"] = addPCNT; > > dr["narrative"] = addNAR; > > > > ds.Tables[0].Rows.Add(dr); > > > > it needs a unique value for the primary key. Does anyone know how I > > can come up with a unique value for my primary key column? Thanks! > > > > > > > > > > --- In [EMAIL PROTECTED], shannon hall > > <[EMAIL PROTECTED]> wrote: > > > If you aren't going to use the object for what it was > > > designed for then I would suggest not using it at all. > > > Use a command object and fire off an insert statement > > > and refill whatever "reader" type of object you > > > implemented. > > > > > > > > > > > > --- Trevor Thompson <[EMAIL PROTECTED]> wrote: > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > __________________________________ > > > Do you Yahoo!? > > > Yahoo! Mail is new and improved - Check it out! > > > http://promotions.yahoo.com/new_mail > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > >
------------------------ 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/
