Hello,

I have the following code:
=====================================================
Public Sub LoadWriteNetworkDetails(ConnectString As String)

' Write the information to the table Inv_Network_Details_Custom
' the task is done with a Stored Procedure called
sp_Inv_Network_Details_Custom_update

ConnectString = "Initial Catalog=AeXNS3;Data Source=localhost;Integrated
Security=SSPI;"
Dim altirisConn As New SqlConnection(ConnectString)

Dim ntwrkInsCMD As SqlCommand = New
SqlCommand("sp_Inv_Network_Details_Custom_update", altirisConn)
ntwrkInsCMD.CommandType = CommandType.StoredProcedure

DataStore("Asset") = New AssetDataSet(w.Current("workitem_managed_object_id)
DataStore("Asset").BeginEdit

Dim myParm1 As SqlParameter = ntwrkInsCmd.Parameters.Add("@ResourceGuid",
SqlDbType.UniqueIdentifier)
myParm1.Value = New Guid (Datastore("Asset").Current.asset_resource_guid)

Dim myParm2 As SqlParameter = ntwrkInsCmd.Parameters.Add("@c1",
SqlDbType.NVarChar)
myParm2.Value = tbFAUNumber.Text

Dim myParm3 As SqlParameter = ntwrkInsCmd.Parameters.Add("@c2",
SqlDbType.NVarChar)
myParm3.Value = tbJackId.Text

Dim myParm4 As SqlParameter = ntwrkInsCmd.Parameters.Add("@c3",
SqlDbType.NVarChar)
myParm4.Value = tbAppMgr.Text

Dim myParm5 As SqlParameter = ntwrkInsCmd.Parameters.Add("@c4",
SqlDbType.NVarChar)
myParm5.Value = tbTitle1.Text

Dim myParm6 As SqlParameter = ntwrkInsCmd.Parameters.Add("@c5",
SqlDbType.NVarChar)
myParm6.Value = tbPhoneNumber.Text

altirisConn.Open()
ntwrkInsCMD.ExecuteNonQuery()
altirisConn.Close()

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

Archived from group: microsoft>public>vb>syntax