HR Management system ASP.NET C# PART-1

click here to download the source code

insert data using Entity Framewrok database 1st Approach in windows from

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 WindowsFormsApplication9.Model;



namespace WindowsFormsApplication9

{

    public partial class Form1 : Form

    {

        db1708c1Entities db = new db1708c1Entities();

        tbl_student s = new tbl_student();

        public Form1()

        {

            InitializeComponent();

        }



        private void button2_Click(object sender, EventArgs e)

        {

           

            s.name = textBox1.Text;

            s.dob = dateTimePicker1.Value;

            s.contatct = textBox2.Text;

            if (s.C_image==null)

            {

                s.C_image = @"C:\images\unknown.png";

            }

            db.tbl_student.Add(s);

            db.SaveChanges();

            MessageBox.Show("Data successfully inserted......");

            dataGridView1.DataSource = db.tbl_student.ToList();

        }



        private void Form1_Load(object sender, EventArgs e)

        {

            dataGridView1.DataSource = db.tbl_student.ToList();

        }



        private void button1_Click(object sender, EventArgs e)

        {

            OpenFileDialog op = new OpenFileDialog();

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

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

            {

                pictureBox1.Image = new Bitmap(op.FileName);

                pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;

                s.C_image = op.FileName;

               

            }

        }

    }

}

How to delete data from sql server using Windwos form c#

Click here to download the source code