I'm Importing an XML file into SQL but one of the elements in the XML file contains an image and I'm wondering how to do that. Here's some of my code, although it's wrong but I'm just wondering how to handle the image.
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)
Select Case myNodeText.Current.Name
pID.Value = iCount
pPhotograph.Value = myNodeText.Current.Value
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.