Hello Rkbnair,
Thanks for your clarifying.
can I attach a jpg file along with my postings?
Yes, you can attach it if you post the reply in OutLook Express.
My alias is (e-mail address removed). You also can send email to me if you
failed to attach it in reply.
I understood it's a Desktop VB.net WinForm application (vs 2005), and the
underlying database is SQL Server 2005 CE.
But I'm sorry to say I cannot reproduce the issue on my side. Because we
don't support Device Development issue in Managed Newsgroup, I haven't
experience in SQL Server 2005 CE database. Therefore, I tried it with SQL
Server 2005 Express database. I created a table, and added a image column
(Type: Image) into it. Then, I added DataSource Reference to this database,
drag-drop it from Data Source Windows into my Winform application Designer
view. I checked the testDBDataSet.Designer.vb file, the type of Paramter is
SQLDbType.Image as below.
Me._adapter.InsertCommand.Parameters.Add(New
Global.System.Data.SqlClient.SqlParameter("@c2",
Global.System.Data.SqlDbType.Image,...))
After running, I did not get error message the parameter will be truncated
to a length of 8000.
Would you please send me a detail reproduce steps (about how you deployed
SQL 2005 CE database, and how you created a desktop WinForm Application
which connected to SQL CE Database)? I will try it on my side, and reply
you as soon as possible.
I'm waiting for your reply. If you have any more concern or there is
anything unclear, please feel free to let me know. It's my pleasure to
assist you.
Have a great day.
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.