c#操作mysql数据库CRUD操作

c#操作mysql数据库 CRUD

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 MySql.Data.MySqlClient;

namespace dbdemo {
    public partial class FormCRUD : Form {
        public FormCRUD（） {
            InitializeComponent（）;
        }
        private void button1_Click（object sender EventArgs e） {
            TypeBLL tbll = new TypeBLL（）;
            TbType type = new TbType（）;
            type.MType = this.textBox1.Text.Trim（）;

            int cout = tbll.tabTypes_add（type）;
            if （cout != 0） {
                this.label1.Text = “添加成功“;
            }
        }
        private void btnUserAdd_Click（object sende

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2016-12-31 01:28  dbdemo\
     文件         187  2016-12-30 12:38  dbdemo\App.config
     目录           0  2016-12-31 00:38  dbdemo\bin\
     目录           0  2017-01-08 16:27  dbdemo\bin\Debug\
     文件       21504  2017-01-08 16:27  dbdemo\bin\Debug\dbdemo.exe
     文件         187  2016-12-30 12:38  dbdemo\bin\Debug\dbdemo.exe.config
     文件       42496  2017-01-08 16:27  dbdemo\bin\Debug\dbdemo.pdb
     文件       24224  2017-01-08 16:27  dbdemo\bin\Debug\dbdemo.vshost.exe
     文件         187  2016-12-30 12:38  dbdemo\bin\Debug\dbdemo.vshost.exe.config
     文件         490  2016-07-16 19:44  dbdemo\bin\Debug\dbdemo.vshost.exe.manifest
     文件      266240  2016-12-30 15:59  dbdemo\bin\Debug\MySql.Data.dll
     目录           0  2016-12-31 00:38  dbdemo\bin\Release\
     文件        5844  2016-12-31 00:41  dbdemo\dbdemo.csproj
     文件         453  2016-12-30 18:08  dbdemo\dbdemo.csproj.user
     文件        1806  2016-12-31 01:16  dbdemo\FormCRUD.cs
     文件        8418  2016-12-31 00:54  dbdemo\FormCRUD.Designer.cs
     文件        5817  2016-12-31 00:54  dbdemo\FormCRUD.resx
     文件        3959  2016-12-30 18:19  dbdemo\FrmTestMysql.cs
     文件        9440  2016-12-30 18:07  dbdemo\FrmTestMysql.Designer.cs
     文件        5817  2016-12-30 18:07  dbdemo\FrmTestMysql.resx
     目录           0  2017-01-04 03:46  dbdemo\obj\
     目录           0  2017-01-08 16:27  dbdemo\obj\Debug\
     文件         758  2017-01-08 16:27  dbdemo\obj\Debug\dbdemo.csproj.FileListAbsolute.txt
     文件        1103  2016-12-31 00:57  dbdemo\obj\Debug\dbdemo.csproj.GenerateResource.Cache
     文件       23608  2016-12-30 16:06  dbdemo\obj\Debug\dbdemo.csprojResolveAssemblyReference.cache
     文件       21504  2017-01-08 16:27  dbdemo\obj\Debug\dbdemo.exe
     文件         180  2016-12-31 00:57  dbdemo\obj\Debug\dbdemo.FormCRUD.resources
     文件         180  2016-12-31 00:41  dbdemo\obj\Debug\dbdemo.FrmTestMysql.resources
     文件       42496  2017-01-08 16:27  dbdemo\obj\Debug\dbdemo.pdb
     文件         180  2016-12-31 00:41  dbdemo\obj\Debug\dbdemo.Properties.Resources.resources
     文件        1609  2016-12-30 15:59  dbdemo\obj\Debug\DesignTimeResolveAssemblyReferences.cache
............此处省略23个文件信息