Dim dbConnection As OleDbConnection = New OleDbConnection(dbConnectionString)
dbConnection.Open()
Dim dbcommand As System.Data.OleDb.OleDbCommand
dbcommand = New System.Data.OleDb.OleDbCommand("insert into picInfo(picname,piclx,picformat,pictime,picimage,picdescription) values(@picname,@piclx,@picformat,@pictime,@picimage,@picdescription)", dbConnection)
Dim prm1 As New OleDbParameter("@picname", name)
dbcommand.Parameters.Add(prm1)
Dim prm2 As New OleDbParameter("@piclx", lx)
dbcommand.Parameters.Add(prm2)
Dim prm3 As New OleDbParameter("@picformat", format)
dbcommand.Parameters.Add(prm3)
Dim prm4 As New OleDbParameter("@pictime", time)
dbcommand.Parameters.Add(prm4)
Dim prm5 As New OleDbParameter("@picimage", FileByteArray)
dbcommand.Parameters.Add(prm5)
Dim prm6 As New OleDbParameter("@picdescription", description)
dbcommand.Parameters.Add(prm6)
Try
dbcommand.ExecuteNonQuery()
MsgBox("保存成功", MsgBoxStyle.SystemModal)
Catch ex As Exception
MsgBox(ex.Message.ToString)
End Try
dbConnection.Dispose()
dbConnection.Close()
大家好 ,帮我看看这段代码,想要往SqlServer里插入数据,为什么总提示错误 “必须声明变量@picname”,各位高手帮我看看 谢谢
昨夜西风凋碧树,独上高楼,望尽天涯路!