Creating a Windows Application to view Images

I am use 3-tier architecture in this functions. first upload images in folder and view in form.this coding is performed by:

Presentation Layer

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 BusinessLayer;

using System.IO;

using System.Drawing.Imaging;

using System.Data.SqlClient;

namespace Banking_Management_System

{

public partial class UploadCutomerPhotos : Form

{

public UploadCutomerPhotos()

{

InitializeComponent();

}

SqlConnection con = new SqlConnection("server=ADMINs; Initial Catalog=Bank; uid=sa; password=test");

Byte[] photo;

Image objImage = null;

MemoryStream mStream = null;

#region Objects

BLUploadImages oblUI = new BLUploadImages();

#endregion

private void imagebox_Click(object sender, EventArgs e)

{

try

{

OpenFileDialog Open = new OpenFileDialog();

Open.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";

if (Open.ShowDialog() == DialogResult.OK)

{

Image Img = new Bitmap(Open.FileName);

imagebox.Image = Img.GetThumbnailImage(122, 106, null, new IntPtr());

Open.RestoreDirectory = true;

}

catch (Exception ex)

{

MessageBox.Show(ex.ToString());

}

public bool UFConvertImage()

{

try

{

MemoryStream ms = new MemoryStream();

imagebox.Image.Save(ms, ImageFormat.Jpeg);

photo = new byte[ms.Length];

ms.Position = 0;

ms.Read(photo, 0, photo.Length);

return true;

}

catch

{

MessageBox.Show("Image Format Not Supported!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information);

return false;

}

private void btnSave_Click(object sender, EventArgs e)

{

if (UFConvertImage())

{

oblUI.id = Convert.ToInt32(txtaccno.Text.Trim());

oblUI.image = photo;

oblUI.name = txtName.Text.Trim();

oblUI.InsertImages();

}

private void btnView_Click(object sender, EventArgs e)

{

con.Open();

string Query = "select name,picture from photos where id = '" + txtaccno.Text + "'";

SqlCommand cmd = new SqlCommand(Query, con);

SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())

{

//txtaccno.Text = dr.GetString(0).ToString();

txtName.Text = dr.GetString(0).ToString();

//admissiondate.Text = dr["AdmissionDate"].ToString();

byte[] b = (byte[])dr["picture"];

mStream = new MemoryStream(b);

objImage = Image.FromStream(mStream);

imagebox .Image = objImage;

}

con.Close();

}

Business Layer

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using DataAccessLayer;

namespace BusinessLayer

{

public class BLUploadImages

{

public BLUploadImages()

{ }

#region Objects

DLUploadImages objUPI = new DLUploadImages();

#endregion

#region Properties

public int id

{

get;

set;

}

public Byte[] image

{

get;

set;

}

public string name

{

get;

set;

}

#endregion

#region Function

public void InsertImages()

{

objUPI.SaveUploadImages(id, image, name);

}

#endregion

}

Data Access Layer

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.SqlClient;

namespace DataAccessLayer

{

public class DLUploadImages

{

SqlConnection con = new SqlConnection("Server =Admins; Initial Catalog = Bank; UID=sa; Password = test");

SqlCommand cmd;

public DLUploadImages()

{ }

public void SaveUploadImages(int Accno, Byte[] image, string Name)

{

con.Open();

cmd = new SqlCommand("SP_Uploadimages", con);

cmd.CommandType = CommandType.StoredProcedure;

SqlParameter[] param = new SqlParameter[3];

//SqlParameter[] sqlpa = new SqlParameter[4];

param[0] = new SqlParameter("@id", Accno);

param[1] = new SqlParameter("@picture ", image);

param[2] = new SqlParameter("@name", Name);

foreach (SqlParameter sqlpm in param)

{

cmd.Parameters.Add(sqlpm);

}

cmd.ExecuteNonQuery();

con.Close();

}

5 Replies

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

Frogleg13y ago

Accepted answer

First
using System.IO;

   private void bttnOpen_Click(object sender, EventArgs e)
        {

            if (folderBrowserDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                textBox1.Text = folderBrowserDialog1.SelectedPath;
                getPics(folderBrowserDialog1.SelectedPath);// getl list of files
            }
        }

        public void getPics(string fPath)
        {

            foreach (string file in Directory.GetFiles(fPath))
            {
                if (checkIfimage(file))//check if file is image
                {
                    listBox1.Items.Add(file);
                }
            }
        }


        public bool checkIfimage(string fname)
        {
            bool isImage = false;
            string extension = Path.GetExtension(fname).ToLower();
           
            if (extension == ".jpg" | extension == ".png"|extension==".bmp")
            {
                isImage = true;
            }
            return isImage;
        }

Frogleg13y ago
Here's my sample
Note - you will have to proportion the picturebox to suit images
Sunny Sharma13y ago
Hello Jade,

Here you go, I've created a sample application for you.

You're free to download, use and study for yourself.

Happy Learning :)
Jade Collinton13y ago
Hi,

Thanks for the reply,

When I'm trying this i get the error 'Error1The name 'folderBrowserDialog1' does not exist in the current context' and it doesn't pick up the images from my C:\Pictures\Images folder either. The listbox is just empty. The names that I entered into the listbox are there but when I select one and go to open nothing happens.

Below is what my form looks like but nothing happens when I click on any of the options.
ashleyturnier13y ago
I am use 3-tier architecture in this functions. first upload images in folder and view in form.this coding is performed by:

Presentation Layer

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 BusinessLayer;
using System.IO;
using System.Drawing.Imaging;
using System.Data.SqlClient;

namespace Banking_Management_System
{
public partial class UploadCutomerPhotos : Form
{
public UploadCutomerPhotos()
{
InitializeComponent();
}

SqlConnection con = new SqlConnection("server=ADMINs; Initial Catalog=Bank; uid=sa; password=test");
Byte[] photo;
Image objImage = null;
MemoryStream mStream = null;
#region Objects
BLUploadImages oblUI = new BLUploadImages();

#endregion

private void imagebox_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog Open = new OpenFileDialog();
Open.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";
if (Open.ShowDialog() == DialogResult.OK)
{
Image Img = new Bitmap(Open.FileName);
imagebox.Image = Img.GetThumbnailImage(122, 106, null, new IntPtr());
Open.RestoreDirectory = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public bool UFConvertImage()
{
try
{
MemoryStream ms = new MemoryStream();
imagebox.Image.Save(ms, ImageFormat.Jpeg);
photo = new byte[ms.Length];
ms.Position = 0;
ms.Read(photo, 0, photo.Length);
return true;
}
catch
{
MessageBox.Show("Image Format Not Supported!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}

}



private void btnSave_Click(object sender, EventArgs e)
{
if (UFConvertImage())
{
oblUI.id = Convert.ToInt32(txtaccno.Text.Trim());
oblUI.image = photo;
oblUI.name = txtName.Text.Trim();
oblUI.InsertImages();
}
}

private void btnView_Click(object sender, EventArgs e)
{

con.Open();
string Query = "select name,picture from photos where id = '" + txtaccno.Text + "'";
SqlCommand cmd = new SqlCommand(Query, con);
SqlDataReader dr = cmd.ExecuteReader();

if (dr.Read())
{
//txtaccno.Text = dr.GetString(0).ToString();
txtName.Text = dr.GetString(0).ToString();
//admissiondate.Text = dr["AdmissionDate"].ToString();

byte[] b = (byte[])dr["picture"];
mStream = new MemoryStream(b);
objImage = Image.FromStream(mStream);
imagebox .Image = objImage;

}
con.Close();
}


}

}

Business Layer

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DataAccessLayer;

namespace BusinessLayer
{
public class BLUploadImages
{
public BLUploadImages()
{ }
#region Objects
DLUploadImages objUPI = new DLUploadImages();
#endregion

#region Properties

public int id
{
get;
set;
}
public Byte[] image
{
get;
set;
}
public string name
{
get;
set;
}
#endregion

#region Function
public void InsertImages()
{
objUPI.SaveUploadImages(id, image, name);
}

#endregion

}
}

Data Access Layer

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace DataAccessLayer
{
public class DLUploadImages
{
SqlConnection con = new SqlConnection("Server =Admins; Initial Catalog = Bank; UID=sa; Password = test");
SqlCommand cmd;
public DLUploadImages()
{ }
public void SaveUploadImages(int Accno, Byte[] image, string Name)
{
con.Open();
cmd = new SqlCommand("SP_Uploadimages", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] param = new SqlParameter[3];
//SqlParameter[] sqlpa = new SqlParameter[4];
param[0] = new SqlParameter("@id", Accno);
param[1] = new SqlParameter("@picture ", image);
param[2] = new SqlParameter("@name", Name);

foreach (SqlParameter sqlpm in param)
{
cmd.Parameters.Add(sqlpm);
}
cmd.ExecuteNonQuery();
con.Close();
}

}
}