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
     
       emps = new List
      
       ();            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;        }    }}