（四）ADO.NET用窗体应用程序写增删查改（1.0简洁版）

一、准备工作

1.数据库创建如下字段表

2.VS窗体按钮设置

3.dataGridView数据绑定

注：绑定了数据后以后编辑列会自动弹出数据库表中所有字段，修改下"HeaderText"属性就行。

二、编写控件代码（单条执行）

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

namespace _066
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“myDatabaseOneDataSet1.users”中。您可以根据需要移动或移除它。
            this.usersTableAdapter1.Fill(this.myDatabaseOneDataSet1.users);
            // TODO: 这行代码将数据加载到表“myDatabaseOneDataSet.users”中。您可以根据需要移动或移除它。
            this.usersTableAdapter.Fill(this.myDatabaseOneDataSet.users);

        }

        private void btnAdd_Click(object sender, EventArgs e)//增加
        {
            //1.创建连接数据库字符串
            string constr = "server=服务器地址;database=数据库名;user=sa;pwd=密码";
            SqlConnection connection = new SqlConnection(constr);
            try
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = connection;
                //2.创建命令项目
                //3.新增数据
                string sqlstr = "insert into users values(04,'黄生','016676','男',28,12345)";
                cmd.CommandText = sqlstr;
                //4.执行命令
                int i = cmd.ExecuteNonQuery();
                Text = i.ToString();
                if (i > 0)
                {
                    MessageBox.Show("执行成功");
                }
                else
                {
                    MessageBox.Show("执行失败");
                }

            }
            catch (Exception ex)
            {
                Console.WriteLine("执行语句有误，请查验");
            }
        }

        private void btnDelete_Click(object sender, EventArgs e)//删除
        {
            //创建连接字符串
            string constr = "server=服务器地址;database=数据库名;user=sa;pwd=密码";
            SqlConnection connection = new SqlConnection(constr);
            try
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = connection;
                //创建命令项目
                //删除的数据
                string sqlstr = "delete from users where code=4";
                cmd.CommandText = sqlstr;
                //执行命令
                int i = cmd.ExecuteNonQuery();
                Text = i.ToString();
                if (i > 0)
                {
                    MessageBox.Show("执行成功");
                }
                else
                {
                    MessageBox.Show("执行失败");
                }
            }
            catch (Exception ex)
            {

            }
        }

        private void bntSelect_Click(object sender, EventArgs e)//查询
        {
            //创建连接字符串
            SqlConnection conn = new SqlConnection("server=服务器地址;database=数据库名;user=sa;pwd=密码");
            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from users", conn);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            DataTable dt = ds.Tables[0];
            dataGridView1.AutoGenerateColumns = false;
            dataGridView1.DataSource = ds.Tables[0];
            conn.Close();
        }

        private void btnRevise_Click(object sender, EventArgs e)//修改
        {
            //1.创建连接数据库字符串
            string constr = "server=服务器地址;database=数据库名;user=sa;pwd=密码";
            SqlConnection connection = new SqlConnection(constr);
            try
            {
                connection.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = connection;
                //2.创建命令项目
                //3.修改数据
                string sqlstr = "Update users set name='黄7' where code=3";
                cmd.CommandText = sqlstr;
                //4.执行命令
                int i = cmd.ExecuteNonQuery();
                Text = i.ToString();
                if (i > 0)
                {
                    MessageBox.Show("执行成功");
                }
                else
                {
                    MessageBox.Show("执行失败");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("执行语句有误，请查验");
            }
        }
    }
}