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.IO;
using System.Data.SqlClient;
namespace FileHandlingExp
{
public partial class StoreImageInDataBase : Form
{
public
StoreImageInDataBase()
{
InitializeComponent();
}
private
void StoreImageInDataBase_Load(object sender, EventArgs
e)
{
}
object
objimage;
SqlDataReader
dr;
//Code for select image
from any Drive……………………………………………
private
void btnSelectImage_Click(object sender, EventArgs
e)
{
if
(openFileDialog1.ShowDialog() == DialogResult.OK)
{
txtimagesource.Text =
openFileDialog1.FileName;
}
}
//Code for save image in table in binary format
private
void btnSaveImage_Click(object sender, EventArgs e)
{
String sBLOBFilePath =s;
FileStream fsBLOBFile = new FileStream(sBLOBFilePath, FileMode.Open, FileAccess.Read);
Byte[] bytBLOBData = new Byte[fsBLOBFile.Length];
fsBLOBFile.Read(bytBLOBData, 0, bytBLOBData.Length);
fsBLOBFile.Close();
obj.Item_Img = bytBLOBData;
FileStream fsBLOBFile = new FileStream(sBLOBFilePath, FileMode.Open, FileAccess.Read);
Byte[] bytBLOBData = new Byte[fsBLOBFile.Length];
fsBLOBFile.Read(bytBLOBData, 0, bytBLOBData.Length);
fsBLOBFile.Close();
obj.Item_Img = bytBLOBData;
SqlConnection
con = new SqlConnection("Data Source=KUSH-PC;Initial Catalog=test;Integrated
Security=True");
SqlCommand
com = new SqlCommand("insert into TableImage(Id,Name,UserImage)
values(@id,@name,@image)", con);
com.Parameters.AddWithValue("@id",Convert.ToInt32(txtid.Text));
com.Parameters.AddWithValue("@name", txtname.Text);
com.Parameters.AddWithValue("@image", bytBLOBData);
con.Open();
com.ExecuteNonQuery();
con.Close();
MessageBox.Show("Image Added");
}
//Code for show image(binary format) in PictureBox from table …………………………
private
void btnLoadImage_Click(object sender, EventArgs e)
{
SqlConnection
con = new SqlConnection("Data Source=KUSH-PC;Initial Catalog=test;Integrated
Security=True");
SqlCommand
com = new SqlCommand("select Id,Name,UserImage from TableImage where
Id=@id", con);
com.Parameters.AddWithValue("@id", Convert.ToInt32(txtid.Text));
con.Open();
dr = com.ExecuteReader();
if
(dr.HasRows)
{
dr.Read();
txtname.Text= ""+dr["Name"];
objimage = dr["UserImage"];
}
//objimage
= com.ExecuteScalar();
byte[]
data;
data = (byte[])objimage;
MemoryStream
ms = new MemoryStream(data);
pictureBox1.Image = Image.FromStream(ms);
con.Close();
}
//Code for go to next
page…………………………………………
private
void btnNextPage_Click(object
sender, EventArgs e)
{
CopyFile
cf = new CopyFile();
cf.Show();
}
}
}
After retrieve image
from table image is stored
in binary format and after retrieve
image show in PictureBox Control in Windows Application
in C# .NET
How to copy
image from another
location from computer drive and
paste in other drive in computer in Windows Application in C# .NET
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.IO;
namespace FileHandlingExp
{
public partial class CopyFile : Form
{
public
CopyFile()
{
InitializeComponent();
}
// Code for
next page
private
void btnNext_Click(object
sender, EventArgs e)
{
StoreImageInDataBase
si = new StoreImageInDataBase();
si.Show();
}
// Code for how to
select image from Computer drive …………..
private
void btnSelectSource_Click(object sender, EventArgs
e)
{
if
(openFileDialog1.ShowDialog() == DialogResult.OK)
{
txtsourceaddress.Text =
openFileDialog1.FileName;
}
}
// Code for copy image
where is paste in Computer drive …………..
private
void btnLocateSource_Click(object sender, EventArgs
e)
{
if
(saveFileDialog1.ShowDialog() == DialogResult.OK)
{
txtdestinationaddress.Text =
saveFileDialog1.FileName;
}
}
// Code for how to
save image ……………………………………
private
void btnCopyPaste_Click(object sender, EventArgs e)
{
FileStream
fssource = new FileStream(txtsourceaddress.Text,
FileMode.Open);
FileStream
fsdest = new FileStream(txtdestinationaddress.Text,
FileMode.Create);
while
(true)
{
int
i;
i = fssource.ReadByte();
if
(i == -1)
break;
fsdest.WriteByte(Convert.ToByte(i));
}
fsdest.Close();
MessageBox.Show("Image copy in Location");
}
}
}
No comments:
Post a Comment