once i have the data i need from the sql what do i do with it ?
For such a problem，I think you should define your column as "image" type，and then use a FileUpLoad control by analyzing the updated photo——System.IO.File.ReadAllBytes(FileUpLoad1.File); to read them into the form of binary and then save into the db。
eladc
Member
32 Points
89 Posts
working with sql image type with xml
May 06, 2012 05:59 AM|LINK
im using a winform app to build a custom xml file with certin fields
here's my problam in my Customers table i have CustomerPhoto field of type image
1. once i have the data i need from the sql what do i do with it ?
as far as search goes a i know i need to use WriteBase64 but how? -.- cant find any good examples for beginners such as me :P.
p.s - i want to be able to read that binary data later using c# to display the actual image !
1. how do i even retrieve it (the image data type) ? do i write a function that returns a binary type?
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: working with sql image type with xml
May 08, 2012 01:28 AM|LINK
Hello：）
For such a problem，I think you should define your column as "image" type，and then use a FileUpLoad control by analyzing the updated photo——System.IO.File.ReadAllBytes(FileUpLoad1.File); to read them into the form of binary and then save into the db。
teguhyuliant...
Participant
1370 Points
372 Posts
Re: working with sql image type with xml
May 08, 2012 07:50 AM|LINK
What's your images size to display in custom table?