Esempio n. 1
0
        public string oGrid_UpdateData(Hashtable hash, string tbl, string db, string schema, string pk, int[] pkvals)
        {
            //int pkval = getPKval_from_Hashtable(hash, pk);

            List <SQL_utils.dbfield> flds = Hashtable_to_dbfields(hash, tbl, db, pk);
            SQL_utils sql = new SQL_utils(db);

            string x = sql.sql_update_from_list(schema, tbl, flds, pk, pkvals);

            sql.Close();

            return(x);
        }
Esempio n. 2
0
        public string oGrid_UpdateData(Hashtable hash, string linktbl, string db, string schema, List <string> pks)
        {
            Dictionary <string, int> pkvals = getPKvals_from_Hashtable(hash, pks);

            List <SQL_utils.dbfield> flds = Hashtable_to_dbfields(hash, linktbl, db, pks);
            SQL_utils sql = new SQL_utils(db);

            string x = sql.sql_update_from_list(schema, linktbl, flds, pkvals);

            sql.Close();

            return(x);
        }