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); }
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); }