پروژه ذخیره عکس در بانک اطلاعاتی :

عکس محیط نرم افزار :

در این نرم افزار شما میتوانید اطلاعات یک شخص را وارد کرده و همراه عکس آن در بانک ذخیره کنید.

کد برنامه :

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace mesal3
{
    public partial class Form1 : Form
    {
       // static public string con = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";
        SqlConnection cnn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
        public Form1()
        {
            InitializeComponent();
        }

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            OpenFileDialog op = new OpenFileDialog();
            if (op.ShowDialog() == DialogResult.OK)
            {
                pictureBox1.ImageLocation = op.FileName;
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            if (txtname.Text == "")
            {
                errorProvider1.SetError(txtname, "نام را وارد کنید");
            }
            else if (pictureBox1.Image == null)
            {
                errorProvider1.Clear();
                errorProvider1.SetError(linkLabel1, "عکس را انتخاب کنید");
            }
            else
            {
              if (cnn.State == ConnectionState.Open)
                {
                    string sql = "Insert Into tb_aks (name,imag) Values (@PersonName,@PersonImage)";
                    SqlCommand cmd = new SqlCommand(sql, cnn);
                    cmd.Parameters.AddWithValue("@PersonName", txtname.Text);
                    cmd.Parameters.AddWithValue("@PersonImage", ImageToByte(pictureBox1.Image));
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("ثبت شد");
                    txtname.ResetText();
                    pictureBox1.Image = null;
                    re();
                    cnn.Close();
                }
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            if (cnn.State == ConnectionState.Closed)
            {
                cnn.Open();
            }
            re();
        }
        public static byte[] ImageToByte(Image img)
        {
            ImageConverter converter = new ImageConverter();
            return (byte[])converter.ConvertTo(img, typeof(byte[]));
        }
        public void re()
        {
            string select = "select * from tb_aks";
            SqlDataAdapter da = new SqlDataAdapter(select,cnn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            dataGridView1.DataSource =ds.Tables[0].DefaultView;
            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                row.Height = 80;
            }
        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            //int row = dataGridView1.CurrentRow.Index;
            //string select = "select * from tb_aks";
            //SqlDataAdapter da = new SqlDataAdapter(select, cnn);
            //DataSet ds = new DataSet();
            //DataTable dt = new DataTable ();
            //da.Fill(dt);
            //txtname.Text = dt.Rows[0]["name"].ToString();
            //pictureBox1.Image =ImageToByte(dataGridView1.Rows.Cells["Column1"].Value);
        }
    }
}

برای دانلود از لینک زیر استفاده کنید...

دانلود پروژه