swallow.pa
جمعه 22 فروردین 1393, 22:48 عصر
دوستان سلام
جستجو كردم تو سايت اين هم لينكش
http://barnamenevis.org/showthread.php?76544-%D8%B0%D8%AE%DB%8C%D8%B1%D9%87-%D8%B9%DA%A9%D8%B3-%D8%AF%D8%B1-SQL-%D8%A8%D8%A7-VB-NET
كه به چند جاي ديگه ارجاع ميشه اما نتيجه نگرفتم
من از اين كد براي ذخيره عكس استفاده مي كنم از تو خود سايت كمك گرفتم
Sub Save_Pic()
PictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat)
Dim arrImage() As Byte = ms.GetBuffer
ms.Close()
Dim isConnecting As Boolean = True
Dim imageStream As IO.MemoryStream = New IO.MemoryStream()
While isConnecting
'Try
Dim str_insert As String = _
"INSERT INTO Pi (Pic)" & _
"VALUES (@Pic)"
Dim cmd As New SqlClient.SqlCommand(str_insert, Cn)
cmd.Parameters.Add(New SqlClient.SqlParameter("@Pic", arrImage)) '.Value = arrImage
Cn.Open()
cmd.ExecuteNonQuery()
Cn.Close()
isConnecting = False
MsgBox("image saved")
'Catch Exc As OleDb.OleDbException
' MessageBox.Show(Exc.ToString, " Exception Error!", _
' MessageBoxButtons.OK, MessageBoxIcon.Error)
' Exit While
'Catch exc As Exception
'End Try
End While
End Sub
اما خطايي با اين مضمون مي اد تو قسمت cmd.ExecuteNonQuery()
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
Additional information: String or binary data would be truncated.
The statement has been terminated
دوستان چطوري مشكل رو حل كنم
ممنون
جستجو كردم تو سايت اين هم لينكش
http://barnamenevis.org/showthread.php?76544-%D8%B0%D8%AE%DB%8C%D8%B1%D9%87-%D8%B9%DA%A9%D8%B3-%D8%AF%D8%B1-SQL-%D8%A8%D8%A7-VB-NET
كه به چند جاي ديگه ارجاع ميشه اما نتيجه نگرفتم
من از اين كد براي ذخيره عكس استفاده مي كنم از تو خود سايت كمك گرفتم
Sub Save_Pic()
PictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat)
Dim arrImage() As Byte = ms.GetBuffer
ms.Close()
Dim isConnecting As Boolean = True
Dim imageStream As IO.MemoryStream = New IO.MemoryStream()
While isConnecting
'Try
Dim str_insert As String = _
"INSERT INTO Pi (Pic)" & _
"VALUES (@Pic)"
Dim cmd As New SqlClient.SqlCommand(str_insert, Cn)
cmd.Parameters.Add(New SqlClient.SqlParameter("@Pic", arrImage)) '.Value = arrImage
Cn.Open()
cmd.ExecuteNonQuery()
Cn.Close()
isConnecting = False
MsgBox("image saved")
'Catch Exc As OleDb.OleDbException
' MessageBox.Show(Exc.ToString, " Exception Error!", _
' MessageBoxButtons.OK, MessageBoxIcon.Error)
' Exit While
'Catch exc As Exception
'End Try
End While
End Sub
اما خطايي با اين مضمون مي اد تو قسمت cmd.ExecuteNonQuery()
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
Additional information: String or binary data would be truncated.
The statement has been terminated
دوستان چطوري مشكل رو حل كنم
ممنون