ADO.NET(用窗体实现crud)

//下面用WinForm结合DataGridView控件做个crud

//用到的ADO.NET对象有Connection、Command、DataAdapter、Dataset、DataReader

//另外提下using的三种用法

//①.using引入命名空间，例如：using System;

//②.using创建的对象，自动释放资源，例如：下面创建的SqlConnection对象

//③.using引入命名空间的同时赋别名，例如：using AA=System.Text;

using System;
using System.Data;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        public static string connStr = "server=.;database=winform;integrated security=true";
        /// <summary>
        /// 窗体加载
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView1.AutoGenerateColumns = false;//不自动产生列
            DataBind();           
            
        }      

        /// <summary>
        /// 刷新列表
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            DataBind();
        }       
        #region 新增
        private void button2_Click(object sender, EventArgs e)
        {
            string name = textBox1.Text.Trim();
            string pwd = textBox2.Text.Trim();
            string sex = "男";
            if (rad