员工信息管理表

实现添加，查询，和删除功能  winform

// 添加

using System;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
namespace MyFirstDB_AddDel
{
    public partial class Employee_Add : Form
    {
        static string strConn = @"server=PC-201502051038\SQLEXPRESS;database=EmployeeDB;uid=sa;pwd=chuangye";
        SqlConnection conn = new SqlConnection(strConn); //连接到数据库
        
        public Employee_Add()
        {
            InitializeComponent();
        }

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

        private void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                string sql = "insert into EmployeeInfo(姓名,年龄,性别,电话,邮编,国             家)values('"+txtName.Text+"','"+txtAge.Text+"','"+txtSex.Text+"','"+txtTel.Text+"','"+txtPostcode.Text+"','"+txtCountry.Text+"')";
                SqlCommand cmd = new SqlCommand(sql, conn);
                conn.Open();
                int i = cmd.ExecuteNonQuery();
                if (i > 0)
                {
                    MessageBox.Show("ok");
                }
               
            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message);

            }
            finally
            {
                conn.Close();
            }

            Init();
        }
        public void Init()
        {
            txtCountry.Text = "";
            txtAge.Text = "";
            txtName.Text = "";
            txtPostcode.Text = "";
            txtSex.Text = "";
            txtTel.Text = "";
            return;
        }

//查询

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.SqlClient;


namespace MyFirstDB_AddDel
{
    public partial class Employee_Info : Form
    {
        public Employee_Info()
        {
            InitializeComponent();
            DataBind();
        }

        static string strConn = @"server=PC-201502051038\SQLEXPRESS;database=EmployeeDB;uid=sa;pwd=chuangye";
        SqlConnection conn = new SqlConnection(strConn); //连接到数据库

        //public void BindData()
        //{
        public void DataBind()
        {
            try
            {
                string sql = "select * from EmployeeInfo";
                SqlDataAdapter da = new SqlDataAdapter(sql, conn); // 操作命令与数据库的连接
                conn.Open();
                DataSet ds = new DataSet();
                ds.Locale = System.Globalization.CultureInfo.InvariantCulture;

                if (ds.Tables["EmployeeInfo"] != null)
                {
                    ds.Tables["EmployeeInfo"].Clear();
                }
                da.Fill(ds);

                // MessageBox.Show(ds.Tables[0].Rows.Count.ToString());
                /*  if(ds!=null&&ds.Tables[0].Rows.Count>0)
                  {
                      MessageBox.Show("有数据");
                  }
                  MessageBox.Show(ds.Tables[0].ToString()); */
                this.dataGridView1.DataSource = ds.Tables[0];
                // MessageBox.Show("this.dataGridView1.DataSource");
                //dataGridView1.Binddata();



            }
            catch (Exception ex)
            {
                MessageBox.Show("查询失败" + ex.Message);

            }
            finally
            {
                conn.Close();

            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            DataBind();
           // return;

        }

       
       }
       
}

// 主界面

using System;
using System.Windows.Forms;


namespace MyFirstDB_AddDel
{
   
    public partial class Employee_Manage : Form
    {

        
        public Employee_Manage()
        {
            InitializeComponent();
        }
      

        private void tsmiAdd_Click(object sender, EventArgs e)
        {
            Employee_Add add = new Employee_Add();
            //add.DataBind();
            add.ShowDialog();
            return;
        }

        private void tsmiQuery_Click(object sender, EventArgs e)
        {
            Employee_Info info = new Employee_Info();
            info.ShowDialog();
            return;
        }

       
     
    }
}

// 删除

  private void btnDel_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("是否确认删除", "提示框", MessageBoxButtons.OKCancel);

            if (result == DialogResult.OK)
            {
                DataRowView drv = (DataRowView)dataGridView1.CurrentRow.DataBoundItem;
                if (drv != null)
                {
                    DataRow dr = drv.Row;
                    string id = dr["姓名"].ToString();

                    try
                    {
                        string sql = "delete from EmployeeInfo where 姓名='" + id + "'";
                        conn.Open();
                        SqlCommand cmd = new SqlCommand(sql, conn);
                        int i = cmd.ExecuteNonQuery();

                        if (i > 0)
                        {
                            MessageBox.Show("删除成功！");
                        }
                        //SqlCommand orderCmd = new SqlCommand("select ROW_NUMBER() Over(Ordered by UserID) as UserID from EmployeeInfo", conn);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("出错 ：" + ex.Message);

                    }
                    finally
                    {
                        conn.Close();
                    }

                }
                //SqlCommand orderCmd = new SqlCommand("select ROW_NUMBER() Over(Ordered by UserID) as UserID from EmployeeInfo", conn);
                DataBind();
            }
            else
            {
                return;
            }