DataGridView控件对数据库的增、删、改、查实例

      刚学C#不久，做了个记事本提醒器，刚做的时候确实很让人火大，这也不懂那也不懂，还好顶过来了，终于，今天把记事本做完了，觉得有必要对其中用到的几个控件总结一下，一方面可以和大家交流经验，一方面也做个备份，以便以后自己忘记的时候可以看看，好，废话不多说，进入正题：

界面如下:

 

 

上面用的到控件我就不多说了

 

再把代码贴上，由于是个实例，就不做try...catch判断了

 

Form1.cs源码:

 

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

namespace DataGridView控件增删改查
{
    public partial class Form1 : Form
    {
        DataSet dataSet = new DataSet(); //定义一个数据集
        public Form1()
        {
            InitializeComponent();
        }
       
        //退出功能
        private void CenBtn_Click(object sender, EventArgs e)
        {
            ExitMothed();
        }

        public void ExitMothed()
        {
            DialogResult result;
            result=MessageBox.Show("是否确定要退出!", "退出提醒", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);

            if (result == DialogResult.OK)
            {
                Application.Exit();
            }
        }

        //显示全部信息
        public void Display()
        {
            //dataSet.Tables["BuyDetialTemp"].Clear();
            string sql = "select AID,AName,APwd,AJob from Account";    //SQL语句
            SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, DBHelper.conn);   //定义一个dataAdapter
            dataAdapter.Fill(dataSet, "Account");   //填充数据集
            dataGridView1.DataSource = dataSet.Tables["Account"];  //填充数据进控件

           
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            Display();
        }

        //删除信息
        private void DelBtn_Click(object sender, EventArgs e)
        {

            string sql = string.Format("delete from Account where AID = '{0}'", dataGridView1.SelectedRows[0].Cells[0].Value);
            SqlCommand com = new SqlCommand(sql, DBHelper.conn);  //定义SqlCommand命令
            DBHelper.conn.Open();  //打开数据库
            com.ExecuteNonQuery();  //更新数据库
            DBHelper.conn.Close();  //关闭数据训
            MessageBox.Show("记录已从数据库删除，请按刷新按钮刷新显示列表", "友情提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            dataSet.Tables["Account"].Clear();  //清空控件上的内容
            Display();  //显示数据库内容
        }

        //刷新功能
        private void RefurBtn_Click(object sender, EventArgs e)
        {
            dataSet.Tables["Account"].Clear();  //清空控件上的内容
            Display();  //显示数据库内容
        }
       
        //查询功能
        private void SearchBtn_Click(object sender, EventArgs e)
        {
            string sql = string.Format("select AID,AName,APwd,AJob from Account where AID = '{0}'", TextBIOD.Text.ToString().Trim());
            dataSet.Tables["Account"].Clear(); 
            SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, DBHelper.conn);
            dataAdapter.Fill(dataSet, "Account");
            dataGridView1.DataSource = dataSet.Tables["Account"];
        }

        //添加功能
        private void AddBtn_Click(object sender, EventArgs e)
        {
            DataTable mytable = dataSet.Tables["Account"];

            string x = textBox1.Text;
            string y = textBox2.Text;
            string z = textBox3.Text;
            string m = textBox4.Text;

            string commandStr = "INSERT INTO Account(AID,AName,APwd,AJob) VALUES ('" + x + "','" + y + "','" + z + "','" + m + "')";     //创建插入语句
            SqlCommand command = new SqlCommand(commandStr, DBHelper.conn);
            DBHelper.conn.Open();
            MessageBox.Show("添加内容成功!");

            command.ExecuteNonQuery();
            DBHelper.conn.Close();

            dataSet.Tables["Account"].Clear();
            Display();

        }

        public void text()
        {
           
        }

        //修改功能
        private void RevBtn_Click(object sender, EventArgs e)
        {
            DataTable mytable = dataSet.Tables["Account"];

            string x = textBox1.Text;
            string y = textBox2.Text;
            string z = textBox3.Text;
            string m = textBox4.Text;

            string commandStr = string.Format("update Account set AID = '{0}',AName = '{1}',APwd = '{2}',AJob = '{3}' where AID = {4}", textBox1.Text.Trim(), textBox2.Text.Trim(), textBox3.Text.Trim(), textBox4.Text.Trim(), dataGridView1.SelectedRows[0].Cells[0].Value);
            SqlCommand command = new SqlCommand(commandStr, DBHelper.conn);
            DBHelper.conn.Open();
            MessageBox.Show("更新成功!");

            command.ExecuteNonQuery();
            DBHelper.conn.Close();

            dataSet.Tables["Account"].Clear();
            Display();
        }
    }
}

 

 

DBHelper.cs源码:

 

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

namespace DataGridView控件增删改查
{
    class DBHelper
    {
        public static string conStr = "Data Source =.;Initial Catalog = AworkeDB;Integrated Security=True";
        public static SqlConnection conn = new SqlConnection(conStr);
    }
}

 

 

这是第一个，明天再写listView控件的