保存图片的问题,谢指点
Dim ms As Stream
Dim picbyte() As Byte
openFileDialog1.ShowDialog()
If (openFileDialog1.ShowDialog() = DialogResult.OK) Then
ms = openFileDialog1.OpenFile()
ReDim picbyte(ms.Length)
ms.Position = 0
ms.Read(picbyte, 0, Convert.ToInt32(ms.Length))
Dim conn As New SqlConnection
conn.ConnectionString = "server=(local);database=Haha;integrated security=sspi;"
Dim cmd As New SqlCommand
cmd = conn.CreateCommand
conn.Open()
cmd.Parameters.Add("@image", SqlDbType.Image)
cmd.Parameters("@image").Value = picbyte
cmd.CommandText = "insert aa values(3,2,@image)"
'cmd.CommandText = "insert aa values(3,2,'" & picbyte(ms.Length) & "')"
' cmd.CommandText = "select * from aa"
cmd.ExecuteScalar() '这里提示有错? aa表有三个字段,第三个为image型
MsgBox("插入成功")
conn.Close()
ms.Close()