Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
Dim cm As SqlCommand Dim objCon As SqlConnection = New SqlConnection(sConnection) cm = New SqlCommand("usp_addXML", objCon) cm.CommandType = CommandType.StoredProcedure Dim pID As SqlParameter = New SqlParameter("@ID", SqlDbType.BigInt, 100) Dim pPhotograph As SqlParameter = New SqlParameter("@Photograph", SqlDbType.Image) While myNodeText.MoveNext() Select Case myNodeText.Current.Name Case "ID" pID.Value = iCount cm.Parameters.Add(pID) Case "Photograph" pPhotograph.Value = myNodeText.Current.Value cm.Parameters.Add(pPhotograph) End Select The line pOffencePhotograph.Value = myNodeText.Current.Value is obviously trying to pass a string, so I need to convert it to an image. Thanks in advance.
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.