SqlHelperヘルプクラス

 public class SQlhelper
    {
        private static string strConn = ConfigurationManager.ConnectionStrings["            "].ConnectionString;
       
        /// 

        ///   
        /// 
        /// SQL  
        /// 
        public static DataTable Query(string sql)
        {
            
            using (DataTable table = new DataTable())
            {
                using (SqlDataAdapter sda = new SqlDataAdapter(sql, strConn))
                {
                    sda.Fill(table);
                }
                return table;
            }
        }
        /// 

        ///    
        /// 
        /// SQL  
        /// 
        public static int NonQuery(string sql)
        {
            int num = 0;
            using (SqlConnection conn = new SqlConnection(strConn))
            {
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    try
                    {
                        conn.Open();
                        num = cmd.ExecuteNonQuery();
                    }
                    finally
                    {
                        if (conn.State == ConnectionState.Open)
                        {
                            conn.Close();
                        }
                    }
                }
            }
            return num;
        }
    }