??Dim intImageSize As Int64 ????Dim strImageType As String ????Dim ImageStream As Stream
????'''' Gets the Size of the Image ????intImageSize = PersonImage.PostedFile.ContentLength
????'''' Gets the Image Type ????strImageType = PersonImage.PostedFile.ContentType
????'''' Reads the Image ????ImageStream = PersonImage.PostedFile.InputStream
????Dim ImageContent(intImageSize) As Byte ????Dim intStatus As Integer ????intStatus = ImageStream.Read(ImageContent, 0, intImageSize)
????'''' Create Instance of Connection and Command Object ????Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString")) ????Dim myCommand As New SqlCommand("sp_person_isp", myConnection)
????'''' Mark the Command as a SPROC ????myCommand.CommandType = CommandType.StoredProcedure
????'''' Add Parameters to SPROC ????Dim prmPersonImage As New SqlParameter("@PersonImage", SqlDbType.Image) ????prmPersonImage.Value = ImageContent ????myCommand.Parameters.Add(prmPersonImage)
????Dim prmPersonImageType As New SqlParameter("@PersonImageType", SqlDbType.VarChar, 255) ????prmPersonImageType.Value = strImageType ????myCommand.Parameters.Add(prmPersonImageType)
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 