using System;                          
using System.Collections.Generic;      
using System.ComponentModel;           
using System.Data;                     
using System.Drawing;                  
using System.Linq;                      
using System.Text;                     
using System.Threading.Tasks;          
using System.Windows.Forms;            
using System.Data.OleDb;
using System.IO;

namespace Save_Image                 
{
    public partial class Form1 : Form 
    {
        OleDbCommand cmd = new OleDbCommand(); 
        OleDbConnection con = new OleDbConnection(); 

        OpenFileDialog ofd = new OpenFileDialog(); 
        String Khan;  

        public Form1()  
        {
            InitializeComponent();  

            cmd.Connection = con; 
            con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Database3.accdb";
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'database3DataSet1.Photo' table. You can move, or remove it, as needed.
            this.photoTableAdapter.Fill(this.database3DataSet1.Photo);
        }
          
        private void Save_Image (String Shaikh) 
        {
            try
            {
                con.Open(); 
                String path = ofd.FileName; 
                byte[] imagedata;

                cmd.CommandText = Shaikh; 
                imagedata = System.IO.File.ReadAllBytes(@path); 

                cmd.Parameters.AddWithValue("@Img", imagedata); 
                cmd.Parameters.AddWithValue("@ID", textBox1.Text); 
                cmd.ExecuteNonQuery(); 

                MessageBox.Show("Image saved successfully!"); 
            }
            catch (Exception ex) 
            {
                MessageBox.Show(ex.Message); 
            }
            finally
            {
                con.Close(); 
            }
        }

        private Image BytesToImage(byte[] bytes)
        {
            using (MemoryStream img_Stream = new MemoryStream(bytes))
            {
                Image img = Image.FromStream(img_Stream);
                img_Stream.Close();
                return img;
            }
        }
      

        private void Browse_Button (object sender, EventArgs e)
          {
              ofd.ValidateNames = true;
              if (ofd.ShowDialog() == DialogResult.OK)
              {
                  pictureBox1.Image = Image.FromFile(ofd.FileName);
              }
          }


        private void Insert_Button (object sender, EventArgs e)
        {
            Khan = "Insert Into [Table_Name] (Img) Values (@Img)";
            saveImage(Khan);
            MessageBox.Show("Image_Save");
        }
  
        private void Search_Button (object sender, EventArgs e) 
        {
            cmd.CommandText = "Select * From [Table_Name] Where ID = " + textBox1.Text + " ";
            
            con.Open(); 
            OleDbDataReader dr = cmd.ExecuteReader(); 

            if (dr.Read()) 
            {
                textBox1.Text = dr["ID"].ToString(); 
                Bitmap bm = (Bitmap)BytesToImage((byte[])dr["Img"]); 
                pictureBox1.Image = bm; 
            }
            con.Close(); 
        }
        private void Delete_Button (object sender, EventArgs e) 
        {
            con.Open(); 
            cmd.CommandText = "Delete from [Table_Name] Where ID =" + textBox1.Text + " "; 
            cmd.ExecuteNonQuery(); 
            
            MessageBox.Show("Record deleted"); 
          
        }
    }
}