1,216
社区成员
发帖
与我相关
我的任务
分享
Dim adoCn As New ADODB.Connection
Dim adoCmd As New ADODB.Command
Dim buff() As Byte
Dim PropertyBag As New PropertyBag
PropertyBag.WriteProperty "picture", Picture1.Picture
buff = PropertyBag.Contents
If adoCn.State <> adStateOpen Then adoCn.Open conn
adoCmd.ActiveConnection = adoCn
adoCmd.Prepared = False
adoCmd.CommandText = "insert into cu_RequirementPlans(autoid,ID,cMaterielName,cInvCode,picture) values(@autoid,@id,@cmaterielname,@cinvcode,@picture)"
adoCmd.Parameters.Append adoCmd.CreateParameter("@autoid", adInteger, adParamInput, , 1)
adoCmd.Parameters.Append adoCmd.CreateParameter("@id", adBigInt, adParamInput, , 1)
adoCmd.Parameters.Append adoCmd.CreateParameter("@cmaterielname", adVarChar, adParamInput, 255, "cmaterialnamevalue")
adoCmd.Parameters.Append adoCmd.CreateParameter("@cinvcode", adVarChar, adParamInput, 60, "01.0001")
adoCmd.Parameters.Append adoCmd.CreateParameter("@picture", adVarBinary, adParamInput, , buff)
adoCmd.Execute