Dim fileName As String
fileName =Args(1)
Dim cmd As new SQLCommand
cmd.C
cmd.CommandText ="upd ate CPGL_JCCP set Picture = ? whe re StyleNo='000' And Color ='red'"
Dim ImageByte() As Byte = System.IO.File.ReadAllBytes(fileName) '读取文件流,并将读到的二进制数据放入数组ImageByte中,
cmd.Parameters.Add("@Picture", ImageByte)
cmd.ExecuteNonQuery
我用的sql server 数据库
sql 在插叙image参数时需要设置参数类型
cmd.Parameters.Add("@Picture", SqlDbType.Image);
cmd.Parameters["@Picture"].Value = ImageByte;
我找不到狐表设置数据类型的代码