May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
There is sight suggesting using
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 Using End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.