主题：[求助]Insert Into怎么插入图片到二进制列

参考代码

Dim imgStream As New IO.MemoryStream
Dim b As New Bitmap("d:\test.jpg")
b.Save(imgStream, System.Drawing.Imaging.ImageFormat.Jpeg)
Dim imageByte As Byte() = imgStream.GetBuffer
imgStream.Dispose()
Dim ImageString As String = BitConverter.ToString(imageByte).Replace("-", "")  ' SQLCommand 不能直接Insert 二进制,只能拼接SQL语句,所以这里把二进制变成字符
Dim cmd As SQLCommand = new SQLCommand()
cmd.ConnectionName = "数据源名"
cmd.CommandText = "update " & dr.datatable.name & " set 示意图1 = 0x" + ImageString + " where _Identify = " & dr("_Identify")
cmd.ExecuteNonQuery()

你要新增一行数据还是修改原来的数据？如果你已经新增了一行，修改原来的数据，就用update。

如果是新增一行新的数据，就用insert into 如

cmd.CommandText = "insert into 表名 (第一列,第二列,图片) values ('123', 'abc', 0x" + ImageString + ")"