SQL GUID in vb.net problem

[partyk1d24]

I have an insert query that will input some new document information and will be assigned (by SQL server) a GUID for each one. Well I have to referance these with another table. The problem is I have no idea how to get the id or handle it with vb.net? Anyone have experiance with this? I am using a tableadapter in VS 2005 and I have seen tell about the @@identity but I can't seem to figure out how to get it to work right. Any idea guys?

Thanks in advance
Jackie

[Phil Weber]

http://davidhayden.com/blog/dave/arc...2/16/2803.aspx

The sample code is in C#, but you should get the idea.

[Wiseman82]

Note - It's quite safe to generate GUID's from the client - It's not safe to generate identities from the client though. With identities you need to use @@Identity, SCOPE_IDENTITY() or IDENT_CURRENT() - SCOPE_IDENTITY() is the safest method to return the id created by your insert statement. These methods are not for GUIDs.

If you are using uniqueidendifier/GUID you can generate these from the client in VB.NET and specify them in the insert statement - you generate guids using the following code:

Dim myGuid As Guid = Guid.NewGuid
MessageBox.Show(myGuid.ToString)

Hope this helps,

David