Dim param As New SqlParameter() param.Direction = ParameterDirection.ReturnValue param.ParameterName = "returnValue" add to parameter to collection .Parameters.Add(param) .CommandType = CommandType.StoredProcedure .Connection = MedicalSQL.GetConnection .ExecuteNonQuery()
Public Sub InsertXML(TheXML As String) Using objConn As New SqlConnection(DBConnectionString()) objConn.Open() Using objCmd As New SqlCommand("dbo.ProductsAccessXMLInsert") objCmd.CommandType = CommandType.StoredProcedure objCmd.Connection = objConn objCmd.Parameters.Add("ValidXMLInput", SqlDbType.Xml) objCmd.Parameters(0).Value = TheXML objCmd.ExecuteNonQuery() End Using objConn.Close() End UsingEnd Sub
Not necessary but please read carefully in future. (You might get a change in total time by changing things in the VB code, it really depends on how long each bit takes.)