VB.Net - SQL - Read Wrire

[Dominique]

Hello,

I have the following code:
=============== =============== =============== ========
Public Sub LoadWriteNetwor kDetails(Connec tString As String)

' Write the information to the table Inv_Network_Det ails_Custom
' the task is done with a Stored Procedure called
sp_Inv_Network_ Details_Custom_ update

ConnectString = "Initial Catalog=AeXNS3; Data Source=localhos t;Integrated
Security=SSPI;"
Dim altirisConn As New SqlConnection(C onnectString)

Dim ntwrkInsCMD As SqlCommand = New
SqlCommand("sp_ Inv_Network_Det ails_Custom_upd ate", altirisConn)
ntwrkInsCMD.Com mandType = CommandType.Sto redProcedure

DataStore("Asse t") = New AssetDataSet(w. Current("workit em_managed_obje ct_id)
DataStore("Asse t").BeginEdi t

Dim myParm1 As SqlParameter = ntwrkInsCmd.Par ameters.Add("@R esourceGuid",
SqlDbType.Uniqu eIdentifier)
myParm1.Value = New Guid (Datastore("Ass et").Current.as set_resource_gu id)

Dim myParm2 As SqlParameter = ntwrkInsCmd.Par ameters.Add("@c 1",
SqlDbType.NVarC har)
myParm2.Value = tbFAUNumber.Tex t

Dim myParm3 As SqlParameter = ntwrkInsCmd.Par ameters.Add("@c 2",
SqlDbType.NVarC har)
myParm3.Value = tbJackId.Text

Dim myParm4 As SqlParameter = ntwrkInsCmd.Par ameters.Add("@c 3",
SqlDbType.NVarC har)
myParm4.Value = tbAppMgr.Text

Dim myParm5 As SqlParameter = ntwrkInsCmd.Par ameters.Add("@c 4",
SqlDbType.NVarC har)
myParm5.Value = tbTitle1.Text

Dim myParm6 As SqlParameter = ntwrkInsCmd.Par ameters.Add("@c 5",
SqlDbType.NVarC har)
myParm6.Value = tbPhoneNumber.T ext

altirisConn.Ope n()
ntwrkInsCMD.Exe cuteNonQuery()
altirisConn.Clo se()

End Sub


=============== =============== =============== ========
I would like to use the Guid of the cuurent asset to collect the information
FAU, etc... and display them. It seems I always create a new guid and does
not use the current one to collect the information.

--
Dominique