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