基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

c#操作mysql数据库 CRUD

class SqlHelper {
        //返回链接数据库的字符串
        public static string ConnString {
            get {
                return "Data Source='localhost';Database='dbdemo';User Id='root';Password='wdf123';charset='utf8'";
            }
        }
        /// <summary>
        /// sqlserver 执行通用的添加，修改，删除操作 
        /// </summary>
        /// <param name="sql">insert/update/delete语句</param>
        /// <param name="pars">参数类型的数组</param>
        /// <returns>int 受影响的条数</returns>
        public static int mssql_exec(string sql,SqlParameter[] pars) {
            SqlConnection conn = new SqlConnection(ConnString);

            try {
                if (conn.State == ConnectionState.Closed) {
                    conn.Open();
                }
                SqlCommand cmd = new SqlCommand(sql, conn);
                if (pars != null && pars.Length > 0) {
                    foreach (SqlParameter p in pars) {
                        cmd.Parameters.Add(p);
                    }
                }
                int count = cmd.ExecuteNonQuery();
                return count;
            }catch(Exception ex){
                throw ex;
                //return 0;
            } finally {
                conn.Close();
            }
        }
        /// <summary>
        /// sqlserver 执行通用的添加，修改，删除操作 
        /// </summary>
        /// <param name="sql">insert/update/delete语句</param>
        /// <param name="pars">参数类型的数组</param>
        /// <returns>int 受影响的条数</returns>
        public static int mysql_exec(string sql, MySqlParameter[] pars) {
            MySqlConnection conn = new MySqlConnection(ConnString);
            try {
                if (conn.State == ConnectionState.Closed) {
                    conn.Open();
                }
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                if (pars != null && pars.Length > 0) {
                    foreach (MySqlParameter p in pars) {
                        cmd.Parameters.Add(p);
                    }
                }
                int count = cmd.ExecuteNonQuery();
                return count;
            } catch (Exception ex) {
                throw ex;
                //return 0;
            } finally {
                conn.Close();
            }
        }