001-CtrlSeInUpDe（增删改查）

1、using System;using System.Collections.Generic;using System.Linq;using System.Text;using MySql.Data.Common;using MySql.Data.MySqlClient;using MySql.Data;using System.Data;using System.Windows.Forms;namespace SoftwareProject class CtrlSeInUpDe string mysqlStrLogin = null; string sqlstr = null; string

2、tableName = null; MySqlConnection conn = null;/注意从网页拷贝过来的代码是不能识别 MySqlDataAdapter dataAdapter = null; DataSet ds = null; int t; public CtrlSeInUpDe(string sqlstr,string tableName) / TODO: Complete member initialization this.sqlstr = sqlstr; mysqlStrLogin = "Data Source=3;Database=jia

3、ocaiguanli;User Id=admin;Password=admin;port=3306;Charset=gb2312"/第一个参数是计算机名称，第二个参数是数据库名称，不要位置颠倒了，否则会出错的 /mysqlStrLogin = "Data Source=xcjlenovo;Database=xcj;User Id=root;Password=xcj123" this.tableName = tableName; /查询 public void query() try conn = new MySqlConnection(mysqlStrLogin)

4、; conn.Open();/链接开通 dataAdapter = new MySqlDataAdapter(sqlstr, conn);/查找到的数据放到适配器 ds = new DataSet();/声明一个结果集容器 dataAdapter.Fill(ds,tableName);/将适配器的数据填充到结果及容器中 catch (SystemException se) MessageBox.Show(se.Message); finally try if (conn != null) conn.Close();/释放内存 conn = null; catch (MySqlException

5、 me) MessageBox.Show(me.Message); /添加，修改，删除 public void inUpDel() try conn = new MySqlConnection(mysqlStrLogin); conn.Open();/链接开通 MySqlCommand command = new MySqlCommand(sqlstr,conn); t=command.ExecuteNonQuery(); catch(MySqlException e) MessageBox.Show(e.Message); finally try if (conn != null) conn.Close();/释放内存 conn = null; catch (MySqlException me) MessageBox.Show(me.M