コード例 #1
0
        public static void UpdateAsso(classAsso asso)
        {
            String connectionString = DataManager.OraConnString();
            string query            = " update association_info set asso_name= '" + asso.AssoName + "',asso_abvr= '" + asso.AssoAbvr + "' where asso_id=convert(numeric,'" + asso.AssoId + "')";

            DataManager.ExecuteNonQuery(connectionString, query);
        }
コード例 #2
0
        public static void CreateAsso(classAsso asso)
        {
            String connectionString = DataManager.OraConnString();
            string query            = " insert into association_info (asso_id,asso_name,asso_abvr) values (" +
                                      " " + " convert(numeric,'" + asso.AssoId + "')," + " '" + asso.AssoName + "'," + " '" + asso.AssoAbvr + "')";

            DataManager.ExecuteNonQuery(connectionString, query);
        }