[02/03] show,add,update and delete image from database

[luckyboy]

HI all. how can i show, add, update and delete image from database? many thank for your help.

[jmcilhinney]

There are examples on MSDN and there are examples posted on the forum. I know this because I've posted at least one myself. Images are assigned to, and returned from, database fields as Byte arrays. To convert between Image objects and Byte arrays you use a MemoryStream. Search the forum for memorystream and my user name and you'll find at least code one example.

[luckyboy]

i admired you, you are so good in vb.net, you help me alot. thank for your help.

[luckyboy]

I want to set field picture in database to null. how can i do that?

[jmcilhinney]

Regardless of the data type of the column, you assign DBNull.Value to the field in a .NET app to set it to null.

[luckyboy]

sir, could u tell me how to save datatable with image field to database please? could you give sample of code please?

[jmcilhinney]

I searched MSDN for save image database and this was one of the top results.

[luckyboy]

many thank for your help. but anyway I want to save datatable with field image to database. more please?

[luckyboy]

many thank for your help. but anyway I want to save datatable with field image to database. it is possible or not, more please?

[jmcilhinney]

You said you wanted a code example. I provided a link to a page that provides a code example. Have you read that page? If you would like me to write the code for you myself then it will cost you AU$150/hour.