467,077 Members | 1,022 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,077 developers. It's quick & easy.

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
  • viewed: 6348
Share:
4 Replies
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.

Thanks,

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
news:%2****************@TK2MSFTNGP02.phx.gbl...
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
Database.

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();
ta.Fill(dt);
dt.Rows[0]["pic"] = DBNull.Value;
ta.Update(dt);

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

Sincerely,
Linda Liu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

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
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================

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 this site, you agree to our Privacy Policy and Terms of Use.