Attention: We are retiring the ASP.NET Community Blogs. Learn more >

Assigning a DefaultValue for a sql server uniqueidentifier datatype: NewGuid

Wednesday, April 14, 2004

One of our Datatables pk is a uniqueidentifier. I could not figure out how to set the DefaultValue for this DataColumn.

Easy enough:

col.DefaultValue = System.Guid.NewGuid

NewGuid will generate a new guid for you. I was using NEWID on the sql side. I can get rid of this now and set the DefaultValue. 2 birds killed with one stone.

3 Comments

That won't work because it will generate one Guid, assign it to the DefaultValue property and then that one Guid would be copied into each new row making them non-unique. You'll need to require people adding new rows to the DataTable to set the value themselves.

HTH,

Drew

Drew Marsh - Wednesday, April 14, 2004 4:45:00 PM
Yup, I just discoverd this. I thought this would work much like auto incrmented values do in ADO.NET do (step and all that). I am now calling NewGuid and assinging this value to the pk field when I create the new datarow.

Greg Robinson - Wednesday, April 14, 2004 8:25:00 PM
You could tinker a’ bit by overriding the NewRow method.

Paul Gielens - Thursday, April 15, 2004 5:51:00 AM

Comments have been disabled for this content.