选中列得到员工原来的信息

namespace Jxc
{
    public partial class FormEmployee : Form
    {
        private void BangdingEmpInfo()
        {
            string conString = "server=.;database=GXT;uid=sa;pwd=tian123";

            SqlConnection con = new SqlConnection(conString);
            con.Open();

            string sqlString = "select * from employee";

            SqlCommand cmd = new SqlCommand(sqlString, con);
            DataTable table = new DataTable();
            SqlDataReader reader = cmd.ExecuteReader();
            table.Load(reader);
            reader.Close();
            con.Close();

            List<Employee> emps = new List<Employee>();
            Employee emp = null;
            foreach (DataRow r in table.Rows)
            {
                emp = new Employee();
                emp.EmpId = Int32.Parse(r["EmpID"].ToString());
                emp.EmpName = r["EmpName"].ToString();
                emp.EmpSex = r["EmpSex"].ToString();
                emp.EmpBirth = DateTime.Parse(r[("EmpBirth")].ToString());               
                emp.EmpCall = r["EmpCall"].ToString();
                emp.EmpProvince = r["EmpProvince"].ToString();
                emp.EmpAddress = r["EmpAddress"].ToString();
                emp.EmpPhoto = r["EmpPhoto"].ToString();
                emp.DepId = Int32.Parse(r["DepId"].ToString());
                emp.StoId = Int32.Parse(r["StoId"].ToString());
                emps.Add(emp);
            }
            this.dgvShowInfo.DataSource = emps;
        }
        public FormEmployee()
        {
            InitializeComponent();
        }

        private void FormEmployee_Load(object sender, EventArgs e)
        {
            BangdingEmpInfo();

        }

        private void TSBAdd_Click(object sender, EventArgs e)
        {
            FormEmpAdd ea = new FormEmpAdd();
            ea.Show();
        }

        private void TSBDel_Click(object sender, EventArgs e)
        {
            string empID = this.dgvShowInfo.CurrentRow.Cells[0].Value.ToString();
            string strSql = "delete from employee where EmpID = '" + empID + "'";
            string conString = "server=.;database=GXT;uid=sa;pwd=tian123";

            SqlConnection con = new SqlConnection(conString);
            con.Open();

            SqlCommand cmd = new SqlCommand(strSql, con);

            cmd.ExecuteNonQuery();
            {
                MessageBox.Show("删除成功");
            }
            //被引用为主键时无法删除

            cmd.CommandText = "select * from Employee";
            SqlDataReader reader = cmd.ExecuteReader();
            DataTable table = new DataTable();
            table.Load(reader);

            reader.Close();
            con.Close();
            this.dgvShowInfo.DataSource = table;

            BangdingEmpInfo();
        }

        private void TSBUpd_Click(object sender, EventArgs e)
        {
            //得到用户选择的员工的信息
            int empId = Int32.Parse(this.dgvShowInfo.SelectedRows[0].Cells[0].Value.ToString());
            string empName = this.dgvShowInfo.SelectedRows[0].Cells[1].Value.ToString();
            string empSex = this.dgvShowInfo.SelectedRows[0].Cells[2].Value.ToString();
            DateTime empBirth = DateTime.Parse(this.dgvShowInfo.SelectedRows[0].Cells[3].Value.ToString());
            string empCall = this.dgvShowInfo.SelectedRows[0].Cells[4].Value.ToString();
            string empProvince = this.dgvShowInfo.SelectedRows[0].Cells[5].Value.ToString();
            string empAddress = this.dgvShowInfo.SelectedRows[0].Cells[6].Value.ToString();
            string empPhoto = this.dgvShowInfo.SelectedRows[0].Cells[7].Value.ToString();
            int depId = Int32.Parse(this.dgvShowInfo.SelectedRows[0].Cells[8].Value.ToString());
            int stoId = Int32.Parse(this.dgvShowInfo.SelectedRows[0].Cells[9].Value.ToString());

            //new一个学生对象
            Employee empSomeOne = new Employee();
            empSomeOne.EmpId = empId;
            empSomeOne.EmpName = empName;
            empSomeOne.EmpSex = empSex;
            empSomeOne.EmpBirth = empBirth;
            empSomeOne.EmpCall = empCall;
            empSomeOne.EmpProvince = empProvince;
            empSomeOne.EmpAddress = empAddress;
            empSomeOne.EmpPhoto = empPhoto;
            empSomeOne.DepId = depId;
            empSomeOne.StoId = stoId;

            FormEmpUpdate eu = new FormEmpUpdate();
            eu.SomeEmp = empSomeOne;
            eu.ShowDialog();
            
            //刷新
            BangdingEmpInfo();
        }

        private void TSBInq_Click(object sender, EventArgs e)
        {
            FormEmpInquiry ei = new FormEmpInquiry();
            ei.Show();

            BangdingEmpInfo();
        }

        private void TSBsx_Click(object sender, EventArgs e)
        {
            BangdingEmpInfo();
        }


        public string empProvince { get; set; }

        //public int empAge { get; set; }

       

        private void dgvShowInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            string empPhoto = this.dgvShowInfo.Rows[e.RowIndex].Cells[7].Value.ToString();
            string photoUrl = "../../images/" + empPhoto;
            Bitmap bp = new Bitmap(photoUrl);
            this.pictureEmp.Image = bp;
            this.pictureEmp.SizeMode = PictureBoxSizeMode.Zoom;
            this.dgvShowInfo.CurrentCell = null;
        }
    }
}