Dim st As New FileStream(FileName, FileMode.Open, FileAccess.Read)
Dim mbr As BinaryReader = New BinaryReader(st)
Dim buffer(st.Length) As Byte
mbr.Read(buffer, 0, CInt(st.Length))
st.Close()
Dim cmd As New SqlClient.SqlCommand("sp_InsertPhoto", cnn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@BarCode", SqlDbType.VarChar).Value = Strcode
cmd.Parameters.Add("@name", SqlDbType.Char).Value = "img1"
cmd.Parameters.Add("@cimage", SqlDbType.Image).Value = buffer
ALTER PROCEDURE [dbo].[sp_InsertPhoto]
@BarCode Varchar(50),
@Cimage image,
@name varchar
AS
update ShopArchives set @name=@cimage where CustomerCode=@BarCode
操作数类型冲突: image 与 varchar 不兼容 image 不兼容
Dim mbr As BinaryReader = New BinaryReader(st)
Dim buffer(st.Length) As Byte
mbr.Read(buffer, 0, CInt(st.Length))
st.Close()
Dim cmd As New SqlClient.SqlCommand("sp_InsertPhoto", cnn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@BarCode", SqlDbType.VarChar).Value = Strcode
cmd.Parameters.Add("@name", SqlDbType.Char).Value = "img1"
cmd.Parameters.Add("@cimage", SqlDbType.Image).Value = buffer
ALTER PROCEDURE [dbo].[sp_InsertPhoto]
@BarCode Varchar(50),
@Cimage image,
@name varchar
AS
update ShopArchives set @name=@cimage where CustomerCode=@BarCode
操作数类型冲突: image 与 varchar 不兼容 image 不兼容
存储过程中不认变量字段@name