We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.