02Command对象的使用

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace _02Command对象的使用
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //EmpId, EmpName, EmpGender, EmpAge, EmpEmail, EmpAddress
            string constr = "Data Source=zxtiger;Initial Catalog=itcastcn;Integrated Security=True";
            using (SqlConnection con = new SqlConnection(constr))
            {
                //拼接sql语句
                string sql = string.Format("insert into Employees values('{0}','{1}',{2},'{3}','{4}')", txtEmpName.Text.Trim(), txtEmpGender.Text.Trim(), txtEmpAge.Text.Trim(), txtEmpEmail.Text.Trim(), txtEmpAddress.Text.Trim());

                //创建一个命令对象(Command)，执行sql语句
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    //cmd.CommandText = sql;
                    //cmd.Connection = con;
                    //打开连接
                    con.Open();

                    //执行sql语句
                    //ExecuteNonQuery方法用来执行insert、delete语句update语句，
                    //返回值是一个整数，表示当前语句执行后所影响的行数
                    int r = cmd.ExecuteNonQuery();
                    MessageBox.Show("插入" + r + "行。");
                }

            }
        }

        private void button1_Click_1(object sender, EventArgs e)
        {
            int r = 0;
            string constr = "Data Source=zxtiger;Initial Catalog=Itcastcn;Integrated Security=True";
            using (SqlConnection con = new SqlConnection(constr))
            {
                string sql = string.Format("delete from Employees where EmpId={0}", txtId.Text.Trim());

                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    //用之前打开，用完之后马上关闭
                    con.Open();

                    r = cmd.ExecuteNonQuery();

                }
            }
            MessageBox.Show("删除了" + r + "行。");
        }

        private void button2_Click(object sender, EventArgs e)
        {
            int r = 0;
            string constr = "Data Source=zxtiger;Initial Catalog=itcastcn;Integrated Security=True";
            using (SqlConnection con = new SqlConnection(constr))
            {
                string sql = string.Format("update Employees set empname='{0}',empgender='{1}' where empId={2}", "时绿艳", "女", txtId.Text.Trim());
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    con.Open();

                    r = cmd.ExecuteNonQuery();
                }
            }
            MessageBox.Show("成功更新了" + r + "行。");
        }
    }
}

前台页面