public class MyDBHelper

    {

        public static readonly string connString = ConfigurationManager.ConnectionStrings["mydb"].ToString();

        /// <summary>

        /// 查询

        /// </summary>

        /// <param name="sql"></param>

        /// <param name="parm"></param>

        /// <returns></returns>

        public static DataTable GetInfo(string sql,params SqlParameter[] parm)

        {

            //DataTable dt = new DataTable();

            //using (SqlConnection conn = new SqlConnection(connString))

            //{

            //    using (SqlCommand cmd = new SqlCommand(sql, conn))

            //    {

            //        cmd.CommandType = CommandType.Text;

            //        cmd.Parameters.AddRange(parm);

            //        SqlDataAdapter dap = new SqlDataAdapter(cmd);

            //        dap.Fill(dt);

            //        dap.Dispose();

            //    }

            //}

            //return dt;

            using (SqlConnection conn = new SqlConnection(sql))

            {

                using (SqlDataAdapter dap = new SqlDataAdapter(sql, conn))

                {

                    dap.SelectCommand.Parameters.AddRange(parm);

                    DataTable dt = new DataTable();

                    dap.Fill(dt);

                    return dt;

                }

            }

        }

        /// <summary>

        /// 增删改

        /// </summary>

        /// <param name="sql"></param>

        /// <param name="parm"></param>

        /// <returns></returns>

        public static bool Commad(string sql,params SqlParameter[] parm)

        {

            using (SqlConnection conn = new SqlConnection(connString))

            {

                using (SqlCommand cmd = new SqlCommand(sql, conn))

                {

                    cmd.CommandType = CommandType.Text;

                    cmd.Parameters.AddRange(parm);

                    int h = cmd.ExecuteNonQuery();

                    if (h > )

                    {

                        return true;

                    }

                    else

                    {

                        return false;

                    }

                }

            }

        }

    }