Webcam captured image

Bhavesh Vankar

how can i convert image into binary and store it in database in binary format and display that image on crystal report by where clause. my image after captured by webcam is dispay on image control i have tried many things to convert and store in binary format. currelty stored image path is looking like "0x" in database.

when i try to display that image on crystal report it show me error "blob field field cannot be used in a formula crystal"

kidnly suggest me best bay to do this.

i have used asp.net c# VS 2015. when i select image field from graphics its showing me error like below

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta5y ago
Don't get confused, break your problems into smaller parts and then try to solve it. The best way to store the captured image into the serverpath then save that captured filepath and save the filename into your db, when all done you are good to go interting image in CR.
0
Bhavesh Vankar5y ago
sir i also refered that article but main issue is control in that article used file upload control for image upload and in my project i have used image control to display image.
in my project image is coming from another page which is captured by webcam. ihave also used below code but still not done.
public static byte[] ImageToBinary(string _path)
{
FileStream fS = new FileStream(_path, FileMode.Open, FileAccess.Read);
byte[] b = new byte[fS.Length];
fS.Read(b, 0, (int)fS.Length);
fS.Close();
return b;
}
0
Amit Gupta5y ago
Insertion of image in CR is different that you are implementing. Right click -> Insert->Image. But before inserting image make sure that you have stored the image in correct form of bytes[] (you can verify online or via your code)

Read this article and go for it
https://www.c-sharpcorner.com/UploadFile/4d9083/store-and-retrieve-image-on-crystal-report-from-sql-database/

Good Luck!
+1