Dim SQL = "select * from PDM_DocumentFile where id = 1 "'" Dim Cmd As New SqlCommand(sql, MyConnection) Dim sdr As SqlDataReader sdr = Cmd.ExecuteReader() sdr.Read() sdr("content")作为另外一张表IMAGE字段的参数 能写进去但是就不对
INSERT INTO DOCFILE (FILECONTENT)VALUES(@Documentcontent) cmd.Parameters.Add("@Documentcontent", SqlDbType.Image).Value = sdr("content")
Dim Cmd As New SqlCommand(sql, MyConnection)
Dim sdr As SqlDataReader
sdr = Cmd.ExecuteReader()
sdr.Read()
sdr("content")作为另外一张表IMAGE字段的参数
能写进去但是就不对
cmd.Parameters.Add("@Documentcontent", SqlDbType.Image).Value = sdr("content")
cmd.Parameters.Add("@Documentcontent", SqlDbType.Image).Value = (byte[])(sdr("content"))
转换为btye[]数组吧?
那image对应的空该怎么表示呢?是否是零byte数组啊?