472,141 Members | 1,460 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,141 software developers and data experts.

Send Null Value image field

How can i send from VB 2005 a null value to a image field on a database in
SQL 2005
Aug 17 '07 #1
4 6648
On Aug 17, 10:58 am, "Laurahn" <leme...@newsgroups.nospamwrote:
How can i send from VB 2005 a null value to a image field on a database in
SQL 2005
I believe you can send DbNull.Value.


Seth Rowe

Aug 17 '07 #2
"Laurahn" <le*****@newsgroups.nospamschrieb:
How can i send from VB 2005 a null value to a image field on a database in
SQL 2005
Did you already try 'DBNull.Value' as the field's value?

M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

Aug 17 '07 #3
I've tried with system.bdnull.value already, but i got this error:
a "System.DBNull" cannot be convert in '1 -dimensional Byte'

I'm working with "system.byte()"

"Laurahn" <le*****@newsgroups.nospamescribió en el mensaje
How can i send from VB 2005 a null value to a image field on a database in
SQL 2005

Aug 17 '07 #4
Hi Laurahn,

I agree with what Herfried and Seth have suggested. We could set the image
field to DBNull.Value to save Null value in the corresponding field in the

I will illustrate this with a sample.

I Create a DataSet called 'DataSet1' in a WinForm project and drag a table
named 'Student' from the Server Explorer onto the DataSet1 designer. A
DataTableAdapter named 'StudentDataAdapter' is generated by the designer
automatically. The image field in the Student table is 'pic'.

The following code updates the 'pic' field of the first row to a Null value:

DataSet1.StudentDataTable dt = new DataSet1.StudentDataTable();
DataSet1TableAdapters.StudentTableAdapter ta = new
TestProject.DataSet1TableAdapters.StudentTableAdap ter();
dt.Rows[0]["pic"] = DBNull.Value;

Hope this helps.
If you have any question, please feel free to let me know.

Linda Liu
Microsoft Online Community Support

Get notification to my posts through email? Please refer to

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at

This posting is provided "AS IS" with no warranties, and confers no rights.

Aug 20 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Roger Withnell | last post: by
7 posts views Thread by exxos | last post: by
3 posts views Thread by Robb Gilmore | last post: by
2 posts views Thread by Fatih BOY | last post: by
1 post views Thread by Matt | last post: by
5 posts views Thread by AAVarda | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.