c# 数据库 交互

c# 与mysql 交互

1 c# 连接 mysql
参数存放在ini文件里，此处通过ini文件获取连接参数

   public static String getconstr()
        {
            String constr = "";
            string cfgINI = @"config\set.ini";
            if (File.Exists(cfgINI))
            {
                 IniFile ini = new IniFile(cfgINI);
                constr = "SERVER=" + ini.IniReadValue("mySqlCon", "ip") + ";DATABASE=" + ini.IniReadValue("mySqlCon", "DataBase") + ";PWD=" + ini.IniReadValue("mySqlCon", "Password") + ";UID=" + ini.IniReadValue("mySqlCon", "ID") + ";Charset=utf8";       
            }   
            return constr;
        }

查询语句

  public static DataTable listTable(string sqlStr)
        {
            DataSet ds = new DataSet();
            DataTable Dt = new DataTable();
        
            MySqlConnection conn = new MySqlConnection(getconstr());
            MySqlDataAdapter da = new MySqlDataAdapter(sqlStr, conn);
            da.Fill(ds, "tb");
            Dt = ds.Tables[0];
            return Dt;
        }

增 改 删 通用

 public static int updateSql(string sqlStr)
        {
            int b = 0;
            MySqlConnection conn = new MySqlConnection(getconstr());
            MySqlCommand cmd = new MySqlCommand(sqlStr, conn);
            conn.Open();
            b = cmd.ExecuteNonQuery();
            conn.Close();
            return b;
        }

表数据类型 导入数据库

  public static void import(DataTable table ,string 表名)
        {
            using (SqlBulkCopy sqlRevdBulkCopy = new SqlBulkCopy(getconstr()))          
            {
                sqlRevdBulkCopy.DestinationTableName = name;               
                sqlRevdBulkCopy.NotifyAfter = table.Rows.Count;                
                sqlRevdBulkCopy.WriteToServer( 表名);                            
                sqlRevdBulkCopy.Close();                                            
            }

        }