Returning guid from inserted row in SQL server 2005

[Steve]

Hi All

Can someone help get the rowGUID value after an insert

I am using VB.net 2005 and SQL server Express 2005

The column GUID is an uniqueidentifie r column with default value
(newsequentiali d())

The following is my current function which is clumsy to say the least

I am sure there is a more elegant solution

Regards

Steve

----------------------------------------------------------------------------------------------------------
Public Function SaveParamDataGe tGUID(ByVal mycmd As SqlCommand, ByVal
mytable As String) As Guid

Dim con As New SqlConnection, guid As Guid, sql As String = ""

Dim myint As Int16 = 0

Try

con.ConnectionS tring = connectionstrin g

con.Open()

mycmd.Connectio n = con

mycmd.ExecuteNo nQuery()

sql = "select max(mykey) as maxkey from " & mytable

mycmd.CommandTe xt = sql

myint = mycmd.ExecuteSc alar

sql = "select guid from " & mytable & " where mykey = " & myint

mycmd.CommandTe xt = sql

guid = mycmd.ExecuteSc alar

Return guid

Catch ex As SqlException

mymsgbox(ex.Mes sage)

Return Nothing

Finally

If Not IsNothing(mycmd ) Then

mycmd.Dispose()

mycmd = Nothing

End If

If Not IsNothing(con) Then

con.Close()

con.Dispose()

con = Nothing

End If

End Try

End Function

---------------------------------------------------------------------------------------------------------------------------------------------------

[Robert]

Can someone help get the rowGUID value after an insert

I am using VB.net 2005 and SQL server Express 2005

The column GUID is an uniqueidentifie r column with default value
(newsequentiali d())

The following is my current function which is clumsy to say the least

I am sure there is a more elegant solution

I prefer creating the GUID on the client.. This way you can insert a parent
and children in one transaction. No round trip perf issues are a good
thing.

[Spam Catcher]

"Robert" <[e-mail] te in
news:#s******** ******@TK2MSFTN GP04.phx.gbl:

I prefer creating the GUID on the client.. This way you can insert a
parent and children in one transaction. No round trip perf issues are
a good thing.

It depends on how you write your SQL statements - you could combine
everything into one statement to avoid the round trip.

Otherwise, using a DAL framework (LLBLGen Pro, NHibernate, Wilson OR/M,
etc) reduces your need to worry about such intracacies.

[Steve]

Hi Robert

How do you generate a Sequential GUID on the Client?

VB.net only has GUID class

Regards
Steve

"Robert" <[e-mail] te in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>

>Can someone help get the rowGUID value after an insert

I am using VB.net 2005 and SQL server Express 2005

The column GUID is an uniqueidentifie r column with default value
(newsequential id())

The following is my current function which is clumsy to say the least

I am sure there is a more elegant solution

I prefer creating the GUID on the client.. This way you can insert a
parent
and children in one transaction. No round trip perf issues are a good
thing.