Here is the code to Export the JPEG image file from bytes data from sql server.
First You have to use this namespace for Exporting
Namespace:
Code:
First You have to use this namespace for Exporting
Namespace:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Configuration;
using System.IO;
using System.Drawing.Imaging;
Code:
 public void GetAllImagesFromBytes()
    {
        string seatno;
        DataTable dt = new DataTable();
        dt = ojas.GetAllDataFromHallTicket();
        int i = 0;
        int j = dt.Rows.Count;
        for (i = 0; i < j; i++)
        {
            seatno = dt.Rows[i]["seatno_19"].ToString();
            byte[] imagedata = (byte[])dt.Rows[i]["PhotoByte"];
            MemoryStream memorystream = new MemoryStream(imagedata, 0, imagedata.Length);
            Image image = Image.FromStream(memorystream);
            // Save the file into folder 
            image.Save(filename: "D:\\IMAGE-DATA\\" + seatno + ".");
            memorystream.Flush();
            memorystream.Close();
        }
    }
0 Comments
Post a Comment